Description
At Sixe Engineering we have been providing official IBM training around the world for over 12 years. Get the best training from our specialists in Europe. We have important discounts and offers for two or more students.
Course details
IBM course code: P8362G | Category: IBM Planning Analytics / IBM Planning Analytics |
Delivery: Online & on-site** | Course length in days: 5 |
Target audience
Data Modelers
Desired Prerequisites:
- Knowledge of your business requirements
- IBM Planning Analytics: Analyze Data and Create Reports (V2.0.x)
Instructors
The great majority of the IBM courses we offer are taught directly by our engineers. This is the only way we can guarantee the highest quality. We complement all the training with our own materials and laboratories, based on our experience during the deployments, migrations and courses that we have carried out during all these years.
Added value
Our courses are deeply role oriented. To give an example, the needs for technology mastery are different for developer teams and for the people in charge of deploying and managing the underlying infrastructure. The level of previous experience is also important and we take it very seriously. That is why beyond (boring) commands and tasks, we focus on solving the problems that arise in the day to day of each team. Providing them with the knowledge, competencies and skills required for each project. In addition, our documentation is based on the latest version of each product.
Agenda and course syllabus
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
Do you need to adapt this syllabus to your needs? Are you interested in other courses? Ask us without obligation.
Locations for on-site delivery
- Austria: Vienna
- Belgium: Brussels, Ghent
- Denmark: Cophenhagen
- Estonia: Tallinn
- Finland: Helsinki
- France: Paris, Marseille, Lyon
- Germany: Berlin, Munich, Cologne, Hamburg
- Greece: Athens, Thessaloniki
- Italy: Rome
- Louxemburg: Louxembourg (city)
- Netherlands: Amsterdam
- Norway: Oslo
- Portugal: Lisbon, Braga, Porto, Coimbra
- Slovakia: Bratislava
- Slovenia: Bratislava
- Spain: Madrid, Sevilla, Valencia, Barcelona, Bilbao, Málaga
- Sweden: Stockholm
- Turkey: Ankara
- United Kingdom: London