MDX für Microsoft SQL Server - Schulung in Berlin

You will learn how to independently create MDX queries and MDX calculations and use them accurately in practice.

Description

You will learn to create MDX queries and calculations independently and to use them safely in practice. Through the consistent development from simple examples to complex solutions, the essential concepts of MDX are applied and deepened. In addition, you will learn about individual MDX queries and functions in detail and examine the effects on query performance.

Target group

Advanced users, report designers

Duration

1 day

Content in detail

Introduction and Basics

• Introduction and terminology
• Components of an MDX query
• Concept Member: CurrentMember, DefaultMember, Calculated Member

Concepts and navigation

• Sorting and filtering members
• Concept SET and TUPLE
• Navigating through hierarchies
• Navigation on the timeline / referencing periods

Functions

• Aggregate functions, interactions and filters
• IIF and filter functions
• SET functions at a glance

Calculations, tuple and cubes

• Calculation types in MDX
• Simple tuples Assignments
• Cubes and Subcube Expressions

Advanced Topics

• Error Handling
• Automatic Aggregation after Calculations
• Calculations vs. Data Modeling
• Time Considerations and Calculation of Time intelligence
• Performance aspects

ATVISIO consulting practice: "Best practice" and avoidable errors

New: Book online training now

On the mutually agreed training day, your trainer will contact you and first mirror his screen onto your computer - and vice versa if necessary. Ideally, you should have a second PC or laptop ready for your own exercises. Then the training can begin.

With online training you save time and travel costs and can use the hours gained productively for your daily business.

For further information, call us.

Further information

For companies, this training can also be carried out as in-house training. Please contact Rebecca Schlesser about this - by email schlesser@atvisio.de or by phone 0631/4140140