How do you get a SAS gplot in SAS OLAP CUBE Studio

Reply
Occasional Contributor
Posts: 10

How do you get a SAS gplot in SAS OLAP CUBE Studio


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.

SAS Employee
Posts: 340

Re: How do you get a SAS gplot in SAS OLAP CUBE Studio

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").

Occasional Contributor
Posts: 10

Re: How do you get a SAS gplot in SAS OLAP CUBE Studio

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

SAS Employee
Posts: 340

Re: How do you get a SAS gplot in SAS OLAP CUBE Studio

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*/

Ask a Question
Discussion stats
  • 3 replies
  • 186 views
  • 3 likes
  • 2 in conversation