x – Notes to Self

Things I need to remember!

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

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

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.

Read More »

Share
Posted by  
0 Comments

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

Oct
01

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.

Share
Posted by  
0 Comments

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

Sep
30

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.

Share
Posted by  
0 Comments

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

Jul
10

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

Share
Posted by  
0 Comments

BEA JVM Mem Size

Jun
17

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

Share
Posted by  
0 Comments

SAS Activity Based Management EASY API

Jun
16

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 …..

Share
Posted by  
0 Comments

Publishing SAS Content to Sharepoint

May
14

Had a question on my blog about SAS Web parts that are available for Sharepoint and where to download them or install them from.

While researching the questin (sorry Joseph stil haven’t found them) I found this code in the SAS Paper I referenced:

data sampledata;
do n=1 to 1000;
x=int(ranuni(77777)*7);
y=int(ranuni(77777)*5);
output;
end;
run;

filename out ‘\\mySharePointServer\Shared Documents\ProcFreqExample.html’;

ODS HTML encoding=UTF8 body=out dev=gif;

proc freq data=sampledata;
tables height*weight / chisq;
run;

ODS HTML close;

So effectively you can publish to sharepoint using a simple UNC link.

I know I am going to need this in the future so this blog is a note to self.

Share
Posted by  
0 Comments

SAS 9.1 OLAP Size Limitations

Apr
27

If you have ever wondered if there is a limit to the size of a SAS 9.1 OLAP cube, then there is and it is documented on the SAS Support site underSAS 9.1 OLAP Cube Size Specifications.

According to SAS 9.2 OLAP Cube Size Specifications limitations also exist in 9.2.

10 points if you can tell me if it has changed in 9.2?

Share
Posted by  
0 Comments

SPM 2.x Periods (where are you hiding my pretty)

Apr
15

So ever wanted to know where the Period values iN SPM are actually stored?

Well as long as you aren’t trying to do some dodgy updates to the SPM schema, as you know that is against the rules…

The first trick is that Periods are stored in the SAS Solution Data Mart layer not in SPM itself.

They are stored as a master details record with:

  • the master being in SASSDM.sas_member where INTERNAL_DIM_TYPE_ID = -9
  • there are three children records in SASSDM.sas_member_property (joined on member_id) whihc cover:
    • Start Date
    • End Date
    • Period Type

Of course as I have said don’t touch these manually and you should really use the prebuilt SAS Time view to look at them

Share
Posted by  
0 Comments