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
Just a quick tip on the shared prompts in SAS Information Map Studio: When attempting to select a previously created prompt in Information Map Studio, SAS will only display shared prompts that can be used for the type of variable you are filtering/prompting. For example, if you have a date value
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
If you are heavy Add-in to MS Office users and are looking to upgrade to SAS 9.2, now is the time! The new maintenance release of SAS provides a much needed fix for Add-in to MS Office. Found that in the last release (TS2M0), Add in users were unable to
Let me just say, I am loving SAS 9.2 and it's functionality for cascading prompts. I created a dynamic list prompt (the icing to that cake by the way) pointing to a sas dataset that has two variables: County and City. In Prompt #1, I created a County Selection pointing
Starting on September 1st, covering every working day, I began a thirty day challenge (twitter #30dchallenge) to accomplish a couple of goals: 1. Continue to increase my skills/knowledge of the new SAS 9.2 System Topics included both versions (SAS 9.1.3 and SAS 9.2), multiple components (SAS Enterprise Guide, SAS Management
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
There are a couple of options with getting SAS Stored Processes to access Metadata Libraries. 1. Pre-Assignment of Libraries or Connecting as a Single (and therefore Shared) SAS User Account The pre-assignment of libraries means that when the Object Spawner is initiated, the libraries are made available to the end
