Hyperion Essbase (MOSC)

MOSC Banner

MDX - year over year comparison for an account with formula

edited Nov 17, 2011 4:27PM in Hyperion Essbase (MOSC) 9 commentsAnswered

We have a calculation in a member IMU% = ((ORIGRETAIL - SLSC) / ORIGRETAIL) * 100. This is a ASO cube.We also have a dimension called scenario. LY is a member of it which calculates the last year value for the same time period.
Today's date is 11/03/2011. The date dimesion for this week is as below
WE 11/05 has 7 children
10/30/2011
10/31/2011
11/01/2011
11/02/2011
11/03/2011
11/04/2011
11/05/2011

The data is loaded until yesterday ie. 11/01. To calculate the LY data for WE 11/05, for IMU% it should get the corresponding date last year. For 10/30/2011 it is 10/31/2010. For 10/31/2011 it is 11/01/2010. For 11/01/2011 it is 11/01/2011.
I am not sure how to get the data for the corresponding 3 days only. Do I need to hardcode the formula

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center