Hi,

I need the list of all the existing reports, what measures and dimensions each of the report is built on etc. I saw that the table dbo.BookElements can be used to get all the list of reports. But how can I findout what dimesions and maesures are being used in each Report?

Thanks and Regards,

Praveena

Hi Praveena,

The bookelements table has a column called XMLData - this contains all the metadata for the report.  You could cast this out and extrapolate data from it, or use the object model to retrieve the MDX for a recently executed report.

Hth,

Sean

Hi Praveena,

Use the below query:

SELECT CAST(XMLData AS XML) AS XML_DATA,* FROM dbo.BookElements C  WHERE CreatedBy LIKE '%Shiv%'