topic Re: Managing different granularity keys in Fact Table with generic key (?) in QlikView

Managing different granularity keys in Fact Table with generic key (?)

Fri, 30 Aug 2013 17:38:20 GMT

I have 2 dimensions, OperatingCompany and Company, merged with a JOIN into just the Company dimension, where an OperatingCompany manages 1 or several Companies.

Most metrics in the Fact table are by Company but one metric is by OperatingCompany.

How should I implement the Company Dimension so that when I only choose the OperatingCountry on screen I obtain all the OperatingCompany metrics?

Should I add to OperatingCompany/Company extra UID/records corresponding to OperatingCompany without Company? Would this work?

To complicate matters a client dimension connects to the fact table by Company.

Would this be a case where a "generic key" could be a solution? And how could it be implemented in the Company dimension?

Thanks

Re: Managing different granularity keys in Fact Table with generic key (?)

Andrea_Ghirardello — Sun, 01 Sep 2013 20:06:22 GMT

I think you can use conditional dimensions/expressions.

You can learn more about "Conditional" feature (available since QlikView 11) in the "Whats New in QlikView11.qvw" sample document (see "Report" tab).

This feature allows you to show a chart containing only dimensions and expressions according with specific selections.

Re: Managing different granularity keys in Fact Table with generic key (?)

Tue, 03 Sep 2013 17:28:42 GMT

I'll check them out. Thanks