BookmarkSubscribeRSS Feed
jcasaspe
Calcite | Level 5
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
8 REPLIES 8
AngelaHall
SAS Employee
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
Calcite | Level 5
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
SAS Employee
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
Calcite | Level 5
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
Tourmaline | Level 20
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
Madelyn_SAS
SAS Super FREQ
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
SAS Super FREQ
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
Calcite | Level 5
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 🙂

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 8 replies
  • 1440 views
  • 0 likes
  • 4 in conversation