AnsweredAssumed Answered

Check relationship between entities

Question asked by ulueers on Jun 4, 2019
Latest reply on Jun 5, 2019 by Paul Wyatt - Avison Young UK

Hello all,

i want to build up a planning-modell for product-changes to newer products (switch).
in this case a have a cube with quantities based on customer, product, month from a salesplan.
Now some products will change to new ones.
Therefore i have also a 2. entity with only new products and have build a relationship between them.

In another cube i will define, when the customer change (% from Total in the month)

As result, i want to fill other cubes with the quantities old and new based on the relationship
(if there is a valid product by relation, calulate the % from old an set to new, if not, set the old quantity to new.

Is this possible?

Art.JunJulyArt (new)% Jun% JulyQ Jun oldQ July oldQ Jun newQ July new
A100200A14010060040200
B100200none (_)0010020000

 

Kindly regards

Uwe

Outcomes