Check relationship between entities

Uwe
Uwe Customer
Fourth Anniversary First Comment
in Platform

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

Answers

  • Paul Wyatt
    Paul Wyatt Customer
    100 Comments 100 Up Votes 100 Likes Second Anniversary

    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 Troymcclure.png

     

    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

Categories