The default web application for the Stored Process system takes you to a lovely screen with introductions and samples. However, wouldn't it be nice to skip this screen to just jump right into the stored processes you have created? For 9.2, change the following URL to include your server/port name. This

So you are viewing your SAS Web Report and find that all the data elements capitalizations have changed - instead of no caps or all caps, everything is prop cap (or at least PROPCASE). This is actually a default option in Information Map Studio. To turn it off, select Tools

So we are in Web Report Studio, need to create a filter, can't remember the values and want to see them to select them, but the 'Get Values' button is grey'd out? Argh! All that is required is a simple modification to the Information Map. If you go to the

So you have an idea to implement queries or changes in the metadata via a program directly using SAS. Well, one of the first items of business is actually to grab the Repository ID number. Included below is some quick reference code on how to query that. PROC METADATA SERVER="my_sas_srv_name"

Interested in adding a group of users into Metadata w/o Management Console? Included is an example of how to add one user: PROC METADATA SERVER="my_sas_srv_name" PORT=8561 USERID="sasadm@saspw" PASSWORD="xxxxxxxx" PROTOCOL=BRIDGE in="<AddMetadata> <Metadata> <Person Desc='Manager of clinical studies.' Name='Joe E. Doe' Title='Manager of Clinical Studies'> </Person> </Metadata> <Reposid>A0000001.A5VLFKMC</Reposid> <NS>SAS</NS> <Flags>268435456</Flags> <Options/> </AddMetadata>";

Within each report you can right click on the table, choose properties, and modify the number of rows to display. However is there a way to GLOBALLY modify the default maximum amount? The answer is yes with the required modification occuring within the web deployment area. WebReportStudioProperties.xml (version 9.2) has a section

Business problem: By default, OLAP cubes calculate aggregations at each possible intersection of levels in one or more dimensions. However, there are situations where aggregations cannot be completed on the fly for all intersections within the cube due to business rules for some data levels. Also, the source data table

If you would like for the BI Dashboard to send you an alert via email, you must ensure that the email address is included for each user that will be receiving emails. This is located in SAS Management Console User Manager. Instructions: http://support.sas.com/documentation/cdl/en/biwaag/63059/HTML/default/a003311779.htm Example:

You may choose to address security of who can view what dashboards within a SAS Information Delivery Portal page by managing the 'Sharing' capabilities at the Page or Portlet levels, however the most gradular level might also require a 'lock down' to avoid users surfing for and locating dashboards they

Would you like to get a quick preview of the gauge you are using in the BI Dashboard Indicator? Just tap the 'Select ...' button to the right of the 'Gauge type:' dropdown box. There are then images of what these gauges look like, such as the 'Dials' category below:

Information Map Studio allows data managers the ability to join tables, create new data elements, and label/format data items for business consumption. However due to this flexibility users must weigh the benefits of customizing information maps against the performance impacts of completing many of these tasks within the Information Map

Ran across a situation last week that proved extremely helpful. We needed to generate detailed logs on Web Report Studio use in order to verify pooling was setup correctly and then to monitor performance of some poor performers. The easiest and most straightforward way to accomplish this was to follow

My last blog post about the Analytics Camp 2010 conference relates to Farhad Islam's talk about "Real-Time Analytics, Getting results when you need it". Farhad proposed that changes must occur not only at the Business Intelligence vendor level, but also to both operating systems and hardware to increase response time of analytical requests.

During the Analytics Camp 2010 event last weekend, I attended Manya Mayes presentation on Text Analytics. I noted two 'All Abouts' that affect any content analysis being completed. No, not the Girl Scout Cookies, but what really ensures successful analysis of content. And by content, I mean any non-numeric, non-standard context, which

During Analytics Camp 2010 this past weekend, I facilitated a discussion with a great group of attendees looking to create or improve their own dashboards. The question asked was: "What should all dashboards have to make them useful & successful?" During this discussion I added *** within my notes around

