Retail Predictive Application Server (MOSC)

MOSC Banner

How to remove bottom level dimension of PROD hierarchy?

edited May 20, 2014 12:00PM in Retail Predictive Application Server (MOSC) 3 commentsAnswered

Hello,

I have the following question:

We have a PROD hierarchy that looks like:

PROD

     WSE    

          WGR

               ABT

                    MAG       

                         TMG

Now we want to remove the bottom level dimesion WSE from hierarchy, because it should no longer be used. But how can I do this? If I remove WSE all other parent dimensions will be automatically removed too. Does it mean that I have to build up the hierarchy again without WSE. But what does happen to all the measures, rules and intersections, where PROD hierarchy and its dimensions is used?

I tried to build up the dimension for the PROD hierarchy completely new, but was not able to give them the same RPAS name (which is only used internally) they had before the removal of the dimensions in the PROD hierachy.

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