Retail Predictive Application Server (MOSC)

MOSC Banner

Merge measures belonging to two different intersection using multisource

edited Feb 22, 2018 12:50AM in Retail Predictive Application Server (MOSC) 3 commentsAnswered

In RPAS we want to merge measures belonging to two different intersections using multisource, but here the catch is that the base intersection is from two hierarchy spines of location hierarchy

For Example:-

Main hierarchy

loc -> store->channel->Market->Company

Alternate Hierarchy

loc-> store->channel->group->Market1->Company1

Now measure1(week_channel_sku), measure2(week_company_cku), measure3(week_company1_sku),measure4(week_channel_sku)

meas4 <- multisource(measure2,measure3,measure1,FALSE/TRUE)

we tried the above approach, but the meas4 is not getting populated for any level higher than the channel.

Is there any way we can achieve this by using multisource or any other approach. Any pointers would be great.

Tagged:

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