query generated

[jcasaspe]

Hello,

I hope you can help me.

I have 2 questions:

1. Do you know how can I see the query generated by WRS and sent to database?
I need to review this query.

2. WRS use subject defined on Imap (like Customer Intelligence)?

Thank you very much!

Jose

[AngelaHall]

For Number 1 - click the ''Run a Test Query" icon on the menu bar, "Insert all" the available data elements, then select the "view SQL" button.

~ Angela

[jcasaspe]

Hello Angela,

Thank you for your answer.

Im a newbie with WRS, so I hope you can be patience :-). Im looking that icon in menu bar and the "view SQL" button and I can't find it.

I just search in SAS Web Report User's Guide and don't found the options you told me.

Can you help me? Where are those options? If you can sent me some screen captures, I aprreciate so much!

Thanks a lot!

Jose
jcasaspe@gmail.com

PS. Im using WRS 4.2

[AngelaHall]

No problem.

This test is done on the Information Map Studio side. Here is some online documentation: http://support.sas.com/documentation/cdl/en/imsgs/61225/HTML/default/viewer.htm#p0j4b2vippx9uzn1cd1x...

~ Angela

[jcasaspe]

Hello Angela!

Thanks again.

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)

Jose

[LinusH]

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.

/Linus

http://www2.sas.com/proceedings/forum2007/239-2007.pdf

[Madelyn_SAS]

This SAS note explains how to capure the SQL query generated by Information Map Studio and Web Report Studio. It is for versions 4.2/4.3.

http://support.sas.com/kb/34/567.html

[Madelyn_SAS]

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.

[jcasaspe]

Thanks to all!!!

I found the queries with the recomendation of BIC_USER_3@SAS .

And for my 2nd question... Web Report Studio don't use Subject from IMap. Goes direct to the table you select.

Thank you guys for your time!

Jose

PS. Come to Peru! you are going to love my country 🙂