Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.