Hi all,
I would like to collect metadata from cubes&reports automatically from servers SSAS and SSRS. Metadata include name, description, dimensions, members, permissions, etc. Then I store it into a table to be searchable.
I am searching the best solution for this.
Maybe it would be a SQL stored procedure.
Has anybody an idea or some piece of help?
thx.
attila
This can be done using AMO and a little code to store the metadata in some sort of db.
There is some good information here
(really good code examples, too)
Hope that helps a little,
C
No comments:
Post a Comment