how to restrict a field value different in different tables using section access

[#1]

how to restrict a field value different in different tables

Requirement is if I have 2 different fact tables example Sales and Orders which have same key as ProductId(Pro1 to Pro10), and If I have to restrict

Products 1 to 3 for Sales and no restriction on Orders how can i achieve it, if i use section access on ProductId it's restricting data from both Sales and Orders. I want restriction on Sales alone.

[michael_maeuser]

create in eachte fact table a field

s.th. like e.g. in sales fact table

'Sales' as SourceType

and in order

'order' as SourceType

then you can restrict on this field

[Gysbert_Wassenaar]

That's not possible if you want the two tables associated on the field ProductId. If you restrict a field on some values that will cascade to all tables that are associated. You can of course rename ProductId in the Orders table. But that will have a negative influence on your data model and the performance of your document.