MDX Training Part 4 | Vikas Munjal | Skillshare
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (40m)
    • Calculated Member

    • Query Scoped and Session Scoped Calculated Member

    • Multiple Calculated Members

    • Named Set

    • Orderset - One example of named set

    • The result of a Tuple will return a Set


About This Class

In this video series i will expalin what are calculated members and named sets

Calculated members:

Calculated members are nothing but calculations applied over the members of the cube. You may want to create members like Profit / Profit Percentage / Product Count etc which are  nothing but the measures you create based on the members.

Named Set

In some cases you want to use a set expression frequently. Defining it repeatedly is a burden for developers. So you create a named set and give an alias so that you can use it whenever needed

Suppose you want to use a set of members like "Top 5 Large resellers" in many MDX expressions. 

Calculated members as well as named set are Query Scoped and Session Scoped.
I will expalin you that as well





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

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 SSAS MDX
Report class