Managing Data Sources for the BI Beans and OLAP API - OLAP

Applications built using the BI Beans and the OLAP API can have as a data source either an analytic workspace or a relational schema (star or snowflake). This guide is written primarily to describe the creation and management of analytic workspaces. However, the information for creating a relational data warehouse for use by the BI Beans and the OLAP API is also contained here.

Take these steps if you plan to use a star or snowflake schema as the data source for OLAP applications, and you do not plan to create an analytic workspace:

  1. Create CWM1 or CWM2 metadata
  2. Using a SQL command processor such as SQL*Plus, issue this command to make the metadata accessible to the BI Beans.
    EXECUTE CWM2_OLAP_METADATA_REFRESH.MR_REFRESH
  3. Create materialized views

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

OLAP Topics