Same Period Last Year Expression in Universe Designer

[Former Member]

Hello experts!!!

I have various restricted measures with diferents conditions in a monthly period

Sale Y050-YANR

the meauseres in web intelligence say the mdx expression is invalid

can you help with this please?

I have BOE 3.1 SP2

and the source is a multicube in SAP Netweaver 7.00 SP 19

Edited by: Azucena de los Angeles Coronel Castañeda on Nov 14, 2009 11:21 AM

[Former Member · Accepted solution]

Hi,

The MDX syntax you wrote is incorrect.

Please try this:

<EXPRESSION>(@Select(Key figures\total sales), [0CALMONTH].Currentmember.Lag(12))</EXPRESSION>

Didier

[Former Member · Accepted solution]

Hi Didier, thank you for your response.

We have changed the expression and it stills doesn´t function.

It doesn´t solve the query, and the memory of the server runs out.

Have you tested this in a similar environment?

Thanks in advance

Greetings!