Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

If you have not yet introduced yourself to the basic concepts of flex.bi then please start with an overview of flex.bi concepts and learn how to analyse and create reports. This tutorial will explain how to define new calculated members using MDX calculation formulas.

If you have never worked with MDX before, we suggest you watch this video: MDX basic concepts 

Dimensions and hierarchies

...

Each dimension typically will have a default All member which can be used to get totals of measures per this dimension. If the Customers dimension has a default All member named a All Customers then you can reference it with [Customers].[All Customers]. Since the default All member can be renamed it is safer to use [Customers].[DefaultMember] to get the same result. The time dimension has two default All members for each hierarchy - [Time].[DefaultMember] and [Time].[Weekly].DefaultMember.

 When you want to reference the top level dimension members then you have to use the following format - [dimension or of hierarchy name].[member name]. E.g. [Customers].[USA] will reference the USA member from the top level of the Country level. To reference detailed level dimension members* you need to specify the full "hierarchy path" to this member, e.g. [Customers].[USA].[CA] to reference the CA member in the State Province level under the USA parent member. Or [Customers].[USA].[CA].[San Francisco] to reference a city etc.

 All measures are in the top level of the Measures dimension and you can reference them with e.g. [Measures].[Store Sales], [Measures].[Store Cost] etc.

...