Schulung - IBM P8362G - IBM Planning Analytics: Design and Develop Models in Planning Analytics Workspace (V2.0.x)

Course Outline

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

Objective

• Overview of IBM Planning Analytics
• Create dimensions
• Load and maintain data
• Add business rules
• Optimize rule performance
• Transfer data into your model
• Customize drill paths
• Use rules for advanced modeling
• Convert currencies
• Model for different fiscal requirements