Developing an OLAP cube, testing in Enterprise Guide or Web Report Studio, and suddenly you begin getting error messages from rebuilding the OLAP Cube stating that it’s locked. Now what do you do? Restart the OLAP Server? Well, if you don’t have access…
Tag: Administration
Tuning OLAP Cubes
Included are two quick references to tuning OLAP Cubes:
Server Tuning Information ~ http://support.sas.com/documentation/cdl/en/biasag/61237/HTML/default/viewer.htm#a003145996.htm
Cube Tuning Information ~ http://support.sas.com/documentation/cdl/en…
Moving OLAP Cubes (Part 2 – Management has all the options)
As mentioned in my previous post, there is the need to move OLAP cubes around. Switching to one schema to another via SAS OLAP Cube Studio is straightforward enough, but what if you need to move it from one Business Intelligence Environment to another …
Moving OLAP Cubes (Part 1 – It’s all between the schemas)
SAS recommends building OLAP Cubes on a separate ‘non-production schemas’ because cube building can be resource intensive and time consuming. Each OLAP Server can be defined to one & only schema at a given time, therefore you will need to setup the…
Strategies to Address Locked Files Issue
So you’ve got a nightly process that updates a file somewhere. Unfortunetly, something still has it locked and the update fails, the nightly process crashes & burns, and someone at 8am upon arriving decides to blast you for not having updated data …
Tired of Typing domain/username to access SAS components?
The following option can be added to the Metadata Server to default users to a specific DOMAIN. This removes the requirement of using domain\username or username@domain formats for the username field.
-authproviderdomain (HOSTUSER:DOMAINNAME)
I …