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: B6061G | Category: Cognos / Cognos Analytics v11.0 |
| Delivery: Online & on-site** | Course length in days: 2 |
Target audience
Report authors working with dimensional data sources.
Desired Prerequisites:
• IBM Cognos Analytics: Author Reports Fundamentals (v11.0)
• Knowledge of your business requirements
• Knowledge of dimensional data
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
1. Introduction to Dimensional Concepts
• Identify different data sources and models
• Investigate the OLAP dimensional structure
• Identify dimensional data items and expressions
• Differentiate the IBM Cognos Analytics query language from SQL and MDX
• Differentiate relational and dimensional report authoring styles
2. Introduction to Dimensional Data in Reports
• Work with members
• Identify sets and tuples in IBM Cognos Analytics
3. Dimensional Report Context
• Understand the purpose of report context
• Understand how data is affected by default and root members
4. Focus Your Dimensional Data
• Compare dimensional queries to relational queries
• Explain the importance of filtering dimensional queries
• Evaluate different filtering techniques
• Filter based on dimensions and members
• Filter based on measure values
• Filter using a slicer
5. Calculations and Dimensional Functions
• Use IBM Cognos Analytics dimensional functions to create sets and tuples
• Perform arithmetic operations in OLAP queries
• Identify coercion errors and rules
6. Functions for Navigating Dimensional Hierarchies
• Navigate dimensional data using family functions
7. Relative Functions
• Navigate dimensional data using relative functions
• Navigate dimensional data using relative time functions
8. Advanced Drilling Techniques and Member Sets
• Understand default drill-up and drill-down functionality
• Identify cases when you need to override default drilling behavior
• Configure advanced drilling behavior to support sophisticated use cases
• Define member sets to support advanced drilling
• Define member sets to support functions
9. Set Up Drill-Through Reports
• Navigate from a specific report to a target report
• Drill down to greater detail and then navigate to target report
• Navigate between reports created using different data sources
10. End-to-End Workshop
• Review concepts covered throughout the course
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
