I could see logical sql (BMM layer) , how ever not actual physical layer sql

Sangeeta Pandey

Hello Experts,

I wanted to fetch actual underlying sql for an Analysis report and hence navigated to Administration --> managed session.

I could see logical sql (BMM layer) , how ever not actual physical layer sql.

Kindly help me -where I can locate that?

Thanks,

[Deleted User]

Click on "View Log". what's in there for that query?

Sangeeta Pandey

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):

[Deleted User]

What's the log level setting in your repository? You need at least level 2 in order to see physical logs.

Sangeeta Pandey

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

[Deleted User]

Why liek that? just open the RPD and change the value.

Also:SAmpleAppLite uses XML as data sources. There is no physical SQL against an XML file.

Sangeeta Pandey

Thanks Chris !!!