topic Re: SAS OLAP CUBE - PRDSALE URGENT !! in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109966#M258845 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 14 Feb 2013 20:07:58 GMT Reeza 2013-02-14T20:07:58Z SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109965#M258844 <HTML><HEAD></HEAD><BODY><P>Hello all !!</P><P></P><P>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.</P><P></P><P>Any help would be really appreciated and remembered !!</P><P></P><P>Thanks,</P><P>Harsha </P></BODY></HTML> Thu, 14 Feb 2013 18:39:32 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109965#M258844 hpanasa2002 2013-02-14T18:39:32Z Re: SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109966#M258845 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Thu, 14 Feb 2013 20:07:58 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109966#M258845 Reeza 2013-02-14T20:07:58Z Re: SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109967#M258846 <HTML><HEAD></HEAD><BODY><P>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 ...</P></BODY></HTML> Thu, 14 Feb 2013 21:13:02 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109967#M258846 hpanasa2002 2013-02-14T21:13:02Z Re: SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109968#M258847 <HTML><HEAD></HEAD><BODY><P>You need OLAP Server for browsing a cube as well, I believe...</P></BODY></HTML> Thu, 14 Feb 2013 21:33:22 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109968#M258847 LinusH 2013-02-14T21:33:22Z Re: SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109969#M258848 <HTML><HEAD></HEAD><BODY><P>What do you need from the cube for your assignment?&nbsp; </P></BODY></HTML> Thu, 14 Feb 2013 21:35:09 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109969#M258848 Reeza 2013-02-14T21:35:09Z Re: SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109970#M258849 <HTML><HEAD></HEAD><BODY><P>I need to implement the calculations and functions mentioned in this paper : <A href="http://www.stratia.ca/papers/olap_mdx.pdf" title="http://www.stratia.ca/papers/olap_mdx.pdf">http://www.stratia.ca/papers/olap_mdx.pdf</A></P></BODY></HTML> Thu, 14 Feb 2013 21:37:26 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109970#M258849 hpanasa2002 2013-02-14T21:37:26Z Re: SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109971#M258850 <HTML><HEAD></HEAD><BODY><P>It would be really helpful if you can provide the cube !! May be I could try and see whether its working or not !!</P></BODY></HTML> Thu, 14 Feb 2013 21:38:15 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109971#M258850 hpanasa2002 2013-02-14T21:38:15Z Re: SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109972#M258851 <HTML><HEAD></HEAD><BODY><P>I can't.</P><P>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.</P><P></P><P>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.</P></BODY></HTML> Thu, 14 Feb 2013 22:00:49 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109972#M258851 Reeza 2013-02-14T22:00:49Z Re: SAS OLAP CUBE - PRDSALE URGENT !! https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109973#M258852 <HTML><HEAD></HEAD><BODY><P>Oh !! got you !! but thank a <SPAN style="font-size: 10pt; line-height: 1.5em;">lot for helping me through !! would really consider the alternative if I have no other option !! </SPAN><img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Thu, 14 Feb 2013 22:05:58 GMT https://communities.sas.com/t5/SAS-Programming/SAS-OLAP-CUBE-PRDSALE-URGENT/m-p/109973#M258852 hpanasa2002 2013-02-14T22:05:58Z