I'm facing following data model problem. I got essbase like numbers already aggregated on different levels (and they don't sum up). For example:
brand name 100
sku 1 10
sku 2 5
Challenge is how to model it in Qlik. When user choose brand name chart should show 100 value when sku 1 is selected value 5 should be shown. I tried to use generic exclusive generic keys, but the problem is when you choose brand name then Qlik sum values for brand name and skus.
