Help with custom measures using MDX expression in IDT

[Former Member]

Hello,

I want to be able to display current year amount and prior year amount based on the user prompt (year). I understand that I need to create 2 measures, one for prior year and the other for current year. Can anybody help with the MDX expression (using select and where clause etc)?

Thank you.

Ann

[Former Member · Accepted solution]

Hi Ann,

Following is the simple mdx syntax for a calculated measure object.

<EXPRESSION>@Select(Key Figures\Order Amount)*@Select(Key

Figures\Order Quantity)</EXPRESSION>

Please go through the following link for customizing  OLAP universe using MDX syntaxes.

http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_sap_olap_univ_en.pdf

Thanks,

Pramod.

[Former Member · Accepted solution]

Thank you Pramod, How can I select order amount where year = universe prompt (@prompt)

[Former Member · Accepted solution]

Hi Ann,

Please go through the documnet it explains how to create @prompt object  filter .

Following is the sample syntax.

<FILTER KEY="[Z_VAR002]">

<CONDITION OPERATORCONDITION="Equal">

<CONSTANT TECH_NAME="@Prompt(

'Customer Variable Single Value Mandatory',

'A',

'Customer2\LovCustomer Variable Single Value

MandatoryBase',

mono,

primary_key)"/>

<CONDITION>

</FILTER>

in the 3rd parameter of the @prmpt function you can repplace with your year object.

Thanks,

Pramod.

[Former Member · Accepted solution]

Pramod,

This is not required in 4.0 designer...Is there a similar document that applies to version 4.0?

Thanks

Ann

[Former Member · Accepted solution]

Please check the following location for the document.

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_sap_olap_univ_en.pdf