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

Data Modelers

• 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

• Knowledge of your business requirements
• IBM Planning Analytics: Analyze Data and Create Reports (V2.0.x)

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