Can I have two section access tables (both with USERID field) in order to reduce the data through two dimension tables, as follows?
So that, fact table data is reduced to records where PRODUCT_ID=A and COUNTRY_ID=10 for USER1.
How about something like the below:
You join Table1 and Table2 in order to create the users and their restrictions.
I am also attaching the app.
Let me know if this works for you.
This will work, however I would like to avoid joining two tables, as in my case, it will create a very large table.
That is why I wonder if it is possible to use two tables (both with USERID field) in section access.
did you happen to get some work around on this?
Did you find a solution to this issue please ?
Thanks in advance .