How to enable Query logging
- BI admin tool -> Tools -> Options -> set system logging level between 1 to 7 -> checin the changes
- Create a simple report
- To check the query created
- Administration -> Manage sessions -> Clear all cursors
- Refresh the report created in step2 to execute again
- View log in manage sessions
- search for "sending query to database" string
- Copy query and run against DB
