BusinessObjects Board

VBA Macro to get DeskI report metadata information

Hi,
I need a macro to get all below meta data information from a Desk I report .

  1. All measure, Dimension, detail object name with the associated database mapping/ formula.
    Conditions used in the report etc.

Want to store the info in a excel file.

Thanks in advance
Byomakesh


Byomakesh :india: (BOB member since 2009-08-01)

Hi,

Maybe this utility can help:


Marek Chladny :slovakia: (BOB member since 2003-11-27)

@system Can i get the report filter details also ??

What product are you using?

I’m using BO XI 3.1 desktop intelligence

and also from the Dataprovider SQL I’m getting the report generated and custom SQL if used but how do i get to know that in this CUSTOM SQL is only used ?
And can i get the report structure as well ?

Please help me out on this

My access to XI3 has long gone but I was seeing what version you were on for having a look at Bob’s Downloads. The link above might be of use as well as Marek’s original response. If you’ve got everything else apart from the filters, you’re doing well.