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
...
| Note |
|---|
Available on flex.bi cloud or Flex.bi Private starting from version 3.1. |
You can add special comments in the formulas with annotations for the calculated member. These annotations are used in the flex.bi user interface to group calculated members or to allow or disable certain actions:
-- 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
...