Skip to Content
0
Jan 04, 2023 at 06:15 PM

How to find out the queries behind Business Warehouse reports?

145 Views Last edit Jan 04, 2023 at 09:55 PM 5 rev

Hello

We have some Business Warehouse (BW) reports that we have been running using the Analysis add-in in Excel.

Now, we are trying to find out the queries (SQL statements) behind some of the BW reports.

Is there a way to find it out?

While looking into it, I found that there are "BEx Query Designer" and "BW Modeling Tools". The latter seems to be the tool to create the BW reports. Thus far the information I can find is that users select fields/columns from already imported objects (tables/views/cube?) to create a query. It does not mention anything about the underlying queries. I wonder if there is an option in the tool to display the SQL query.

Thanks