1 / 18

Oracle OLAP Creating Cubes Part 1: Concepts

Oracle OLAP Creating Cubes Part 1: Concepts. Marty Gubar Oracle BI/DW Product Management. Creating Cubes Sources. REGION. CUST. SALES FACT. INVENTORY. ITEM. TIME. Creating Cubes Sources: Table Relationships. REGION. CUST. SALES FACT. INVENTORY. ITEM. TIME.

skyla
Download Presentation

Oracle OLAP Creating Cubes Part 1: Concepts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle OLAP Creating Cubes Part 1: Concepts Marty Gubar Oracle BI/DW Product Management

  2. Creating CubesSources REGION CUST SALES FACT INVENTORY ITEM TIME

  3. Creating CubesSources: Table Relationships REGION CUST SALES FACT INVENTORY ITEM TIME

  4. Creating CubesSources: Column Relationships REGION ITEM CUST item_key type_key cat_key SALES FACT INVENTORY ITEM TIME

  5. Creating CubesDimensions Formalize Data Relationships Geography REGION CUST SALES FACT Product INVENTORY ITEM Time TIME

  6. Creating CubesDimensions Formalize Data Relationships Geography REGION ProductLevel-based Hierarchy CUST Category SALES FACT Product Type INVENTORY Item Define the business relationships ITEM Time TIME

  7. Creating CubesDimensions Formalize Data Relationships Geography REGION ProductComplex Hierarchy CUST SALES FACT INVENTORY ITEM Time TIME Model complex hierarchical relationships

  8. Creating CubesDimensions Formalize Data Relationships Geography REGION ProductHierarchical Relationships CUST Parent SALES FACT Children Descendants INVENTORY ITEM Time TIME Use family references to simplify calculations

  9. Creating CubesTime Dimension Supports Any Calendar Type Geography REGION CUST SALES FACT Product INVENTORY Time dimension simplifies time-series calculations ITEM Time TIME

  10. Creating CubesArray-based Access of Summary Data REGION Sales Cube CUST Geography Product Product Time Time SALES FACT INVENTORY Inventory Cube ITEM TIME

  11. Creating CubesAggregation Rules REGION Sales Cube ∑ Aggregation Rules Product: Sum Geography: Sum Time: Sum CUST Geography Product Product Time Time SALES FACT INVENTORY Inventory Cube ITEM ∑ Aggregation Rules Product: Sum Time: Hierarchical Last TIME

  12. Creating CubesRich, Embedded Analytic Calculations REGION Sales Cube • Calculations • Sales • YTD • YTD Growth • Market Share • Product Alert • Moving Average • … CUST Geography Product Product Time Time SALES FACT INVENTORY Inventory Cube ITEM • Calculations • Balance • Inventory Cost • Stock Out • … TIME

  13. Creating CubesTune Physical Properties REGION Sales Cube Physical Properties: Cost Based Aggregation: 30 CUST Geography Product Product Time Partition: Quarter Time SALES FACT INVENTORY Inventory Cube ITEM TIME

  14. Creating CubesTune Physical Properties REGION Sales Cube Physical Properties: Cost Based Aggregation: 30 CUST Geography Product Geography Product Product Time Partition: Quarter Time Compress Aggregates: True SALES FACT INVENTORY Inventory Cube ITEM TIME Time

  15. Cube ViewsAutomatically Synchronized with Cubes Smart Search TIME Web Analysis SALES CUBE Smart Space Desktop Gadgets GEOGRAPHY INVENTORY CUBE SmartView Custom Application (SOAP, J2EE, .Net MDX, etc.) Hyperion Visual Explorer PRODUCT

  16. Cube-based Materialized ViewsTransparently Enhance Query Performance Hyperion Financial Reporting Smart Search Automatic Query Rewrite Web Analysis SALES FACT SALES CUBE MV Smart Space Desktop Gadgets SmartView Custom Application (SOAP, J2EE, .Net MDX, etc.) Hyperion Visual Explorer Statistical Package (SPSS, etc.)

  17. Creating Cubes with Analytic Workspace Manager CreatingCubes

  18. For More Information search.oracle.com Oracle OLAP Oracle Technology NetworkFor demonstrations, white papers, tutorials and more, visit: http://www.oracle.com/technology/products/bi/olap/olap.html

More Related