Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 )
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 )