Need help with Section Access.

[sparur]

Hello, guys

I have one interesting point for you

Let's imagine that we have such table structure (fact table):

Year, Country, EmployeeID, PositionLayer

For full set of data we have 10 different Position Layer (from 1 to 10)

but for each country we have different number of layers.

For example, for USA we have all PositionLayers (1 to 10)

but for UK - we have only from 3 to 9 layers.

And finally I have a chart which count number of employees on each PositionLayer,

in other words, I have a chart with

one dimension - PositionLayer

one expression - count(distinct EmployeeID)

And I have section access table with acces for each user per country:

BOB have access only for USA

KARL only for UK

ACCESS, USERID, PASSWORD, COUNTRY

USER, BOB, 123, USA

USER, KARL, 123, UK

It's work fine.

But problem is that I need to show ALL 10 layers for any users.

but for KARL I have only from 3 to 9 layer and can't show 1,2 and 10

How I can achieve it?

I am ready to take any crazy ideas

Thanks.

[sparur · Accepted solution]

Colleagues,

I apologize for the trouble

but it seems I have found inspiration, and I found a way to solve my problem

thanks.

P.S. If somebody has interest about my ideas, please, ask me in private message (because I can lose this thread )