SQL Server 2005 MDX Training

Pygmalion Training

Course

In London

£ 1,025 + VAT

The best SQL Server courses

See all

See all

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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Fundamental Concepts
  • 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.
Set-Based 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.
Set-Based Expressions
  • Exploration of formulas that are based on ranges of values, including year -to-date calculations, rolling time calculations, and statistical calculations.
Scripting and Formulas
  • Exploration of new script commands, including replacing IIF constructs with sub cube expressions, and controlling automatic cell calculation behaviour.
Advanced Expression Applications
  • 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.
Query Secrets
  • Secrets for how to build effective queries, including hiding empty values efficiently and working with various attribute and hierarchy relationships.
Calculated Member Secrets
  • Secrets for how to build effective calculations, including ways to make trade-off decisions between formulas and effective cube design

See related categories

SQL Server 2005 MDX Training

£ 1,025 + VAT

The best SQL Server courses

See all

See all