|
|  |  | |
In an extensible Data warehouse, the steps to incorporate the new dimension in analysis are straightforward:
-
Create a new staging table for the new attribute dimension
-
Create a new dimension table for the new attribute
-
Add the attribute business code to the Staging Fact table
-
Add the new attribute surrogate key to the Fact table
-
Enhance the nightly extract to fill the new staging table and fill the new attribute code on the facts
-
Add the default record to the new dimension table and fill the new attribute key on the existing fact records with the default key
-
Develop the ETL to move the dimension records from staging to fact
-
Enhance the ETL to translate the attribute code to the attribute key on the fact records
-
Add the new dimension to the OLAP cube
-
Relate the new dimension to the new fact attribute
-
Deploy and build the new cube Upgrade the portal analysis to include the new dimension on the filters, the rows, or the columns.
BIAnalytix is a Media data warehouse and Business intelligence system that is extensible and supports the enhancements outlined above to extend the BI portal with new dimensional analysis when it becomes available from the source systems.
|
|
