BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Archive by Tags

Articles tagged with: Troubleshooting

Web Report Studio: Recognize these 2 Gotchas?

2012-07-23 – 7:56 AM
wrs_gotcha_02a_rank_will_not_set

If you aren’t paying close attention to the messages in Web Report Studio, you may run into some puzzling issues.  The messages that SAS produces may not be obvious enough if you are expecting a different behavior, thus making troubleshooting a bit difficult.
Gotcha 1: Why Won’t My Changes Save?
This reminder comes from Shri Sastry.  She had asked a co-worker to make a simple change to …

SAS Stored Process: Ignore the Log at Your Own Peril

2012-07-05 – 7:24 AM
stp_logcheck02

I love our readers – especially when they have a great idea they want to share. Quentin McMullen, who has been programming in SAS for 15 years, primarily in clinical trials and public health submitted such an idea recently. Several months ago he left a comment asking about checking the log from a stored processes.  I didn’t really have a good idea – so he came …

SAS OLAP Cubes: Automatically Collect ARM Performance Logs

2012-06-18 – 8:30 AM
ARM Info enabled

Collecting ARM logs can be extremely useful when tuning OLAP cubes for faster response.  The ARM log (which stands for Application Response Measurement) collects vital usage information for OLAP cubes using the SAS OLAP Server logging facility.  SAS OLAP Cube studio can analyze these logs to assist with aggregation building to make OLAP cubes return faster results.  Angela Hall discusses this and other ways to …

Web Report Studio: Adding Drill-Down Filter Based on a Date

2012-05-21 – 8:04 AM
Linked Reports

When I was creating the Summary and Detailed reports for the SAS Global Forum paper, I was demonstrating how to link from the weekly chart to the detailed report about the week.  On my first try with my Week Filter based on the date value – it just would not work.  Eeek!  To fix the problem I made a new data item that was a character value. …

SAS Stored Processes: 3 Tips to Improve Your Prompts

2012-05-16 – 7:38 AM
STP_usable_03

SAS stored processes are similar to SAS programs in that they use the same programming language.  Many of my SAS programs I created early on were only used by me, so I could live with  a little uncertainty and it was easy enough to check the logs for any issues.  If anything went wrong then I knew what I had to change.
Stored processes required a …