on 11-03-2015 3:04 PM
Hi experts there!
My client has been using BO for a while and we've got plenty of reports with different filter conditions. There are also some reports with some custom queries. I find it tedious to look through each report for filter conditions and the queries to figure out the reports use a specific condition (or where clause in the query). For example: I need to find all reports that have a condition of 'Datacenter'="VA".
Is there a way to query the meta tables in BO to find the reports that have a condition as mentioned above?
Environment: SAP BO BI platform 4.1
Thanks for your help.
Thanks,
Krishna
Hi Krishna,
There is nothing in the metadata that would help here, however, you should be able to use the API to open the documents and retrieve their SQL statements. Documentation is here. DataProvider is where you can access the query information.
Thanks,
Adam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.