topic Problem with Section Access and Multiple Fact Tables in QlikView

Problem with Section Access and Multiple Fact Tables

Mon, 04 May 2015 19:36:22 GMT

Hey guys,

I'm having difficult in getting my section Access to Work properly. Included is a screenshot of my data tables.

I'm utilizing a PARTNER_PARENT_DUNS number for my section access (Highlighted in Blue).

This is associated to my opportunity table via z_Opp_Id is are unique ID for each opportunity.

Since there are multiple fact tables the Master Key table is used which allows me to have Hyperion as a separate table.

The problem I'm encountering is that the Budget doesn't have all the data in it when I open the document. If I reload it on my desktop Qlikview all the data is there. This is why I know the problem is with section access (With data reduction).

I thought that data reduction would reduce the PARTNER_PARENT_DUNS would in turn reduce the z_Opp_Ids

Which would then reduce ~MasterKey.

Any thoughts?

Thanks,

Rob

Re: Problem with Section Access and Multiple Fact Tables

ToniKautto — Mon, 04 May 2015 22:09:58 GMT

Based on your limited screenshot I think you are looking at the Source Table View, which will not show you the actual data model in memory. Switch the view, and I an sure you will see that there are synthetic keys in the data model. Recommendation is to eliminate synthetic keys, before you consider any issue you are seeing in application logic.

If the screenshot show your internal table view, my guess is that your model is quite complicated, and that you are not able to predict the section access output. Consider that the reduction values are equal to selections in the application. So if you reload the application without Section Access, what data do you get if you apply the reduction value(s) manually?

To be able to give any further advise on your issue, a sample application would be really helpful.