Hi Chris,

Thanks for your help !!!

View log says "No Log Found".

I guess I need to set log level for this?

I am not sure how to enable that, however tried some thing like below (red circled):

Thanks Chris,

This is existing sample subject area : Sample Sales Lite which comes with OBIEE 12.2.1.4.0 by default and not my own repository.

I tried to set log level through issuing an sql like below:

Now I can see log, however it seems to be logical query in log than actual.

Below is query:

SET VARIABLE QUERY_SRC_CD='Report',SAW_SRC_PATH='/shared/Sample Lite/_filters/revision exercise 1';SELECT

   0 s_0,

   "Sample Sales Lite"."Offices"."Company" s_1,

   "Sample Sales Lite"."Offices"."Department" s_2,

   "Sample Sales Lite"."Offices"."Office" s_3,

   "Sample Sales Lite"."Offices"."Organization" s_4,

   "Sample Sales Lite"."Orders"."Order Type" s_5,

   "Sample Sales Lite"."Products"."Product" s_6,

   "Sample Sales Lite"."Time"."Per Name Half" s_7,

   "Sample Sales Lite"."Time"."Per Name Month" s_8,

   "Sample Sales Lite"."Time"."Per Name Qtr" s_9,

   "Sample Sales Lite"."Time"."Per Name Week" s_10,

   "Sample Sales Lite"."Time"."Per Name Year" s_11,

   DESCRIPTOR_IDOF("Sample Sales Lite"."Products"."Product") s_12,

   SORTKEY("Sample Sales Lite"."Offices"."Office") s_13,

   SORTKEY("Sample Sales Lite"."Products"."Product") s_14,

   "Sample Sales Lite"."Base Facts"."Revenue" s_15,

   "Sample Sales Lite"."Calculated Facts"."# of Orders" s_16

FROM "Sample Sales Lite"

WHERE

("Time"."Per Name Year" = '2009')

ORDER BY 12 DESC NULLS FIRST, 11 ASC NULLS LAST, 9 ASC NULLS LAST, 10 ASC NULLS LAST, 8 ASC NULLS LAST, 15 ASC NULLS LAST, 7 ASC NULLS LAST, 6 ASC NULLS LAST, 14 ASC NULLS LAST, 4 ASC NULLS LAST, 3 ASC NULLS LAST, 5 ASC NULLS LAST, 2 ASC NULLS LAST

FETCH FIRST 65001 ROWS ONLY

Thanks Chris !!!