https://communities.sas.com/t5/SAS-Programming/SAS-ASP-NET/m-p/42996#M8807 Only a partial answer:<BR /> - You need a SAS OLAP Server to surface SAS OLAP cubes (you can build them without this server).<BR /> - Instead of programing everything by yourself you could try to use MS Excel together with the SAS Add-in for MS Office (AMO). Create a pivot table and you can surface the SAS cubes.<BR /> I don't have too much experience with .net but I believe to remember that I've seen Excel "objects" in Visual Studio. No idea how this works together with a SAS Add-in - but I would try to go down this road (with a lot of Internet research).<BR /> <BR /> Besides of AMO have also a look at the SAS OLAP viewer - there should be a possibility to implement one of the two as kind of portlet (or something similar in .net).<BR /> <BR /> There might be other and better ways how to do it - keep us informed if you learn more.<BR /> <BR /> HTH<BR /> Patrick Tue, 02 Sep 2008 10:39:16 GMT Patrick 2008-09-02T10:39:16Z https://communities.sas.com/t5/SAS-Programming/SAS-ASP-NET/m-p/42995#M8806 Hi,<BR /> <BR /> I created cubes in SAS DI 3.4, now i am looking for publish cubes using Asp.Net,<BR /> it must provide information about profit, revenue and expenditure for different dimensions like Time wise, Product wise, Geogrpahy wise and Channel wise.<BR /> <BR /> My Question is How to connect to sas cubes from Asp.net and how to publish them and is it possible or not, if possible how, What we require.<BR /> <BR /> Please provide information regarding this query. Mon, 01 Sep 2008 05:11:58 GMT https://communities.sas.com/t5/SAS-Programming/SAS-ASP-NET/m-p/42995#M8806 LOK 2008-09-01T05:11:58Z https://communities.sas.com/t5/SAS-Programming/SAS-ASP-NET/m-p/42996#M8807 Only a partial answer:<BR /> - You need a SAS OLAP Server to surface SAS OLAP cubes (you can build them without this server).<BR /> - Instead of programing everything by yourself you could try to use MS Excel together with the SAS Add-in for MS Office (AMO). Create a pivot table and you can surface the SAS cubes.<BR /> I don't have too much experience with .net but I believe to remember that I've seen Excel "objects" in Visual Studio. No idea how this works together with a SAS Add-in - but I would try to go down this road (with a lot of Internet research).<BR /> <BR /> Besides of AMO have also a look at the SAS OLAP viewer - there should be a possibility to implement one of the two as kind of portlet (or something similar in .net).<BR /> <BR /> There might be other and better ways how to do it - keep us informed if you learn more.<BR /> <BR /> HTH<BR /> Patrick Tue, 02 Sep 2008 10:39:16 GMT https://communities.sas.com/t5/SAS-Programming/SAS-ASP-NET/m-p/42996#M8807 Patrick 2008-09-02T10:39:16Z