Section Access with multiple fact tables

[#1]

Hi Everyone,

I am trying to implement section access in our application based on two keys.

we have FACT_Table_1 with KEY1 and KEY2, and FACT_Table_2 with KEY_2 only. FACT_Table_2 is linked to FACT_Table_1 and which is linked to dimension table.

When users logged in, he has KEY1 and KEY2 assigned to him, KEY1 can also be null.

Now we need to see the data for FACT_Table_1 where we have KEY_1 associated to user. and FACT_Table_2 data for all KEY_2 values.

Current with simple approach, data is coming as intersection of all the fact tables and dimension tables based on section assess. It is reducing the data for FACT_Table_2 and dimension table as well.

I guess this can we solve using generic key, but not sure how. if someone had faced same problem and got the solution, please suggest.

[srchilukoori]

You need to create a link table between Fact 1 and Fact 2 and use this new table to apply security.

[ziadm]

Hi

Use Henric document as your guide line .  Its best i have read

Data Reduction Using Multiple Fields

Regards

Ziad