Oracle Business Intelligence EE 11.1.1.9

Get Started with BI Modeling

• Understand the architecture
• Plan the business model
• Design the model repository
• Create the new repository
• Set up data sources on Windows
• Set up data sources on Linux and UNIX
• Import metadata from:
  • relational data sources
  • multidimensional data sources
  • XML datasources
  • ADF dataources

Create the Physical Layer

• Set up database objects
• Set up connection pools
• Create physical tables from:
  • relational datasources
  • multidimensional datasources
  • Essbase datasource
  • Hyperion datasources
  • Oracle OLAP datasources
• Create physical foreign keys and joins
• Use hints to optimize SQL statements

Create the Business Model and Mapping Layer

• Create the business model
• Create business model objects:
  • logical tables
  • logical joins
  • logical columns
• Create dimensions with:
  • Level-based hierarchies
  • Parent-Child hiearchies
• Model bridge tables
• Create and manage logical table sources

Create the Presentation Layer

• Create presentation layer objects:
  • subject areas
  • presentation tables
  • presentation columns
  • presentation hierarchies
  • presentation levels

Secure Data and Metadata

• Protect business data by setting up row-level security:
  • in the repository
  • in the database
• Protect repository metadata by granting:
  • permissions on individual repository objects
  • multiple object permissions to application roles
• Protect system performance by setting query limits

Manage the Repository

• Compare repositories
• Equalize objects
• Merge repositories
• Query repository metadata
• Change repository password

Set up Multiuser Development Environments (MUD) and Source Control

• Implement a multiuser development environment:
  • make changes to repositories
  • publish changes to repositories
  • branch repositories
  • follow best practices for managing multiuser repository development
  • review a MUD case study
• Implement source control to manage repository development:
  • set up the BI system for source control
  • day-to-day repository development
• Use MUD and source control together

Use Repository Variables and Session Variables

• Use static and dynamic repository variables
• Use system and non-system session variables for authentication
• Set variables using initialization blocks
• Set session variables from multiple data sources

Reference

• Logical SQL syntax and functions
• Merge rules
• Supported data types
• XML schema files for ADF mapping
• BI Server XML API reference:
  • MDS XML API
  • generic XML API