Traditional web-based reporting with SAS BI tools

query generated

Reply
Occasional Contributor
Posts: 8

query generated

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
SAS Employee
Posts: 238

Re: query generated

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
Occasional Contributor
Posts: 8

Re: query generated

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
SAS Employee
Posts: 238

Re: query generated

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
Occasional Contributor
Posts: 8

Re: query generated

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
Esteemed Advisor
Posts: 5,093

Re: query generated

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
Data never sleeps
SAS Super FREQ
Posts: 384

Re: query generated

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
SAS Super FREQ
Posts: 384

Re: query generated

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.
Occasional Contributor
Posts: 8

Re: query generated

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 :-)
Post a Question
Discussion Stats
  • 8 replies
  • 322 views
  • 0 likes
  • 4 in conversation