topic Re: what's SAS OLAP server and Private OLAP server used for? in SAS Data Management

what's SAS OLAP server and Private OLAP server used for?

Jade_SAS — Tue, 16 May 2017 21:02:00 GMT

Hi All,

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?

Thnaks,

Jade

Re: what's SAS OLAP server and Private OLAP server used for?

Kurt_Bremser — Wed, 17 May 2017 06:46:03 GMT

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.

Re: what's SAS OLAP server and Private OLAP server used for?

LinusH — Wed, 17 May 2017 08:58:49 GMT

@Kurt_Bremser 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.