olap cubes - tools

Question

olap cubes - tools

ui ranejeb

SSC Enthusiast

Points: 168
More actions
March 7, 2007 at 1:31 pm

#172629

Hi everyone,
I'm looking for a client tool for olap cubes. Do you have any experience with any? Also some prices are welcomed.
Thank you.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jim Dillon-291542 Hall of Fame Points: 3344 More actions · Answer 1

We use Excel. You also have to install the Analysis Services 9.0 OLEDB provider on the client machine to query a SSAS 2005 cube or Analysis Services 8.0 OLEDB provider on the client machine to query a SSAS 2000 cube.

I know it's Microsoft, but the tools is pretty decent for looking at data cubes.

Good Luck!

jim

SQL Adventurar SSC Eights! Points: 973 More actions · Answer 2

Hi

You could possibly have a look at "Proclarity" or "Panorama". These are both good tools.

I have only worked with Proclarity but have heard good things about Panorama.

Cheers

Jacques

Pete Brown SSC Eights! Points: 984 More actions · Answer 3

ProClarity is a very good tool for users. It is now owned by Microsoft so it should not be expensive per user.

waranya P. Valued Member Points: 72 More actions · Answer 4

Hi Jim,

Where can I get and how to install the Analysis Services 9.0 OLEDB provider on the client machine to query a SSAS 2005 cube?

Thank you.

waranya P. Valued Member Points: 72 More actions · Answer 5

I got it and can connect to OLAP server.

Thank you very much for all of you.

Jim Dillon-291542 Hall of Fame Points: 3344 More actions · Answer 6

For Future Reference you can find the download for Analysis Services OLEDB provider at the following url:

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

You'll be looking for Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider, Then choose the download that is appropriate for your environment.

Thanks,

jim