When connecting to SAS Enterprise Miner 5.x on SAS 9.1.x you normally entered a connection string that was the EM servername followed by the port, with the standard port being :5199.
With SAS Enterprise Miner 6.1 on SAS 9.2 the standard port changed to :6412 (for a Lev1 environment)
In the middle of my first production SAS 9.2 upgrade (yeeehaaaaa).
After SAS had finished the install we manually converted the relevant metadata etc.
We then used the EG Migration Wizard (more on this in another post) and then tried to run the project.
Code that used to run fine in SAS 9.1 gave an error like this in SAS 9.2:
ERROR: Read Access Violation In Task [ SQL ] Exception occurred at (032F94F6) Task Traceback After applying the hotfix here: http://support.sas.com/kb/37/012.html to the server it ran fine.
Well finally got confirmation that SPM 5.1/9.2 (now known as StM 5.1) has been released.
Doco is available on the SAS Support site here:
http://support.sas.com/documentation/solutions/performmanagement/stm/index.html
You will need to email your friendly SAS Support team for a password (only if you have a SPM license though)
Enterprise Guide 4.2 and Office Addin 4.2 now have the ability to access OLAP cubes that are not registered in SAS Metadata.
Effectively this allows you to use the SAS tools to access non SAS cubes (assuming you have the OLEDB connector installed)
These are called Private OLAP Servers.
Following extract from 051-2009: What’s New in SAS® Add-In 4.2 for Microsoft Office explains it well.
PRIVATE OLAP SERVERS
Also new in 4.2 of the SAS add-in is the ability to define private OLAP servers. A private OLAP server is a direct connection to an OLAP server, rather than choosing one that is defined in metadata. The SAS Add-In for Microsoft Office now supports connecting to third-party OLAP providers, such as Microsoft Analysis Services or SAP BW, or any other vendor that defines an OLE DB compatible provider.
This is useful for users who have already invested in an OLE DB provider for OLAP. Now it is possible to use SAS to view and analyze that data. In SAS Add-In 2.1 for Microsoft Office, this was not allowed; the SAS add-in was able to connect to only a metadata-defined OLAP provider.
Once the user has opened the cube into the PivotTable, it works the same as any other PivotTable. The user has the full breadth of functionality available to them, such as drill-through, and adding calculated measures and members.
And my handwriting is crap, so I have decided to try tweeting all the stuff I need to remember (and yes got the idea from Angela at Zencos, thanks Angela)
You can follow my ramblings here:
(somebody already has sasInct, grrrrr)
When I worked briefly for Xero the office was full of very smart 20 ish olds who could tweet, icq, blog, drink coke, chat and code at the same time.
Lets see if I can do two things at once, i.e tweet and listen. Of course being a man I can’t guarantee success.
Had a tipoff from a regular support.sas.com user that there is now a few SPM 5.1 guides and usage notes now on the site.
So is SPM 5.1 released?
I haven’t seen any announcements, but then again I might have missed it.
Here are the docs I have found so far:
http://support.sas.com/documentation/installcenter/en/ikfmofrii/63034/PDF/default/install.pdf,
433KBhttp://support.sas.com/kb/37/794.html,
18KB
Let me know if you know.
I have heard from a few SAS customers who have been using some of the SAS Toolpool entries in SAS 9.1 that they no longer work with SAS 9.2.
And as of course they are toolpool entries they are not officially supported by SAS so there may not be an immediate upgrade path to SAS 9.2.
But of course some of them are still providing additional functionality that is not available in SAS 9.2.
So I have been thinking of ways to keep the development team busy over Xmas, and recreating some of these might be the ticket.
So if you have one that you need, let us know what it does, and you will never know what Santa and his elves may deliver 
Please don’t send us a copy (we write all our sasInct Portlets from scratch) but feel free to post here what it does, or create a support track at http://support.sasinct.com/login
And lastly we will post any that we develop on our website for the usual one off USD $1,000, unlimited users/no expiration, (these elves are not cheap) and of course if it is a biggy (aka Metadata Explorer etc) then we probably wont.
I posted earlier about the removal of the Public Kiosk in SAS 9.2 / Portal 4.2.
All the feedback I got stated that they turned off the Public Kiosk in SAS 9.1.3 / Portal 2.x as a matter of course.
Just noticed a SAS Tech support notice “Enabling unchallenged access to content in SAS® Information Delivery Portal 4.2” which outlines how to allow access to the portal without the need to login.
So obviously a few people still wanted it.
Chris blogged about a new article on the SAS support website: Installation Note 36616: SAS® 9.1.3 Service Pack 4 and SAS® 9.2 support for Microsoft Windows Server 2008
One of the projects I am working on the IT roadmap is to move everything to Windows 2008, whihc was always a problem for the current SAS 9.1.3 environment we are using.
Not any more I thought, wahoo, until I read the fine print that SAS Solutions are not covered, oh well back to waiting for SAS 9.2 Solutions.
Interesting that Windows 2008 support is announced for SAS 9.1.3 before it is announced for SAS 9.2
Im guessing SAS 9.1.3 has always worked with Windows 2008 but just never been tested and therefore could not be certified by SAS as an approved operating system.
If you upgarde to Windows 2008 let me know how it goes.
Suzanne posted a comment about the changes in LSF renewals that are about to happen.
Made me think about the new scheduling capability that has been bundled in SAS 9.2, so I did a little searching on the SAS Support site.
On the About Scheduling Servers page they provide a good overview of the different options which are available, which are:
So what does the In-Process scheduling server cover?
Well according to most of the support pages it only refers to Web Report Studio, but back on the About SAS Scheduling page it mentions:
I notice Enterprise Miner models are missing, I am guessing you could schedule them as custom SAS code but I do wonder if it just wasn’t mentioned because EM 6.1 was released slightly after the initial 9.2 release.
Although I did check out the What new in Enterprise Miner 6.1 page and nothing was mentioned.
Ps. There is a great flow diagram (well ok the graphics aren’t that great but you know what I mean) on the Overview of the Scheduling Process page which shows how the new scheduling all hangs together.
It reminded me of the internal presentations SAS had on flow a transaction went through when it came to Authentication and Authorisation of the SAS environment. It was the only way I finally got to understand how it all hug together, so I am a great fan of process flow diagrams.
Which is one of the reasons I liked LSF because you could see a graphical flow, and its great to see the new SAS In-Process scheduling server has graphical process flow, and they look much sexier than the LSF ones (and yes this is important!). Check out an example of the Specifying Dependencies page
Powered by WordPress