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 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").
Thanks. Do you happened to know the basic SAS code to create a plot using proc gplot and data from OLAP CUBE.
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*/
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.