System Document IBM Planning Analytics & Apliqo UX
Last updated
Last updated
https://app.eraser.io/workspace/dBd3TWQaRzxl8Czshzut?elements=-JxQ-kdz0v-fp4XL8JhM_w
Azure Views
This cube is used for Regulatory Approval and Product Launch activities. It is also used to generate the Approval and Launch Calendar.
Data Source: User input
Dimensions
Dimension
Description / Notes
Sample Elements
Version
Categorizes data as either realized outcomes (Actuals) or various types of planning and analysis scenarios like Forecasts, Budgets, and Snapshots.
Actual, Forecast, 2023 AOP
Time
Structures data by month, with hierarchical roll-ups to quarters and years, and includes period-to-date aggregations like QTD and YTD.
2023-10, 2023-Q3, 2023
Region
Organizes data at the country level and aggregates it into broader geographical areas such as APAC, EMEA, LAC, and ultimately to Total Region.
China, APAC, Total Region
AS Number
AS-12345, Total AS Number
AL Measure
Approval Month, Launch Month, Launch Qty - Trunk
Calculations
Launch Mgr from AS Number attribute (for “Existing” Regions = Mkting contact, for “New” = “Int’l”)
DIAGRAM
Layout Design
User Experience Considerations
Desired Outputs
KPIs
Report Mockups
Formulas (rules) by Cube
Logic
Assumptions
Sample Data
Attribute Type: A = alias, S = string, H = hierarchy (also string), N = numeric
Dimension
Description
Sample Elements
Attributes & Hierarchies
Subsets
AL Measure
Default
AS Number
Model Number, Product Family
Case Measure
Case Type
Demand Measure
Demand Type
Region
Rep Measure
Rep Type
Time
Version