Hi Team, We want to display Image in report title on web report studio.we are trying by using below SAS Code but its not displaying Image while we use SP  on Web report studio.Please guild us to achive this requirment.   Code for Refrence.   ods escapechar="^"; ods html file="/apps/usr/Komal/Title2.html" style=sasweb; title  j=l height=2 "Date as of:1/12/2016"  j=c height=3 "Sales Report"  j=r height=2 link="http://www.test.com" "^{style[preimage='/apps/usr/HelpIcon2.jpg' ]} ";   data test; a=' '; run;   proc report data=test noheader style(report)=[cellspacing=0 borderwidth=0] style(column)=[borderwidth=0] style(header)=[background=white] ; column a ; run; ods html close; ... View more

Hello Team,     Background Detail: Currently we are using cube based summary report which is linked with detail report. For this we use report linking approach instead of drill thorough approach. because we have requirement like hyperlink for total column and display all columns at time.   Issue: While we click on Summary Reports hyperlink column it take too much time to open detail report. Still we are facing processing time issue. Can we have another options in (Info map/Cube/Report linking)  which will help to reduce processing time to open detail link report.   Currently Table is having around 1.2 million records (DB2 Tables), In future it will grow further.   Can you please help us to resolve this issue. Let us know if you require more details.       ... View more

Dear Team, We want to display report with headers having below three in single line. 1-Date (At upper left corner). 2-Title (At Center). 3- image help logo with help link (Upper Right corner). We have created a stored procedure for this purpose, while we are executing in enterprise guide it will display the required output title with three things in single line as below given screen shot for your reference. (Need to decries size of Logo) But when we use that stored procedure in Web Report Studio it gives out put in below manner, -Title is not in single line. - Image Logo is not display on Web Report Studio. We are using below SAS Code for the same. *ProcessBody; %stpbegin; ods escapechar="~"; %let refreshed=%sysfunc(date()); %put &refreshed; Title height=9pt color=black justify=left "Data as of %sysfunc(putn(&refreshed,mmddyy10.))" j=c font=Arial height=12 bold "Summary Report" j=r height=11 link="http:// www.helpportal.com" "~{style[preimage='/apps/usr/HelpIcon2.jpg' ]} " data test; a=' '; run; proc report data=test noheader style(report)=[cellspacing=0 borderwidth=0] style(column)=[borderwidth=0] style(header)=[background=white] ; column a ; run; %stpend; Please provide solution for this. 1-Title in single line. 2-Logo should be display on Web report studio Is there any option need to change or anything else?? System Details SAS Web Report Studio 4.4 M3 I E Version 11.0 Enterprise guide 7.1 ... View more

Dear All, We are creating reports by using SAS Web report studio 4.4.   For this we are creating      Cube --->Info map --->WRS.   Our Requirements 1-we need to highlight rows in reports on basis user who is login on WRS. e.g. -Suppose user B is from “office1” logs in WRS then he is able to see all field of reports by   Highlighting those all records which are belongs from "office1” & “Region” & “User”   Below is demo report which is Highlighting the row of user B.   Idea is the user will quickly find his related data.   Region Office User count_orders Sum_Sales 1 Office2 A 23 1234 2 office1 B 34 2314 3 office1 C 32 45678 4 office4 D 54 54326 5 office4 E 6 543 6 office7 F 67 2314     Is there any way to pass the macros parameters (Prompt) to Info map or WRS report by   using filters on the user basis?   Please let me know which the best way to do this task is. In Advance Thanks. ... View more

Dear All, Need help. Our process flow requirements. We are Creating OLAP Cube. Use it in Information map. Use info map in WRS and display the Report by using WRS. Need support in. 1-Display reports with selected columns on user basis (Column level security). E.G –Tables or Cube or Info map having below all column names. Region Office   User Count_of_Close_cases Sum of Amount.      Users level are below metioned below 1-State_Level    2-Region_Level   3-Office_level   4-User_Level A ) While State_level user is login he will see the Reports with Region column only with measures columns.  He should not view the other columns name office & User in the WRS report. But he can allow to add other columns if he want, But at Display time he should not view others columns.  Region Count_of_Close_cases Sum of Amount.   B) While Region_level user is login he will see the Reports with only below column. Office   Count_of_Close_cases Sum of Amount. We need while user login in WRS he will see selected columns. If he is region level then he will see Offices present in Regions, with their respective measures only. He should not see the other columns name Region & User in the WRS report. But he can allow to add other columns if he want, But at Display time he should not view others columns. C) While Office_level user is login he will see the Reports office column with measures column. Office   Count_of_Close_cases Sum of Amount. D) While User_level user is login he will see the Reports User column with measures column. User Count_of_Close_cases Sum of Amount. He should not see the other columns name Region & office in the WRS report.But he can allow to add other columns if he want, But at Display time he should not view others columns. Please suggest the best way to execute this task, how to apply column level security for reports on user level.  Or Is it possible in  OLAP/Infomap/WRS (Column level security)?   ... View more

Hello Everyone, I need some information about DataFlux tool, We have 3 jobs of DAtaFlux,Which are scheduled on windows environment. Those have dependencies of each other.(1st jobs output is input to 2nd job and 2nd jobs out put is input for 3rd job like that) I need to do below points. 1-If any one of job having error then stop execution of remaining jobs immediately. and give the alerts to respective persons email addresses or Text massage on cell phones. and also attached with log files. Can we do this Dataflux tool? I have done this by using base SAS coding. Please let me know the correct way. Thanks ... View more