SQL Server 2005 MDX Training
Course
In London
£ 1,025
+ VAT
Description
-
Type
Course
-
Location
London
-
Duration
3 Days
Facilities
Location
Start date
London
See map
1 Alie Street, London, E1 8DE
Start date
On request
Reviews
Have you taken this course?
Course programme
Fundamental Concepts
Tuple -Based Expressions
Reporting Services and MDX Secrets
- Hands-on introduction to the basic tools for working with MDX: using the BI Development Studio tocreate calculated members and using Management Studio to create SQL queries.
- In-depth examination of the power of using sets to build MDX queries, including new SQL 2005 functionality such as subcubes , subq ueries , and working with AutoExists behaviour between attributes.
Tuple -Based Expressions
- Exploration of formulas that are based on discrete values; including percent of total and time -based calculations.
- Exploration of formulas that are based on ranges of values, including year -to-date calculations, rolling time calculations, and statistical calculations.
- Exploration of new script commands, including replacing IIF constructs with sub cube expressions, and controlling automatic cell calculation behaviour.
- Several examples of complex expressions, including the use of expressions in bubble -up formatting, creating dynamic security, and creating KPI calculations.
Reporting Services and MDX Secrets
- Secrets on how to use Reporting Services effectively with an Analysis Services cube as the data source, including managing non -additive measures and using extended cell properties such as server -based formatting.
- Secrets for how to build effective queries, including hiding empty values efficiently and working with various attribute and hierarchy relationships.
- Secrets for how to build effective calculations, including ways to make trade-off decisions between formulas and effective cube design
SQL Server 2005 MDX Training
£ 1,025
+ VAT