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

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

PatriciaEilerman — Mon, 08 Dec 2014 16:17:08 GMT

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.

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

gergely_batho — Mon, 08 Dec 2014 16:42:49 GMT

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

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

PatriciaEilerman — Mon, 08 Dec 2014 18:24:36 GMT

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

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

gergely_batho — Tue, 09 Dec 2014 09:13:05 GMT

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