Mixed Granularity-Fact tableVs Budget

Wed, 09 Nov 2016 16:38:19 GMT

Hi,

I've a problem with Mixed Granularity dimension in Actual and Budget.I've read article and discussion about this problem but i did not understand how to apply it to my application. I have the budget table and the fact table that share some dimensions that I put in a linktable to avoid redundant keys and the two tables (Budget and Facts) that connect to linktable with a primary key that consists of the concatenation of all secondary keys that connect the common dimensions. Where coges table are fact table:

What i want is that when i select cod_budget_a or prg_budget_t in table Budget he reduce only the rows of this table and not the rows of Fact table. I attach a simply application than can explain the situation in small.

Thanks;

topic Mixed Granularity-Fact tableVs Budget in QlikView

Mixed Granularity-Fact tableVs Budget