Quick Overview of the steps required in an ETL package to load a PerformancePoint Planning application:
- Sync Dimensions from App to Staging (call ppscmd)
- Sync Models from App to Staging (call ppscmd)
- Stage Dimensions into Label table (data flow)
- Load Dimensions (call ppscmd)
- Stage Hierarchies into Label table (data flow)
- Load Dimensions (call ppscmd)
- Reindex Dimension tables (sql command)
- Stage Fact into Label table (data flow)
- Load Fact (call ppscmd)
- Reindex MG tables
- Deploy Model (call ppscmd)
No comments:
Post a Comment