We have the SQL Server 2008 Analysis services instance with some databases, cubes, Dimensions, Measure groups, partitions, etc.
The business users are find difficulty to search for a particular measure. I mean, it is difficult for them locate a measure from the available cubes; again finding the respective Measure
Group/ Folder is not an easy task for them. Also, they need to know the source system of a particular attribute in a dimension, formula for the calculated measure and etc.
So, we have planned to develop a knowledge repository, which needs to store the business metadata for the SSAS databases.
The user needs to be access this information using the SharePoint site and should help them locate and understand the data. The User Interface needs to be user friendly
I need your valuable suggestions for the design of this system.
Note: I have referenced the below articles
View Complete Post