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.||Jun||July||Art (new)||% Jun||% July||Q Jun old||Q July old||Q Jun new||Q July new|