Have you ever had a requirement to display additional details about data in a report but couldn’t find a good way to do so? Showing OLAP Member Properties in a SAS Web Report could be a useful way to sneak more details about data into a crosstab table. Crossing Multiple Dimensions with High Cardinality...
Read More »
Adding disclaimers to SAS Web Report Studio tables and graphs is sometimes necessary for confidentiality purposes. You can do this easily by using the Configuration Manager available in SAS Management Console 9.2 and up. This is shown to the right. Adding a Table Disclaimer Through SAS Management Console SAS Support provides official documentation...
Read More »
SAS Web Report Studio has some features that help can improve the overall appearance or just shake things up a little. You can change the template for individual reports in cases where you need to better highlight an idea. Tip! Check out the Information is Beautiful site for some inspirational ideas about presenting data....
Read More »
This past week I have been studying the Google Analytics data to determine the best topics to discuss in the upcoming month and to prepare the SAS Global Forum 2012 conference. Google Analytics allows me to measure which posts get the most hits when posted and continue to be popular or referenced. I’ll unveil...
Read More »
I’m really excited, Angela and I were invited to speak at the SAS® Global Forum in Orlando in April. We were asked to talk about the SAS BI package and we have narrowed down our topic to SAS Information Map Studio, SAS Web Report Studio, and, if time allows, the SAS Information Delivery Portal....
Read More »
There are times when you need row numbers on your report. Maybe you are ranking items and you want to be clear that the list is ranked or maybe you have a report viewer who only feels the report is complete when the numbers are present. To add row numbers, right click the table...
Read More »
Conditional highlighting, also referred to as traffic lighting, helps report consumers quickly recognize when the data is showing the desired trends based on their targets. Today I’ll talk about the color choices for the highlighting from MS Excel, SAS Web Report Studio, and SAS Stored Processes. Conditional Highlighting Example Web Report Studio allows you...
Read More »
Sometimes SAS Web Report Studio needs some dashboard dials and sliders that seems like mission impossible for you. However, add a stored process with the trusty ole’ SAS GKPI procedure to bring the dashboard features to your local report. I know you are wondering – “What is this special magical procedure of which she speaks?”...
Read More »
In SAS Web Report Studio, I was trying to create a bar chart that showed the total payments by month. However, the Payment Date was the actual date the company received the payment and as a result the chart had a “play-by-play” action instead of overall results. Turns out that October 16th was a...
Read More »
Ok – I”ll just say it. I hate pie charts. If there are more than a few categories – then the user has to interpret the ranking order, it slows them down, and they may loose interest in the report that you so lovingly prepared. Maybe you say – “Tricia, add the numbers! Geez – you’re...
Read More »
