Best way to select individual Entity
Hi all,
i'am struggling with the following problem:
I want to make a calculation within BOARD.
I have products that can be produced and finished in different plants and production lines. Each production-line has a relationship to a plant with different costs on personal plant) an production-line.
So, within a screen i have 4 combinations, that could individual be selected (dropdown?).
Semi-finished good > plant > production-line
Finished good > plant > production-line
After selecting the 2 plants and the 2 production-lines the default-costs should be used for the product-calculation.
Plants and production-lines are stored in an entity.
It should also be possible to create more than one calculation based on one product.
What is the best way to realize this?
Kind regards
Answers
-
Hi Uwe Lueers. My understanding of your requirement gives me the following:
Entities:
- Plant and Production Line, with Production Line being a child of Plant.
- Product - you might need the ability to produce a Product on any Production Line
- Cost Type - e.g. Cost 1,Cost 2, Cost 3. These costs might be children of Finished Goods or Semi-Finished goods - I guess that's up for debate, or they may be lowest level members in their own right?
So, now I can have multiple Cost Types (i.e. cost calculations) across multiple Products, and multiple Production Lines - the cube for my calculation result would use all of the above Entities, plus Time and any others that might apply.
Perhaps I've missed something, but the above would be my first guess!
2 -
Hi Uwe Lueers,
in addition to what Phil Marshall said--you could use rules on the entity "cost type" to accomplish the calculations you need. So you would need a data-model using the entity as KPI (account-based model).
Kind Regards
Helmut
2 -
And this: "It should also be possible to create more than one calculation based on one product" can be accomplished by using an additional entity that might be called "Version", "Scenario" or something like that.
1
