Problem with measures in parentheses

Questions & Answers
1

Hi,

sounds weird. but having the measure wrapped in parentheses, changes the response from easyBI,

in details:
[Measures].[Transition from status last date],
[Transition].[Open => In Progress]
vs
([Measures].[Transition from status last date],
[Transition].[Open => In Progress])

the latter one returns only part of the values the first one does, anyone have an idea why?

Thanks.

2

Hi,

The first code fragment is an incorrect MDX code. eazyBI formula editor still can interpret it as the part till the first comma:

[Measures].[Transition from status last date]

We have an improvement ticket in our backlog not to allow this kind of incorrect syntax in eazyBI.

The use of brackets is a correct MDX code and makes the tuple:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/tuple

You can find more about tuples here: Calculated measures.

Kindly,
Janis, eazyBI support

3

Thank you very much!