Author

Angela Hall
RSS
Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

Advanced Analytics | Data Visualization
Angela Hall 0
Grabbing the Data Creation Date

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;

Angela Hall 0
Exporting OLAP Cubes

In SP4, you can export OLAP cubes into .xml files. Right click the Cube from SAS OLAP Cube Studio, select 'Export Cube'. This is an appropriate part of a migration strategy through dev-test-production, since they can then be imported through the 'Import Cube' button on the left menubar.

Angela Hall 2
SAS JMP Configurations for Business Intelligence

Three different setups for SAS JMP are listed below. Upwards compatibility (i.e. level 1 to 2) available, downwards less likely (like we know STPs are not). Level 1. SAS JMP and SAS Base installed and licensed on individual desktop/laptop. Level 2. SAS Integration Technologies installed on server, SAS JMP installed

Angela Hall 0
SASADM and EG Don't Particularly Like Each Other

Check this out:http://support.sas.com/techsup/unotes/SN/020/020072.html “IMPORTANT NOTE: You should NEVER use an Unrestricted User (the "unrestricted user" account; for example, the sasadm ID with a "*" prefix in the adminUsers.txt) to log on to any client application except SAS® Management Console. The "unrestricted user" account is intended to be used ONLY as

Angela Hall 0
Password Changes in BI

Included are some resources to help those of you who need to change SAS account passwords on your BI installation. (Notice: This is not for the faint of heart.) http://support.sas.com/rnd/papers/sugi31/securedeployment.pdf http://support.sas.com/documentation/configuration/bisecag.pdf (Chapter 5 & specifically pg98-102) http://support.sas.com/techsup/technote/ts736.pdf Side Note: SAS Technical Support and R&D; have a utility in their 'toolpool'

Angela Hall 0
Forget MDDB to OLAP Migration

There is no good way to migrate MDDBs to V9Cubes. Here is an excerpt from the SAS migration website (http://support.sas.com/rnd/migration/planning/files/mddb.html): “There is no automated method to convert Version 8 MDDB code to SAS 9.1 OLAP code. PROC MDDB executes in SAS 9.1. However, it creates a Version 8 MDDB that

Angela Hall 0
Happy 2nd Birthday

SAS BI-ogsource is now 2 years old! Hope everyone has enjoyed the content over the years. Please feel free to contact me with feedback, suggestions, or even ideas for new posts! BI Weblog Email Address

Angela Hall 0
MDX Query Optimization with SETS

Overall, query response time dramatically decreases with the use of sets, therefore it is preferred that user selections (or the cube itself) prevents the potential of choosing multiple members within the same dimension. Queries that only included 1 member in the slicer but are still represented as a set are

1 23 24 25 26 27 32