"The cube has too few dimensions." - is related to Metadata Permissions on the cubes. When completing a refresh of the cube with full PROC OLAP syntax, the metadata permissions get removed on the individual cube. If this is the common practice (to run full PROC OLAP Syntax), it is
Using the proc metalib process to update specific elements would generate errors related to the base SAS Library conflicting with the Metalib referenced library. You can run a libname _all_ list; statement to review all the libraries available to the process. Also, the reference material utilized to improve the process
Within SAS Run the following code (the purple text is the password you would like to encode): proc pwencode in='myn3wpwd4u'; run; After submitting this code (F3), the resulting encoded password in available only in the log file. The results from this example are below, the highlighted line is the encrypted
Get a jump start on your SAS 9.2 expeirence by attending some of the free (or cheap) training courses SAS has to offer. Check them out at: http://www.sas.com/apps/elearning/elearning_courses.jsp?cat=e-Lecture%20SAS%20Programming 1. SAS(R) 9.2 Session 1: New and Enhanced Procedures and Statements -- Free 2. SAS(R) 9.2 Session 2: The Macro Facility --
Think about all of the data now out there, from old transaction systems to new networking sites, there is an amazing amount for analysts to sink their teeth into. Some interesting sources that I have heard of over the past year include: Immediate web traffic analytics which then derive suggestions
During the SESUG2008 Conference, I attended the presentation: "Best Practices for SAS BI Administrators: Using SAS Configuration Troubleshooter to Keep SAS Solutions and SAS BI Applications Running Smoothly" by Tanya Kalich. It appears to be a great tool to troubleshoot initial installations or manage major changes to the configuration. The
Can you believe it? Three years ago the SAS BI-ogsource was started as a central area to store my personal musings about how to best use and manage the SAS Business Intelligence Solution (and the various components). It has been interesting meeting people from around the globe and see how
Click 'Help' -> 'About SAS Web Report Studio' to display the list of hotfixes applied to the installation. http://support.sas.com/kb/20/281.html
In the past we’ve had a lot of issues with calling stored processes from the SAS Portal without being “re-prompted” for authentication. We’ve tested this approach out and it works. http://support.sas.com/kb/19/234.html (Submitted by Brian Miles, Zencos Consulting)
Mentioned during a paper at the NESUG conference, Lex Jansen has set up a complete search of SAS papers on his website: http://www.lexjansen.com/ I typically use the SAS Global Forum search (http://support.sas.com/events/sasglobalforum/previous/online.html) but Lex brought in all the regional and industry specific papers.
