Unable to Create the User defined Measure

Questions & Answers
1

I am unable to create the custom measure. It throws below-attached error below When I was trying

mdx error
mdx error732×425 32.5 KB

to create the Measure.

2

Hi,

The likely reason for the error is that the Role dimension is missing in your data cube. There is no such standard dimension in the eazyBI data model, so please check if this custom field is selected for import.

Note also that you should not use the Sum function for calculating the Mandays per role. Once you have this dimension working, the following formula should do:

CoalesceEmpty(([Measures].[Net Mandays created],[Role].[Dev]),0)

Kindly,
Janis, eazyBI support