I was wondering if it possible to easily read metadata of data cubes from Dundas database?
The idea is to create a dashboard that can be used as a “data dictionary” so that the users can easily view the metadata of every cube - and then we can put nice business friendly descriptions in the description field of every attribute (hierarchies and measures). In this way we can have a self-documented data dictionary that is always up to date.
We have 2000+ fields in our database so to do this manually is not an option.
I have looked around in the application database but I do not see an easy way of reading this information.
Any tips/help is greatly appreciated.