OLAP Calculated Members need to be tested to ensure that the numbers are correct in various tools. What we recently found was that the member tested properly in the OLAP Studio View Cube but then in Web Report Studio, the measure wasn’t correct. Essent…
Tag: OLAP
Adding Negative Solve Orders to OLAP Calculated Members
OLAP Calculated Members need to be tested to ensure that the numbers are correct in various tools. What we recently found was that the member tested properly in the OLAP Studio View Cube but then in Web Report Studio, the measure wasn’t correct. Essent…
Reducing the OLAP Cube Size in 9.2
In 9.2, OLAP Cubes can be updated incrementally. This is awesome, as you then don’t have to worry about users locking your cube by closing the Web Report Studio window or leaving their EG session running.However, at the same time, this can cause the si…
Implementing OLAP Member Level Security for All Vantage Points
In SAS 9.2, OLAP Member Level Security became that much easier to implement. From SAS Management Console, an administrator can navigate directly into the OLAP Cube Dimension, add a user, grant explicit ‘Read’ access and click a button to get a snazzy i…
Locked out of updating SAS OLAP cubes?
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…
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…
so what is a SAS OLAP N-WAY anyway?
In SAS OLAP, you have the ability to choose whether to not create the N-WAY & as I highlighted in a prior post, not creating it changes your OLAP type to either a HOLAP or ROLAP. But the real question is what the heck is this N-WAY thingy anyhow? F…
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 …