locked
Existing reports in Proclarity 6.0 RRS feed

  • Question

  • 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

     

    Friday, May 20, 2011 3:19 PM

All replies

  • 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


    Microsoft ProClarity | This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, May 25, 2011 6:29 AM
  • Hi Praveena,

    Use the below query:

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


    Thanks Shiven:) If Answer is Helpful, Please Vote

    Monday, April 14, 2014 1:20 AM