I need to see (for some tests) the query generated from Web Report, not in IMap. I know WRS functions with relations and data items defined in IMap, but I want to know if I can look the SQL Queries generated from Web Report.
This need is related with my 2nd question on original post.... Need to know if WRS use the subject defined on IMap(same like Customer Intelligence).
Thanks again for your time and sorry for my pour English. Im not native (well... at this time, you know that he he)
When you say database, do you mean an external RDBMS?
If so, to the SQL that SAS LIBANME tranforms to in the native SQL for the target database, you could use logging tool in the RDBMS, or enable logging for your WorkSpace server, and add debugging options to your appserer_autoexec_usermods.sas file. See online doc for details on SASTRACE and SASTRACELOC.
Also, yes, Web Report Studio does use information maps as a data source. I am not familiar with Customer Intelligence, but I assume any maps consumed by that application can be used by Web Report Studio as well.