Restrictions on Measure Objects..in Universe

[Former Member]

Hello Everybody,

I am trying to apply Restrictions on Measure Objects based on a Financial Year rather than a Calender Year.

For example: I am trying to find Total Sales for a Financial Year( that may be like 01/06/2008 to 31/05/2009) not the regular Calender Year( 01/01/2008 to 31/12/2008)...

But i am unable to figure it out, how to do it exactly in Universe...

Any Suggestions or any peace of information is really appreciated...

Thanks

Raghu...

[Former Member · Accepted solution]

Didier,

Thanks for the expression, but i am unable to figure it out still

Thanks

Raghu

[Former Member · Accepted solution]

Hi,

You have to replace 0CALMONTH by fiscal year technical name. Then the replace the value by the members key you want to use.

If you are not sure or confident how to write it, please provide the caracteristic definition as well as members definition.

Regards

Didier

[Former Member]

Hi,

Here is a sample with "Calendar Year/Month" characteristic. The calculation is the aggregation from September 20005 to July 2006.

You have to write an expression such like this:

<EXPRESSION>Aggregate({[0CALMONTH].[200509]:[0CALMONTH].[200607]})</EXPRESSION>

Regards,

Didier