Description
Who should attend
Data Modelers
Prerequisites
- Knowledge of your business requirements
- IBM Planning Analytics: Analyze Data and Create Reports (V2.0.x)
Outline: IBM Planning Analytics: Design and Develop Models in Planning Analytics Workspace (V2.0.x) (P8362G)
Overview of IBM Planning Analytics
• Modeling in IBM Planning Analytics: overview
• IBM Planning Analytics: data tier
• In-memory data storage
• Calculating versus caching data
• Important files in TM1 Create dimensions • What is a dimension?
• What are weights?
• Time dimensions
• Member attributes
• Hierarchies Load and maintain data
• What is TurboIntegrator?
• Defining data sources and process parameters in TurboIntegrator
• Validate and run processes
• TurboIntegrator chores Add business rules
• What are rules?
• How do you create a rule?
• Review rule processing
• Use a rule to override aggregation
• Use a function in a rule Optimize rule performance
• Understanding consolidations and sparsity
• Optimize your rules using SKIPCHECK
• Using feeder statements
• Inter-cube feeders
• Feeding string rules
• Trace cell values and feeders Transfer data into your model
• Link cubes with different dimensions
• Review TurboIntegrator
• Dealing with data
• Use IBM Planning Analytics as a data source
• Tips for scripting in TurboIntegrator Customize drill paths
• View related data
• Create a drill path Use rules for advanced modeling
• Describe a virtual cube
• Utilize a lookup cube
• Use relative spreading and a spread profiles cube
• Use attributes in rules Convert currencies
• Converting currency: overview
• Review control cubes Model for different fiscal requirements
• Understanding time
• Discrete time dimensions
• Continuous time dimensions
• Develop a continuous time model
