SAS OLAP CUBE - PRDSALE URGENT !!

[hpanasa2002]

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

[Reeza]

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.

[hpanasa2002]

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

[LinusH]

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

[Reeza]

What do you need from the cube for your assignment? 

[hpanasa2002]

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

[hpanasa2002]

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

[Reeza]

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.

[hpanasa2002]

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