Enabling additional logging for Analyze reports can be useful to gather the queries that Analyze runs against the BDNA_PUBLISH database. These queries can then be run against the BDNA_PUBLISH database directly.
The steps below allow the additional logging to be enabled:
Scroll to the bottom of the log file to find the latest sql query that was run. You can then take this query to run on database directly.
If you do not see the 'mondrian_sql' log in the logs folder try restarting your machine and try again. After you have gathered the necessary sql queries you may want to comment out the above code in step 3 to disable the additional logging. The log file may grow quiet large over time so you may want to disable the option again or manually clear the 'mondrian_sql' log out now and again.
on Jul 30, 201905:01 AM - edited on Mar 21, 202311:04 AM by gliu