Oracle Fusion Middleware 12c (12.2.1)

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