Home » Fusion Middleware & Colab Suite » Business Intelligence » How to get Physical sqls in Obiee12c (12c)
How to get Physical sqls in Obiee12c [message #677848] Tue, 15 October 2019 11:13
Shrin
Messages: 3
Registered: October 2019
Junior Member
Hello,

I'm new to OBIEE. I'm trying to generate physical SQLs from logical SQLs in OBIEE12c. I'm following the below steps:


1) I have generated the logical sqls with below cmd

./runcat.sh -cmd report -online http: //localhost:9502/analytics-ws/saw.dll -credentials creds.properties -forceOutputFile /u01/oracle/config/domains/bi/bitools/bin/Analysis_details.txt -type "Analysis" -fields "Path:Subject Area:Column:Table:Formula:RPD Variables:SQL" -folder /shared/textura excelFormat delimiter ","

2) Converting Logical sql into physical sql without executing it.

sh nqcmd.sh -d AnalyticsWeb -u weblogic -p Admin123 -s /u01/oracle/config/domains/bi/bitools/bin/logical_sql.sql -o simpleresult.txt -utf16 -ShowQueryLog -H -QueryLogFilter "Sending query to database" -SessionVar NQ_SESSION.SKIP_PHYSICAL_QUERY_EXEC=1


In my case, sometimes it generates the physical sql and sometimes not.What could be the reason or is there any other way to generate the physical sql in Obiee12c.

Any help would be really appreciated.


Thanks in advance.
Previous Topic: Obiee 12c
Next Topic: variable prompt - default selection - SQL results
Goto Forum:
  


Current Time: Thu Mar 28 12:06:25 CDT 2024