topic Re: Metadata Lisitings in Developers

Metadata Lisitings

GPatel — Tue, 25 Sep 2012 13:29:37 GMT

Is there any procedure or code that lists all store processes, olap cubes, information maps off the metadata, like proc contents lists?

Re: Metadata Lisitings

CameronLawson — Thu, 27 Sep 2012 22:15:16 GMT

I don't believe there is a procedure that will handle all of these in that fashion. In saying that, you can get to this information via some different procedures;

Proc Infomaps has a method to list the contents of information maps. Check out the support docs for the syntax
Proc Metadata will give you all the content you need however you will need to construct an XPath query to feed into the proc to get the information out. The return from the procedure is XML containing content for the Metadata Type(s) you query. More of a learning curve but very useful once you get the syntax learnt. When researching you will need to use the GetMetadata method.

Hope that helps.

Re: Metadata Lisitings

SASBIROX — Wed, 07 Nov 2012 12:42:07 GMT

Check Angela's blog post that shows how to work with the metadata - specifically she shows the stored processes - but this can be expanded to other metadata.

Various ways of locating components of stored processes