05-16-2017 05:02 PM
I have a quick question for you:
What's SAS OLAP server and Private OLAP server used for?
Will the SAS users or SAS admin use those two servers?
05-17-2017 02:46 AM
OLAP servers serve MDDB's (Multi-dimensional databases), aka "Cubes", for analysis. They do this through the MDX query language.
SAS provides OLAP servers which are defined in metadata and run on your SAS compute platform. These are seen in the "OLAP Servers" tree.
But you can also connect EG directly to OLAP servers provided by third parties (or SAS), and those are then seen in "Private OLAP Servers".
See SAS Note 41722.
05-17-2017 04:58 AM
@KurtBremser answer is correct, i just want to clarify about the term MDDB.
It's actually the file type of a cube within SAS8 environment. It was accessible via a libref, and was a part of the MDDB Server offering.
In SAS9, the cube is stored as files, much like SPDE tables linked together behind the scenes. The cubes are not accessible via librefs, but via PROC OLAP and OLAP Server processes.