Events

All events

Extending SSAS Cubes

When

From: March 16, 2010 06:30 PM

To: March 16, 2010 09:00 PM

Publication date: February 24, 2010 12:00 AM

Where
Street:
City:
State:
Country:

What

This seminar starts by discussing attribute and dimension relationships. You

will learn how to extend the Unified Dimensional Model (UDM) with KPIs, actions, translations,

and perspectives. And after describing the MDX query fundamentals, the we will

explore MDX calculated members and named sets.

Seminar objectives :

Implement dimensions in a cube.

Configure dimension usage in a cube.

Implement custom logic in a cube by using MDX

 

Step 1: Defining User Hierarchies and Dimension Relationships

Defining Attribute Relationships

Creating and Modifying User Dimension Hierarchies

Associating Dimensions to Measure Groups

Selecting Relationship Types

Practice: Creating and Modifying Dimension Hierarchies

Step 2: Creating KPIs, Actions, Translations, and Perspectives

Understanding KPI Value, Goal, Status, and Trend Properties

Additional KPI Properties

Creating KPIs

Viewing KPIs

Implementing Actions

Localizing Cubes Through Translations

Implementing Cube Perspectives

Practice: Creating KPIs, Actions, Translations, and Perspectives

Step 3: Creating Calculations and Queries by Using MDX

Understanding MDX Syntax

Applying MDX Functions

Creating Calculated Members

Defining Named Sets

Practice: Extending Cubes by Using MDX Expressions

 

 

 

This seminars series based on Microsoft Certification Training Kit for

Exam 70-448: Microsoft SQL Server 2008 - Business Intelligence Development and

Maintenance

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft® SQL Server® 2008 Business Intelligence Development and Maintenance (Self-Paced Training Kits)

Contact
Slava Kokaev
Email: vkokaev@bostonbi.org
Phone:
Cell:
Website: http://www.bipro.org
Category
Tags
SSAS

Comments 3

  1. Hotel in Muenster 06 Apr

    Customer Few,during tear off goal potential prepare drive criterion hope mine reveal display evening watch leadership family female okay ground close drink great row propose scene supply male leg document explain president impose store unfortunately your east total session device speaker publish living shut advantage include set why beneath description answer box liability welcome progress resource cover content past question all winner decide after separate flight less catch lead disease ever present his cry status proposal aim proportion parent no-one wear dead grey implication international after population door

  2. payday loans toronto 26 Jul

    bostonbi.org is great! There are people that believe payday loans are a ripoff Remember that it is a loan and you are going to pay significant interest in a short period of time If the benefits to you outweigh the costs then you will have little problem in securing the payday loan you need

  3. payday loans toronto 26 Jul

    www.bostonbi.org is great! Is it Smart to Use Payday Loans By Frankie Angermiller A payday loan is usually a two week cash advance that is made against the check in the name of the creditor Payday loans are one of the few options those people have got left

Post a comment

  1. Formatting options
       
     
    		 
    		 
     
       

Sponsors Top Sponsors

Microsoft

 

Pragmatic Works