Out of the box, no members of the SASUSERS group are allowed to create OLAP Cubes. In 9.2, the error message states "The security package failed while authenticating a user", included below is a screen shot. The fastest way to remediate this is to allow the SASUSERS group to have

The 4.2 version of SAS Information Map Studio provides data managers with the ability to create a dynamic filter based on dates. This is extremely valuable for things such as daily reports. Included below is an example of a new filter that is built off a date formatted data item.

Conditional formatting for numeric values is pretty simple for users in Web Report Studio, but how about colors on categorical values - such as customer name, product type, issue severity etc. (This was requested from a WRS user in the SAS Discussion Forums) Turns out this can be done, however

The easiest option is to simply move your 9.2 format catalog to Lev1/SASApp/SASEnvironment/SASFormats/formats.sas7bcat. But you can also modify your SASv9.cfg configuration file to point to a different location: -set fmtlib1 "E:sharedformats" -fmtsearch (fmtlib1.formats) So e:sharedformats is a shared location for the format catalog, and formats (filename formats.sas7bcat) is the name

A couple notes on how to set up and use a SAS dataset for a BI Dashboard Data Model. 1. The folder location (for TS2M2 installations) of dboard_sas.dsx is: <config dir>Lev1AppDataSASBIDashboard4.2dataSourceDefs 2. The format for the libref change is LIBRARYName 'File Location'; LIBRARYName 'File Location'; Such as: <LibRefs>BIDASH 'C:SASDataBIDashboard';</LibRefs> Where

Have you looked into scheduling reports in Web Report Studio? Two scenarios that make this option valuable to SAS Business Intelligence Users: 1. Performance Improvement via Report Caching If the data is only updated weekly (for instance) but the report is viewed multiple times in the week, scheduling the report

Included are some notes on Portal Administration in SAS 9.2. 1. Create a User Group in SMC, include members and a content administrator to this group. 2. Restart the Web Service or Log into Portal as sasadm@saspw (per documentation: http://support.sas.com/documentation/cdl/en/biwaag/63059/HTML/default/ag_permissiontrees.htm) 3. Configure a group content administrator by opening the 'Group

So you want to grab tweets from twitter? There are several other blog posts to assist, including the SAS blog reference below. Grab the status of one twitter account (changing USERNAME to the twitter handle) via: http://twitter.com/statuses/user_timeline.xml?screen_name=&USERNAME&count;=3200 Then to help folks get jumpstarted, use the XMLMAP that I created below

As I mentioned earlier this week via Twitter: "Newsalert: You are no longer considered an expert if you hoard all the info to yourself. You MUST share - train/blog/ppr/tweet!" (http://twitter.com/angelahall1/status/7445045263) I have personally experienced subject matter experts who refuse to share the information they learn. They feel they must charge

For SAS 9.2 implementations, changing SASADM, SASSRV, and other SAS account passwords has gotten much easier. The SAS 9.2 Deployment Manager Tool (found at /SAS Deployment Manager/9.2/config.exe) can actually be run to complete this task! The section starting with "To update a password with SAS Deployment Manager:" on page: http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/a003071148.htm#a003262956

When you are looking for SAS geared jobs, Monster.com and other main Job Boards are pretty good. However there are niche locations on the web to help you with a SAS specific job search. Included is my initial list: 1. SAS Professionals (http://www.sasprofessionals.net/) 2. I-Crunch Data (http://www.icrunchdata.com/) 3. Linked In Group:

First, there were some joke tweets this past week about funny/off-the-wall iPhone apps ~ playing off the marketing: ‘There’s an App for That’. Then there were discussions on application development processes with co-workers. So these lead me to consider the current options for SAS shops to surface information to their

As you might have noticed, you are unable to select a brand new file location for SAS code when creating a SAS Stored Process via Enterprise Guide. The only options are previously defined 'source code repositories'. The SAS Administrator (or anyone else with SAS Management Console & the associated access), can