SAS Learning Post

Advanced Analytics

Move beyond spreadsheets to data mining, forecasting, optimization – and more

Angela HallOctober 20, 2009 0

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 16, 2009 0

SAS 9.2 OLAP Server has some sweet new functionality!

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 12, 2009 3

Shared Prompts in SAS BI 9.2 ~ Modifying via EG 4.2

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 9, 2009 2

Metadata Backup Utility via SAS 9.2 Management Console

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 8, 2009 0

Configuration Manager Plugin for SAS Management Console 9.2

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 6, 2009 3

Open up File Level Security for the BI Dashboard Configuration

(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:\SAS\EBIserver\Lev1\AppData\SASBIDashboard4.2) 1. SAS Management Console: The Group "BI Dashboard Administrators" by default is

English

Advanced Analytics | Data Visualization

Angela HallOctober 5, 2009 0

Automatic Updates of the SAS Data Libraries (and Tables) Metadata

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

English

Advanced Analytics | Data Visualization

Angela HallOctober 2, 2009 0

Migration Utility for EG 4.2 and Add in to MS Office (Part 2 of 2)

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

English

Advanced Analytics | Data Visualization

Angela HallSeptember 30, 2009 0

Changes to the OLAP Viewer for EG 4.2

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.)

English

Advanced Analytics | Data Visualization

Angela HallAugust 1, 2008 7

Free SAS Training Material

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

English

Blogs

Blogs

Advanced Analytics