I am looking for help in finding out if any APIs are available for reading the BRIO BQY reports / BRIO metadata to dig out the following information.  We are having lot of brio reports and the idea to do a reports consolidation exercise and then see how the same information needs can be met in BO.

So we would like to know the following  essentially for each report.

1.       Tables referenced.

2.       Columns selected.

3.       Filters used.

4.       Entire query if possible.

Appreciate your help in this regard.

Thanks

Srikrishnan Chandrasekaran