Debug Drill Through using Essbase Server Platform Log

When Smart View users run drill through reports, the query that Essbase executes is written to the Essbase server platform log:

<Domain Root>/<Domain Name>/servers/essbase_server1/logs/essbase/platform.log

You can use this log to examine the queries in case you are not seeing the expected drill through results. It is recommended to use this log to test your drill through report definitions, during the design phase. To find the relevant and most recent log entries written right after you have executed a drill through, use the following command (for Linux bash shell):

tail -f platform.log

For each drill through operation, the user name and timestamp are logged, and Essbase records the generated query as shown in the following example:

Query executed on the database: SELECT "PRODUCT", "MONTH", "CITY"[[
FROM (select * from SAMPLEBASIC) DatasourceName
WHERE ("MONTH" = 'Feb' OR "MONTH" = 'Jan' OR "MONTH" = 'Mar')
AND ("PRODUCT" = '100-10-30' OR "PRODUCT" = '100-10-40' OR "PRODUCT" = '100-30' OR "PRODUCT" = '100-20' OR "PRODUCT" = '100-10-10' OR "PRODUCT" = '100-10-20') AND "CITY" = 'New York']]