BookmarkSubscribeRSS Feed
Jade_SAS
Pyrite | Level 9

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

2 REPLIES 2
Kurt_Bremser
Super User

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.

LinusH
Tourmaline | Level 20

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

Data never sleeps

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1898 views
  • 0 likes
  • 3 in conversation