SAS Learning Post

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

Angela HallOctober 1, 2009 0

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

When you open a 4.1 EG Project in 4.2, Enterprise Guide converts the project on it's own. However, if you have had modifications in the SAS 9.2 Metadata (such as with servers (such as moving from SASMain to SASApp), libraries (SASUSER to WORK), information map folders, or stored process file locations how can

Angela HallSeptember 30, 2009 4

PAM-enabled SAS Authentication - a caveat

We recently ran into a situation where a customer, with metadata and compute servers on Linux and mid-tier on windows, was trying to leverage the out-of-the-box Pluggable Authentication Module (PAM) support of SAS 9.1.3. PAM allows SAS customers to keep their user management simple by granting users on a Linux

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

Angela HallSeptember 29, 2009 2

A Paradigm Shift: 'Folders' Tab in Management Console 9.2

There is a Paradigm Shift waiting for SAS Administrators in the new SAS Management Console environment. The new 'Folders' tab ... But honestly, the changes have some STRONG benefits! We just have to change our process for defining and managing the metadata. In prior versions, SAS was a singular list

Angela HallSeptember 28, 2009 0

Addressing Multiple Authentication Accounts

In SAS Management Console, administrators have the ability to include multiple user authentication models (ie user name/pwd combinations) for a single Metadata user account in the 'Accounts' tab. Administrators would then organize these by the Authentication Domain definition in SAS Management Console. The 'DefaultAuth' is the initial account used (unless

Angela HallSeptember 25, 2009 0

Favorite Things about SAS 4.2 Enterprise Guide

Are you still debating on the move to the SAS 9.2 environment? Still? Here are some things I REALLY like in the new product. Good work SAS! Allows you to pick which Metadata Server to connect to on initiation. This is of EXTREME value to those who used multiple environments for development

Angela HallSeptember 24, 2009 1

Creating a Shared Prompt for Multiple IMAPs and STPs (9.2)

Within SAS 9.2 you can now create shared prompts to use across information maps and stored processes. To get to the Shared Prompt capability from SAS Management Console: Move to Folders Tab Create Stored Process enter 'dummy' data for STP screens until you arrive at the Parameter Entry Screen. On

Blogs

Blogs

Tag: business intelligence