BookmarkSubscribeRSS Feed
PatriciaEilerman
Calcite | Level 5


Hello. A co-worker of my wanted me to research is there a possible way to get a SAS gplot into SAS OLAP CUBE Studio and not a SAS table. This is first time I heard SAS OLAP CUBE studio and was wondering is it possible to transfer a plot from SAS to cube studio.

Thanks.

Edits.

Just talk to my co-worker to revise the question. Is there anyway to view SAS gplot against SAS OLAP cube? She need to know the answer as soon as possible.

3 REPLIES 3
gergely_batho
SAS Employee

SAS OLAP Cube Studio is a user interface that you use to build OLAP cubes.

When an OLAP cube is ready, you can use different tools to view it (in grafical or tabular format): Enterprise Guide, SAS Add-in for Microsoft Office, WRS, Information Map Studio etc.

All these tools access the SAS OLAP Server, where the cube data is stored.

Also you can write a SAS program that accesses the SAS OLAP server and the OLAP cubes:

SAS(R) 9.3 OLAP Server: User's Guide

Then you can write a proc gplot using the created table (in this case also called a "slice of the cube").

PatriciaEilerman
Calcite | Level 5

Thanks. Do you happened to know the basic SAS code to create a plot using proc gplot and data from OLAP CUBE.

gergely_batho
SAS Employee

proc sql;

connect to olap (host=localhost service=olap1);

create table temp as select * from connection to olap

(

select { dealers.dealer.members } on 0,

{ [cars].[Car].members,

[cars].[Color].members } on 1

from mddbcars

);

disconnect from olap;

quit;

proc gplot data=temp;

     plot Car*Color;

run;

quit;

/*code not tested*/

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 3 replies
  • 1186 views
  • 3 likes
  • 2 in conversation