June 27, 2002 at 11:18 am
Can anyone tell me how to retrieve the info displayed in the Analysis Services "Meta Data" pane? I'm not refering to Meta Data Services in SQL Server (not using it on this box) but to the Meta Data tabs in Analysis Services.
I can't find where this info resides in my DB (if it does) and some of the information listed on these pages doesn't appear to be accessible through DSO.
For example, I can only find a DSO method to retrieve fact table names but not dimension tables which are listed on the Meta Data page so I'm guessing this meta data is in my DB??.
My goal is to dump this info into a formatted documentation file.
Thanks.
July 3, 2002 at 1:58 am
By default, the metadata is stored in an access database under your Analysis Services\bin subdirectory called msmdrep.mdb. You can migrate the repository to SQL Server if you wish, by right clicking the AS server's properties in Analysis Manager and choose Migrate.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply