Forum Discussion
petermichael
6 years agoRegular Visitor
Modelling for Self-Service
Hello community. Below are some screenshots of a model which contains multiple fact and dimension tables. The fact tables have different granularity and they are also covering different parts of th...
Greg_Deckler
6 years agoCommunity Champion
Yes, you can hide tables, columns and measures within the data model to only expose users to what they need to see. In the data tab (middle), right-click tables, columns and measures and choose "Hide in report view".
petermichael
6 years agoRegular Visitor
Thank you Greg for the quick reply. I am aware that I can hide tables, but I dont want to hide the tables in general.
What i want is something like:
Fact A with Dimension A and B
Fact B with Dimension B and C
Ideally i dont want to create multiple models.