SAS OLAP CUBE - PRDSALE URGENT !!

Reply
Occasional Contributor
Posts: 5

SAS OLAP CUBE - PRDSALE URGENT !!

Hello all !!

I am a student and really new to SAS, and I do not have SAS OLAP SERVER and have only base SAS installed on my computer. Can some one please provide me with the sample cube that is generated from PRDSALE so that I can directly work on it using Enterprise guide. I really need this to satisfy a subject credit.

Any help would be really appreciated and remembered !!

Thanks,

Harsha

Super User
Posts: 19,877

Re: SAS OLAP CUBE - PRDSALE URGENT !!

Posted in reply to hpanasa2002

The name is the same as the sashelp.prdsale data set installed on any SAS install so if its the same you should be able to get the same numbers if that's all you need.

Occasional Contributor
Posts: 5

Re: SAS OLAP CUBE - PRDSALE URGENT !!

Reeza, the problem is I dont have the OLAP SERVER in order to create the cube for it !! If some one can give me the cube I can go ahead and work on it using SAS EG ...

Super User
Posts: 5,441

Re: SAS OLAP CUBE - PRDSALE URGENT !!

Posted in reply to hpanasa2002

You need OLAP Server for browsing a cube as well, I believe...

Data never sleeps
Super User
Posts: 19,877

Re: SAS OLAP CUBE - PRDSALE URGENT !!

What do you need from the cube for your assignment? 

Occasional Contributor
Posts: 5

Re: SAS OLAP CUBE - PRDSALE URGENT !!

I need to implement the calculations and functions mentioned in this paper : http://www.stratia.ca/papers/olap_mdx.pdf

Occasional Contributor
Posts: 5

Re: SAS OLAP CUBE - PRDSALE URGENT !!

Posted in reply to hpanasa2002

It would be really helpful if you can provide the cube !! May be I could try and see whether its working or not !!

Super User
Posts: 19,877

Re: SAS OLAP CUBE - PRDSALE URGENT !!

Posted in reply to hpanasa2002

I can't.

The export option puts it as a dataset and that you already have in SASHELP. I'm fairly certain the OLAP cube needs to be on a server, so if you don't have a server you're out of luck.

A very long cumbersome way is to download SQL Server Lite, export PRDSALES, create an OLAP cube with SQL Server and then connect EG to the SQL Server.

Occasional Contributor
Posts: 5

Re: SAS OLAP CUBE - PRDSALE URGENT !!

Oh !! got you !! but thank a lot for helping me through !! would really consider the alternative if I have no other option !! Smiley Happy

Ask a Question
Discussion stats
  • 8 replies
  • 355 views
  • 0 likes
  • 3 in conversation