BookmarkSubscribeRSS Feed
mjack
Calcite | Level 5

In all databases (RDBMS, MDDS(multidimensional database)), there are tables with rows and columns...

Then how data is stored in Cubes for MDDS(multidimensional database)..   This I am very confused?

I can run a query against a table... but how can I run query against a cube? Can any expert help explain this...with some simple examples...

2 REPLIES 2
Jaheuk
Obsidian | Level 7

you can't run a query against an OLAP cube, read this: OLAP cube - Wikipedia, the free encyclopedia

or if you are a nerd you can user MDX: MultiDimensional eXpressions - Wikipedia, the free encyclopedia

for reading SAS cubes just use Entreprise Guide Smiley Wink

Herman

LinusH
Tourmaline | Level 20

For use of MDX in SAS, see SAS(R) 9.4 OLAP Server: MDX Guide, Second Edition.

If your cubes resides in an external data source, you need SAS/ACCESS to OLEDB to query that OLAP source usig MDX: SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Third Edition

If you refer to SAS cubes, you can also put an Information Map on top of it. In turn, you can access this via the INFOMAP libname engine - which lets you query the information map using any programming component in SAS Language/Procedures. Base SAS(R) 9.4 Guide to Information Maps

Data never sleeps

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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