Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there any solution to restrict only the facts via section access?
In this example, I have section acces for REGION_SA but wanted to make all countries available. (Only makes available those that are linked to the facts).
Is there any solution?
You could add dummy records to your fact table so every REGION_SA value will be linked to each record from your dimension tables.
That's how QV works, you only see associated Data.
Why would you want to show a user all countries when he can actually make selections on select regions?
You could add dummy records to your fact table so every REGION_SA value will be linked to each record from your dimension tables.
Yes Gysbert,
that was the solution