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.
Hi,
Beginning with SAS® Web Report Studio 4.31_M2, you can create conditional highlighting rules that are based on character categories.
https://support.sas.com/documentation/cdl/en/citug/65339/PDF/default/citug.pdf
If you want to create rules based on numeric categories, or if you are using an earlier version of SAS Web Report Studio, you can refer to the following SAS Note: http://support.sas.com/kb/40/747.html
Have a good day
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.