User Calculated Measures

User Calculated Measures

While analyzing data with grid analysis, any user could use OLAP database defined calculated measures or create ad-hoc “User Calculated Measures” that will be stored in Kyubit Business Intelligence application and could be reused in different analyses and shared with other users using Kyubit Business Intelligence software.



OLAP software To create ad-hoc “User Calculated Measure”,

  • Right-click grid analysis area and select “Create User Calculated Measure“...
    • OLAP Calculated measure

  • Enter MDX expression that will be used for User Calculated Measure. Select measures and click “Add Measure” to add measure unique name to expression. After you form complete expression, validate expression by selecting “Test MDX expression”. Enter appropriate MDX value for “Format values”, for example “Standard”, “Currency”, “Percent” or any other valid MDX format values expressions. (Check official MDX documentation for “Format values” parameter)
    • OLAP Calculated measure

  • After you create User Calculated Measure, Cube structure tree will be refreshed to show new User Calculated Measure which then could be used in analysis.
    • OLAP Calculated measure