Hi everybody,

I´m starting to believe that I am misunderstanding some MDX concepts
so maybe somebody out there could give me a hand with this relatively
easy example:

To make things easier, let´s say that I have a cube with one [Time]
dimension plus one measure called Measure1. Also a calculated member in
the Measures dimension called CalculatedMember1.

When I run the following MDX query:

WITH
MEMBER [Time].[X] AS 'TupleToStr(([Measures].CurrentMember))'

SELECT {[Time].[X]} ON COLUMNS,
{[Measures].[Measure1], [Measures].[CalculatedMember1]} ON ROWS
FROM [MyCube]

I obtain the complete path for the name of Measure1, that´s fine, it
is a real measure in my cube. However I get #ERR for the
CalculatedMember1.

By the error messages I´m getting it gives me the impression that it
is trying to run the calculated member formula when I only want to
simply retrieve the name of the calculated member but not "execute"
it´s formula in any way.

Why the #ERR? Can anybody help me out?

uranio255

It's because of evaluation order. If the definition of the calculated
measures are applied finally, it's natural the errors occur.

Set solve order appropriately. For example,

WITH
MEMBER [Time].[X] AS 'TupleToStr(([Measures].CurrentMember))', SOLVE_ORDER =
3

By the way, why do you use TupleToStr(([Measures].CurrentMember))? Just
Measures.CurrentMember.UniqueName returns the same value.

Ohjoo Kwon.

"Uranio255" <uranio255 (AT) gmail (DOT) com> wrote

Hi everybody,

Im starting to believe that I am misunderstanding some MDX concepts
so maybe somebody out there could give me a hand with this relatively
easy example:

To make things easier, lets say that I have a cube with one [Time]
dimension plus one measure called Measure1. Also a calculated member in
the Measures dimension called CalculatedMember1.

When I run the following MDX query:

WITH
MEMBER [Time].[X] AS 'TupleToStr(([Measures].CurrentMember))'

SELECT {[Time].[X]} ON COLUMNS,
{[Measures].[Measure1], [Measures].[CalculatedMember1]} ON ROWS
FROM [MyCube]

I obtain the complete path for the name of Measure1, thats fine, it
is a real measure in my cube. However I get #ERR for the
CalculatedMember1.

By the error messages Im getting it gives me the impression that it
is trying to run the calculated member formula when I only want to
simply retrieve the name of the calculated member but not "execute"
its formula in any way.

Why the #ERR? Can anybody help me out?

uranio255

Ohjoo,

Thank you! That´s exactly what I needed. The solving order was one of
the things I didn´t know much about.

Thanks again


Ohjoo Kwon wrote: