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
...
When writing calculation formulas you will need to reference dimensions, dimension hierarchies, hierarchy levels and other existing dimension members. In the MDX query language all names are enclosed in square brackets [].
To reference a dimension you just enclose its name in square brackets, e.g. [Customers], [Time] or [Measures].
If a dimension has just one hierarchy then you can reference the primary hierarchy in the same way as a dimension, e.g. [Customers] or [Measures]. When you import the Time dimension then it will automatically create the main hierarchy (year, quarter, month and day levels) as well as a Weekly hierarchy (year, week and day levels). Time will reference the Time dimensions main hierarchy but Time.Weekly will reference the Time dimensions Weekly hierarchy.
...