I was struggling with a calculated member that completes a distinctcount of members in a dimension, the performance was simply unacceptable. After attempting several other measures such as count(), processing changes on the source data, etc, I sent out a msg on Twitter asking for advice. Once again, why aren't
Tag: Business Intelligence
Included are a few of my favorite things about the new OLAP Server (for SAS 9.2 EBI Installations). Export/Import via SAS spk file The .spk files are packages that contain everything needed to export from Development and import into Production. This is an IDEAL way to reduce dev-test-prod interactions on the
After mentioning the requirements in SAS Management Console to create and edit Shared Prompts (https://blogs.sas.com/content/bi/2009/09/24/creating-a-shared-prompt-for-multiple-imaps-and-stps-9-2/), I then came across functionality in SAS Enterprise Guide 4.2. In the 'Server List', there is a small blue circle with a 1-2-3 and when you mouse over you will see 'Prompt Manager'. When adding
A user who is a member of the "SAS Administrators" group and has been granted the role "Management Console: Advanced" can create a Metadata Backup job via SAS 9.2 Management Console. Right Click on 'Backup and Restore' Task under 'Metadata Utilities'. Then select the Backup task created and choose either
Included are several of the key elements of the new Configuration Manager Plugin that I heart. 1. Modifying the Web Connection Information One of the MAIN items I love about the new version is the ability to modify the configuration of the Web Applications WITHOUT redeploying all the war files. You
(SAS 9.2) To get the SAS BI Dashboard to work appropriately, the users who have Role level access to modify and create Dashboards MUST also have read/execute/write access to the BIDashboard configuration folder (example of this location: C:SASEBIserverLev1AppDataSASBIDashboard4.2) 1. SAS Management Console: The Group "BI Dashboard Administrators" by default is
The SAS 9.2 XML engine is very very very slick. I created an xml map to generate a dataset from xml generated during a metadata getobjects job to then run call execute statements for a proc metalib update. "Wait, you did what??!@#?&" you ask? Here are my simple steps. This
Would you like to make the Migration Utility easier to use for your users? There is a MappingInformation.xml file which can assist by completing the maps from old to new items (libraries, file references, information map locations, stored processes, etc) on pg 5 of the MigrationWizard.exe. In order to implement
A couple of changes to the interface tripped me up this month. Included are some quick notes. 1. My Favorite Feature is the MDX Editor Since I create Stored Process Queries off of OLAP cubes, I start with the MDX Editor. (Writing MDX from scratch is very painful. Trust me.)
Mike Thomas, SAS Software Manager, BI Dashboards & Mobile Technologies talks about the new development for the Blackberry and iPhone. Web Links: SAS.com: http://www.sas.com/apps/webnet/SGF2009VideoBlog/index.html?videoID=isgf09ep19
I’ll admit I am particularly fond of a saying, “Begin at the beginning.” All too often we get ahead of ourselves when trying to tackle a problem. And without a clear understanding of the full scope of a problem, there’s always the risk of making it worse. Something like this
I’ve read - and heard - that SAS spoils its employees. I’ve been at SAS for six months, and it’s true. A great example is the training. Earlier this week, I was invited to attend a SAS® Hands-On Workshop. The workshop is actually designed for customers, but open to everyone.
Did you know that there is a wealth of SAS Training Material for free? I have this bookmarked for reference material and continued education. Free Tutorials: UPDATED URL (2009Aug03) http://support.sas.com/training/elearn/tutorials/ SAS Papers Online: http://support.sas.com/rnd/papers/ Users Group Proceedings: http://support.sas.com/events/sasglobalforum/previous/online.html
I’ve never found a great user guide, not to say that one doesn’t exist. You should be able to schedule any type of executable/job like a batch file from using the Platform LSF client tools (packaged with the server tools). You can also use command line executables like bsub and
The data table creation date is sometimes necessary, say in the footnote of your stored process. Included below is a sample to retrieve this date from the file system. /*Open the dataset*/ %let dsid=%sysfunc(open(sashelp.shoes)); data _null_; /*grab the CRDTE function*/ ddate=%sysfunc(attrn(&dsid;,CRDTE )); /*Format in DDMONYY*/ call symput('ddate', put(ddate, dtdate9.)); run;
~ Contributed by Hope Squires ~ Daniel Schorr is one of my favorite NPR reporters. I just hope he doesn’t mind me announcing that in a blog. Schorr has some strong opinions about what blogging has done to the news industry. In a recent Q&A with The Sacramento Bee, he
I was reading an article in Project Manager Today magazine (more interesting than it might sound) about 'Unknown Unknowns and Risk' and it made reference to Donald Rumsfeld's infamous comment about "we know there are some things we do not know". Actually, he was making sense in a garbled sort
I've received a lot of reactions to my sascom article Getting a real return on your ERP investment. Many questions have focused on my statements about agility and the differences between agility in operational (ERP) and decisional (Business Analytics) environments. Agility in an operational environment means that your IT department
I have emailed this simple code up & down the east coast. My memory isnt as good as it use to be, so I also have a copy nearby to implement when onsite. This updates the metadata within the specified library (and delete tables/info if it no longer exists in
Joining SAS in North Carolina as a marketer from New York City has been a real eye opener. Language like OLAP, DI, ERM, DPPM and various other business intelligence buzzwords have been thrown my way in a vernacular I am not completely used to. The cuisine and culture are a
Cross tabulations in SAS Web Report Studio don't work with just category/qualitative data. A measure is required. So how to count the number of records that exist in the group? Using the SASHELP.SHOES data table, we would like to count the number of subsidaries that exist within a region, or
I'm writing from the freezing cold press room in a resort in sunny Orlando, Florida, where SAS is hosting its annual customer and executive conference, SAS Global Forum. Amid the buzz from journalists arranging interviews with SAS customers, executives and industry thought leaders like Guy Kawasaki and Thornton May, I
The majority of governments around the world are parties in a 'social contract'; simply put, citizens give them permission to raise funds through taxation etc, decide on policy (what to spend the money on) and then invest or disperse funds on their behalf. However, many governments are faced with increasing
I've read lots of coverage recently about the new Butler Group report that says public sector agencies could be making better use of business intelligence. That's good to know and not too surprising - but how? Peter Dorrington, head of industry marketing strategy at SAS UK, has a few ideas.
So you have installed the SAS System, and you can check what is licensed with the proc setinit command, but what if something hiccuped in the install. Or your supporting (I mean validating) someone else's install and you need to quickly see what is available? Included below is some 'found'
Even as stated in current SAS OLAP training sessions, refreshing OLAP Cubes doesn't work as documented. Problems arise when specifying special options for formats (like reducing from $300. to less than the maximum $256.) since these are not stored in the saved PROC OLAP code. Also, if you run the