SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

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

Reply
Frequent Contributor
Posts: 116

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

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

Super User
Posts: 6,962

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 5,260

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

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

Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 102 views
  • 0 likes
  • 3 in conversation