topic Re: query generated in SAS Web Report Studio

query generated

jcasaspe — Wed, 23 Mar 2011 21:13:21 GMT

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

Re: query generated

AngelaHall — Thu, 24 Mar 2011 12:37:00 GMT

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

Re: query generated

jcasaspe — Thu, 24 Mar 2011 14:47:02 GMT

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

Re: query generated

AngelaHall — Thu, 24 Mar 2011 18:31:15 GMT

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#p0j4b2vippx9uzn1cd1xh5eitzrn.htm

~ Angela

Re: query generated

jcasaspe — Thu, 24 Mar 2011 19:02:40 GMT

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

Re: query generated

LinusH — Thu, 24 Mar 2011 19:19:50 GMT

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

Re: query generated

Madelyn_SAS — Thu, 24 Mar 2011 20:20:57 GMT

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

Re: query generated

Madelyn_SAS — Thu, 24 Mar 2011 20:22:26 GMT

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.

Re: query generated

jcasaspe — Thu, 24 Mar 2011 22:47:21 GMT

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 🙂