Configuring SAS ROLAP – Solving Excel Pivot Size Issues
Had some issues with users using the SAS Addin for Microsoft Office against Info Maps where the size of the Excel file gets massive when you save it.
It seems Excel must be caching the data somewhere.
We are working on configuring SAS OLAP cubes in ROLAP mode as this removes the size issues with Excel.
Re-branding the Portal Theme
We are re-branding the project after the successful completion of decommissioning the old Data Warehouse environment at the end of the month. So we are currently changing the SAS Portal theme to match the new brand.
SAS 9.2 not supported on Windows 2008 R2 – yet!
Just found out Windows 2008 R2 is not currently supported for SAS 9.2, but it seems to work on the test install I did.
Making Reports Faster
We are using a combination of SAS Web Report Studio, for report creation/rendering and an Oracle database for data storage.
When users run reports, they effectively invoke this process:
- Connect to metadata and obtain authorisation
- Access info map and generate query
- Pass query to Oracle
- Oracle passes data to WRS
- WRS renders report
To make this faster we have been looking at configuring report scheduling to see if we can pre-cache the reports
SAS Channels
Setting up channels so that we can publish content to users without the need to store it on the filesystem.
Using Webdav as the storage mechanism.
Using custom DI code node to create content and publish as part of our standard ETL process flows.
Test Install of SAS 9.2 on Windows 2008
Doing a test install of SAS 9.2 on Windows 2008 R2, with Weblogic 10.3.
We have decided to do the install without the STM Solutions layer to make the install easier as we only want to test migration of BI and DI content.
Moving SAS users as part of 9.2 Migration
Need to migrate users from the old SAS 9.1 environment, but the client has so few users in metadata that we will manually recreate them.