Course Oracle OLAP

Duration (days): 3
Price (CZK): 20000

Oracle OLAP topics:

Building OLAP Cubes

• Creating an Analytic Workspace
• Defining Dimensions and Levels
• Defining Hierarchies
• Defining and Reviewing Attributes
• Mapping Dimensions to Relational Sources
• Using Templates to Define Data Objects
• Defining Cubes
• Creating Measures
• Mapping Cubes to Relational Sources
• Enabling Query Rewrite to Cube MVs (optional)
• Loading and Viewing Cube Data

Querying OLAP Cubes

• Connecting to the OLAPTRAIN Schema in SQL Developer
• Executing a Simple OLAP Cube Query
• Using Level and Member Conditions in a Query
• Adding Calculated Measures to a Query
• Leveraging Embedded Total Features of Cubes in a Query
• Performing Drill-down in a Query
• Using Parameterized Drilling
• Using Cube MVs for Query Rewrite

Using Microsoft Excel With Oracle Cubes

• Connecting to the Oracle OLAP Cube
• Creating an output Report
• Performing and Sharing Ad Hoc Analysis
• Adding A Chart

Creating OBIEE Metadata for OLAP Cubes

• Enable the OBIEE Plug-in for AWM
• Generate the OBIEE Metadata for Oracle OLAP
• Create the OBIEE Metadata Repository

Querying OLAP Data Using Oracle BI Answers

• Identify the OLAP 11g Repository
• Query OLAP Data

Creating Interactive APEX Reports Over OLAP Cubes

• Import and Install a Predefined Workspace
• Create an Application
• Create an Interactive Sales Analysis Report
• Format the Interactive Report
• Add Drilldown Capabilities and Run the Report
• Add a Report Reset Button

All course schedules I will make suitable according your individual requirements.
If course topics are not suitable for you then contact me contact and we will come to topics meet your individual bussiness needs