topic Re: multiple section access tables, all with USERID field in App Development

multiple section access tables, all with USERID field

Anonymous — Tue, 31 Jan 2017 20:04:53 GMT

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 — Tue, 31 Jan 2017 21:39:18 GMT

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 — Tue, 31 Jan 2017 22:19:57 GMT

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 — Wed, 05 Feb 2020 15:03:32 GMT

Hi,

did you happen to get some work around on this?

Othman_malouane — Mon, 08 Mar 2021 13:51:42 GMT

Hello ,

Did you find a solution to this issue please ?

Thanks in advance .