Blogging about all things SAS

March 6, 2010

SAS Access – Who plays nicely with who(m)

Filed under: Architecture and Administration, x - Notes to Self — Shane Gibson @ 9:59 pm

Just saw this post on Chris H’s blog here and I am replicating it so I can find it when I need it. (cause half my posts are there so I can find them when I need them)

If you want to know what version of SAS/Access works with what operating system and what release and what database etc, then look here:

http://support.sas.com/matrix/list?SAS=All&Engine=All&OS=All&googleTrack=on

December 2, 2009

Summary of SAS 9.2 Migration Course Tweets

Filed under: x - Notes to Self — Tags: — Shane Gibson @ 5:17 pm

Well course is over and I passed, so wahoo for me!

I am blogging all my tweets from the course so it is easier for me to search them in the future.

(more…)

SAS 9.2 External Identities

Filed under: x - Notes to Self — Tags: — Shane Gibson @ 11:20 am

SAS 9.2 now has the concept of External Identities against a user or group.

The following is an extract of the online help:

(more…)

October 21, 2009

ABM 6.x and SAS Share, You need to love identical twins

Setting up SAS Share to enable you to Import and Export ABM models is one of those things that always seems to be a bit tricky to get working.

I found a public doc on the old ABC Tech support site here, that explains the steps. I have also cut and paste the content below in case the doc disappears.

One thing to note is that if you have two SAS servers wanting to talk via this SAS Share link (i.e one with SAS ABM and the other with SAS DI or EG etc) you need to make sure the SAS Share names are identical on both servers or it wont work!

Oh and don’t forget that you need SAS Share OLEDB client on every PC that wants to export/import. You can install this from the SAS ABM Client install page on your ABM Webserver.

(more…)

October 1, 2009

SAS 9.1 / WRS 3.1 – Changes to Metadata Roles takes it time

While researching and testing the default Web Report Studio metadata security I noticed this little trick for young players, which means changes to WRS/WRV Metadata Security for a user are not instantly applied/recognised in WRS/WRV.

Words from the SAS tech support note “Changes to SAS® Web Report Studio role memberships might not immediately be enforced:

“SAS Web Report Studio analyzes role memberships every 30 minutes. So, for example, if you move a user from the WRS Report Author role to the WRS Report Consumer role, the user will continue to have author privileges until the next time that he logs in after the next role membership analysis is performed.

So effectively the WRS/WRV applications are caching the Metadata security to remove the need for the web server to query the Metadata Server each time a user logins.

So try not to be fast when testing your WRS Metadata security changes, else you will think you have done something wrong. And remember to logout and log back in after the cache has been updated.

You can update the LocalProperties.xml file to change the refresh time, and therefore make the changes appear sooner. Details on how to do this are in the SAS Tech Support note.

September 30, 2009

SAS Portal 4.2 open access (Public Kiosk part duex, the return of the Public Kiosk)

Filed under: Portal, SAS 9.2, x - Notes to Self — Tags: , , — Shane Gibson @ 1:58 pm

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.

July 10, 2009

How to deploy Web Report Studio (9.1.x / 3.1) to the web server

Filed under: SAS 9.1, Web Report Studio, x - Notes to Self — Tags: — Shane Gibson @ 9:40 pm

If you ever need to deploy WRS to the Web Server after an install (or wondered how SAS did it for you) there is a great SAS Support Tech Note that explains the process.

It covers deploying to Web Logic, Websphere and Tomcat.

Find it on the SAS Support site here:

Configuring and Deploying SAS® Web Report Studio

June 17, 2009

BEA JVM Mem Size

Filed under: x - Notes to Self — Tags: — Shane Gibson @ 8:46 pm

Having an issue where our BEA Managed Server is blowing the JVM limit (32bit windows) and so crashed.

Found this and needed to remember it, so excuse the note to self ;-)

Formulas for calculating memory
The following formulas give an approximation of how you need to set the arguments. These
formulas are not exact and may need to be adjusted according to your processing needs.

MEM_INT=MEM_MAX
NEWSIZE=MAXNEWSIZE=1/3 OF MEM_MAX
PERMSIZE=MAXPERMSIZE
PERMSIZE < MEM_INT
MEM_MAX MAXPERMSIZE <= 3/4 physical memory

MEM_MAX MAXPERMSIZE <= 4GB RAM

June 16, 2009

SAS Activity Based Management EASY API

Filed under: General, x - Notes to Self — Tags: — Shane Gibson @ 10:30 pm

ABCtech (who created Oros and who SAS brought a few years ago) created a tool called Easy API that enables you to automatically submit a Import. Export or Calc in ABM.

The utility is a visual basic script (.vbs) that requires a few parameters in a txt file.

One of those parameters is ABM server, but unfortunately nowhere does it describe what this connection string should be. Well in case you wanted to know this worked for us:

http://hostname/SasSolutions/ABM/Services/AutomationService.asmx

and how could you not know that you would ask …..

Older Posts »

Powered by WordPress