Datamodelling and SA security

[t_hylander]

Hi,

I've got a app that several bosses is using, showing all kinds of KPIs etc.
I'm  using SA so that each boss only sees the economics and KPIs related to their own department.
Now I got a question if I can tighten up the security so that each boss only sees specific accounts, still within their department. This is only used when they is looking at the economic-part of the app. Fine, I did a synthetic key with department and accounts and a table with all combinations and it worked nicely in the transform-stage. But I had forgot one small detail when I moved over to the load-stage, I still need the department in the fact-table due all the KPIs.

Anyone got a idea how I can work around this?
I've made a simple demo to show what I mean.

Demo showing the synthetic table

[Brett_Bleess]

Check out the following Design Blog posts:

Section Access Primer:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

There are some other links at the bottom of that post related to dynamic data reduction you will want to review as well, just FYI.

Synthetic Keys:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Hopefully these will help you get things sorted out the way you want.

Regards,
Brett