Retail Predictive Application Server (MOSC)

MOSC Banner

How to implement a Cumulative % measure

Good Morning experts,

I am implementing a CR for a customer, RPAS version 15.0.2

I am firstly calculating Sales percent contribution of each store to all store, at department level

Then, based on this I want to rank store descending and calculate a cumulative %.

Department A

SLS Value Relative% Ranking Cumulative %

Store 1 1500 25% 2 =32%+25%=57%

Store 2 600 10% 5 =90%+10%

Store 3 800 13% 4 =77%+13%=90%

Store 4 1900 32% 1 32%

Store 5 1200 20% 3 =57%+20%=77%



I know there is an extended measure %Cumulative Extended measure that does what I need, but extended measures are available only for visualization. On the contrary, I need to use the value of Cumulative % as input for other rules.


Thanks for any hint,

Regards,

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center