Oracle Business Intelligence Enterprise Edition 12.2.1.1.0
Tasks
Documentation for users modeling data for use in Oracle BI EE analyses and dashboards
Model
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 Linux and UNIX
- Import metadata from:
Create the Physical Layer
- Set up database objects
- Set up connection pools
- Create physical tables from:
- 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:
- Create dimensions with:
- Model bridge tables
- Create and manage logical table sources
Create the Presentation Layer
- Create presentation layer objects:
Secure Data and Metadata
- Protect business data by setting up row-level security:
- Protect repository metadata by granting:
- 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
- Implement source control to manage 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