How to publish OLAP cube

[copernicus]

Hi,

I am new to SQLServer 2000.I have built a cube.I was wondering how to acess this from a client(say via excel or a browser).

Thanks,
copericus

[Stephen]

Excel is the easiest. Install the Analysis Server client connectivity components. Then, in Excel
- go to then Menu "Data...Pivot Table and Pivot Chart Report"
- select "External Data Source" and click next
- Click on the "Get Data..." button
- another window will pop up
- click on the "OLAP Cubes" tab
- click on OK
- another window will pop up (called "Create New Data Source")
- type a meaningful name
- select an OLAP Provider (the one ending in 8.0 is the more recent of the two if you are running SQL 2000)
- click on the "Connect" button
- type the name of the server that has the cube
- do not enter anything for the user id/password fields
- click on next
- select a database from the list and click on Finish
- Select a cube from the drop down list and click on OK
- Click on OK
- Click on Finish

You should now be back in Excel. You should see a couple of windows floating over the spreadsheet. One of these contains all of the dimensions in the cube and the other is for formatting.

If you want to access a cube from a browser, it would be worth finding some sample code. Have a look at http://www.thinslicer.net. It has a demo page on it that is accessing a cube. You can download the code that the demo is using.

Good luck
Stephen

[MAK]

0. Excel Sheet with external data - Pivot table
1. Seagate analysis
2. Cognos
3. SQL DMO

[copernicus]

Hi,

On the client machine I already have sqlserver installed with analysis services(I guess I don't have to install or configure any thing on the client).I am able to do all the steps mentioned except when I give the server name(machine name) no databases show up.I am getting stuck here.

plz advise.

Thanks,
copernicus.

[copernicus]

oops my mistake the DTC on my server was not running.Able to access now.


Thanks to everybody.

Regards,
Copericus