OLAP Universe calculated measure

[Former Member]

Hi all,

I'm having a hard time getting the xml syntax right on my universe. For example, in my Key Figures class I have a Revenue class which contains the measure Revenue. Even the simplest select statement gives me an "Invalid Definition" error when trying to parse.

<EXPRESSION>@SELECT(Revenue\Revenue)</EXPRESSION>

<EXPRESSION>@SELECT(Key Figures\Revenue)</EXPRESSION>

Can anyone tell me what I'm doing wrong?

Thanks

Edited by: Keith Liauw on Mar 26, 2010 1:33 AM

[Former Member · Accepted solution]

Thanks for the replies but unfortunately it's still not working.

Parent Class = Key Figures

Object = Total Sales

Using

<EXPRESSION>@Select(Key Figures\Total Sales)</EXPRESSION>

I still get "Parse Failed: Invalid definition (UNV0023)"

Cheers

Keith

[Former Member · Accepted solution]

Hi,

Are you sure that Key Figures is the parent class of Total Sales? Isn't it "Total Sales"?

Didier

[Former Member · Accepted solution]

Doh!! Yes you're right Didier, it should have been

<EXPRESSION>@Select(Total Sales\Total Sales)</EXPRESSION>

Thanls

Keith

[Former Member]

Hi,

As Rohit sais, @Select is case sensitive.

Moreover classes and objetcs are also case sensitive.

Last be sure that you reference the parent class of you object and not the root class.

Regards

Didier

[Former Member]

Hi Keith,

The @Select() function is case sensitive. You are using @SELECT() which is wrong. So try the following defition:

<EXPRESSION>@Select(Revenue\Revenue)</EXPRESSION>
<EXPRESSION>@Select(Key Figures\Revenue)</EXPRESSION> 

Regards,

Rohit

[arijit_das]

Agreed with Rohit.

Best Regards

[arijit_das]

Hi,

I can see no wrong in the expression.

Please ensure that the objects being referred to the expression are parsing OK.

could u pls let us know the full error message while parsing the object?

Thanks and Regards

[Former Member]

The exact error is "PARSE FAILED: INVALID DEFINITION(UNV0023)" . The Revenue object parses successfully and all I want to do in this case is create a calculated measure that equals Revenue. The real requirement is actually more complex but this is just a first step.

Thanks