multiple section access tables, all with USERID field

[Anonymous]

Can I have two section access tables (both with USERID field) in order to reduce the data through two dimension tables, as follows?

Section Access:

Table1:

USERID	PRODUCT_ID
USER1	A
USER2	B

Table2:

USERID	COUNTRY_ID
USER1	10
USER2	20

Section Application:

ProductDim:

PRODUCT_ID	PRD_NAME
A	Phone
B	Television

CountryDim:

USERID	COUNTRY_ID
10	USA
20	Canada

FactTable

PRODUCT_ID	COUNTRY_ID	Sales
A	10	100
B	20	200

So that, fact table data is reduced to records where PRODUCT_ID=A and COUNTRY_ID=10 for USER1.

Thx

PRODUCT_IDPRODUCT_ID

[sinanozdemir]

Hi,

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.

Thanks

[Anonymous]

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.

Thanks,

[aniketsr]

Hi,

did you happen to get some work around on this?

[Othman_malouane]

Hello ,

Did you find a solution to this issue please ?

Thanks in advance .