We have a requirement of having different measure calculation in hierarchy leves.
Let me explain: Let's say I have a products hierarchy: Product Detail - Product Type
I have two product in the Product Detail level (P1 and P2). Let's say P1 has a sales measure of 10$ and P2 has 20$.
Normally, if I aggregate the two products up the Product Type level, (P1 and P2 belong to a T1 Product Type), I would have a 30$ measure linked to the T1 product type.
But what if the measure for T1 is not linked to the lowest level, and has another totally different measure calculation? ex T1 - 120$
How can I deal with this? Should I have another fact table?
Thank you for your help,