Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Videos (30m)
    • Decide when to create named set and calculated member

      2:50
    • Sum Function

      11:13
    • Calculated Member Deployment starts with Dimension Name

      1:48
    • Allmembers

      2:26
    • Dynamic and static Named Set

      11:31

About This Class

Till MDX Training Part 4 you have seen that all the calculated members starts with 

[Measures].[NameoftheCalculatedMember].

But in theMDX Training Part 5 i will display one calculated member which starts with Dimension Name such as 

[DimensionName].[AttributeName].[NameoftheCalculatedMember]

This demo i will show with the help of Sum function

Later i will also discuss how can you deploy that calculated member in SSAS Cube.

I will also discuss the difference between Dynamic and Static Named Set

--

Students

--

Projects

0

Reviews (0)

Vikas Munjal

Microsoft Certified Trainer

I am Microsoft Certified Trainer. Having around 10 Years of rich experience.Successfully self-employed, i am a trusted consultant for businesses large and small. Currently working as a Corporate Trainer & Consultant for SQL Server and Microsoft Business Intelligence . Also worked as a SQL Server Developer. Lives in Delhi,India.

My style is to teach in such a way so that student should be able to create images or diagrams of the concept in his/her mind . Because i believe we understan...

See full profile

Technology Data Science MDX