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
...
expression -- comment until end of line
/* multi line
comment
*/
Special comments with annotations
Note |
---|
Available on flex.bi cloud or Flex.bi Private starting from version 3.1. |
-- annotations.group=...
Put the calculated member in the specified group in the Calculated members section of the dimension in the report builder.
-- annotations.disable_drill_into=true
Do not allow the Drill into action for this calculated member.
-- annotations.disable_drill_across=true
Do not allow the Drill across action for this calculated member.
-- annotations.disable_drill_through=true
Do not allow the Drill through action for this calculated member.
-- annotations.disable_drill=true
Disable all drill actions for this calculated member.
List of all MDX functions
...