| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
