Forum Discussion
Any data catalog options for Shared Datasets?
hey, you can make this inside the model to certain extend, and users when creating new reports based on that dataset or using a excel power pivot connected to it can access the information, you can group in folders the columns inside each table, you can put on each table descriptions on what its inside that table or what its used, you can put in description to each column separately, if given a momment can provide example of each (note: using intuitive column names, and table name its a most for what you want, like really important here):
you see , they can see the information you put on the model in the report creation view and the excel power pivot to know what that columns means, you can put information about relationships ,set up synomous etc. also hidding key columns used for relationship with dimensional tables helps, so that only the dimensional columns are avaible for the report and they dont use a key column by mistake etc.
Thanks for the extra screenshots. I am going to start trying to play around with this and see if this is a viable solution.