Invisible Attribute Hierarchy under Dimension

Question

Below is the snippet of an mdx query used in a report.

with member [Measures].[Leased Coin In] ([Machine Dimension].[Leased Flag].&1 , [Measures].[Coin In])

Now, my question is: In the cube under Machine Dimension, there is no attribute hierarchy name called Leased Flag. I looked at in the xmla script, there is no such name. But, the mdx query pulls result out.

If it is hidden, why does not it appear in the xmla script as hidden/invisible or whatever it is?

If I m missing something, then how do I track it back to find out how it is related with the machine dimension.

Appreciate your help.

Answer 1

Have you tried running the query in SSMS? The &1 is not a valid identifier. Identifiers must start with an alpha character or be delimited with square brackets.

It is possible to write a calculated measure that references a non-existant hierarchy or member, but it would just return null. However a reference to &1 should not even get past the parsing stage of the query evaluation without throwing an error.