Check relationship between entities

Uwe

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.	Jun	July	Art (new)	% Jun	% July	Q Jun old	Q July old	Q Jun new	Q July new
A	100	200	A1	40	100	60	0	40	200
B	100	200	none (_)	0	0	100	200	0	0

 

Kindly regards

Uwe

Paul Wyatt

Hi Uwe,

 

I don't think I fully understand what you're trying to accomplish so I apologise beforehand if my response in vague or misses your point.

 

Duplicated Cubes:  Within BOARD, you can create cubes to replicate other cubes and, with timestamp dimensions, switch and compare values over time - no big deal there. 

 

Duplicated or [R]-replicated Entities:  You can create either duplicate or [R]-replicated entities and, using a procedure, copy a cube and contents into another cube whilst changing the associated entity or entities - bit more involving but, again, nothing too stressful and there's a couple of eLearning videos on the [R] Replicated process here 

 

SLOWLY CHANGING DIMENSIONS (SCD):  This is a technical solution and fully within the capability of BOARD - I have a production model which employs SCD methodology.  It requires the developer to determine the methodology required to meet the exact requirement.  I'm sorry for not expanding on this further but without a full understanding of your data structure, needs of the data tables, requirements to create and/or amend records and maintain time relationships, I could not even begin to outline a proposal. 

 

I know that this isn't a solution of how to achieve what you asked but maybe you can consider it a start of a conversation to get to where you want? 

 

Regards