Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (40m)
    • Calculated Member

      12:33
    • Query Scoped and Session Scoped Calculated Member

      7:55
    • Multiple Calculated Members

      1:40
    • Named Set

      6:50
    • Orderset - One example of named set

      9:09
    • The result of a Tuple will return a Set

      1:56

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

--

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