Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-09-23 : 15:56:31
|
| Hi,What are the mechanisms available to access a cube which has been built using the analysis services availabe in SQL Server 2000.I have looked at the option using MS-EXCEL but the users do no want to use EXCEL.Is there a way to pass MDX Queries through a OLE-DB or ODBC driver.ByeRamdas NarayananSQL Server DBA |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-09-23 : 16:26:54
|
| Out of the box, there is Excel, and Data Analyzer (Comes with office XP).To develop your own solution, there is ADOMD.Also, you can use OWC, and pass MDX to it, but that is an 'Excel like' interface. There is also 3rd party tools available. I haven't used any of them, so I don't know the best.-Chad |
 |
|
|
rharmon
Starting Member
41 Posts |
Posted - 2002-09-23 : 17:24:53
|
| We're using Crystal Analysis. It's not cheap, but fulfills almost all the needs of our internal customers. If you realy want to complicate matters, you could try working in asp/asp.net against the pivottable service that comes with Analysis services, but that's a heck of a lot of code. We've also used OWC in the past with quite a bit of success, it's got some advantages over excel, web based interface, fast deployment, xml compatable and comparatively cheap!Hope this helps,ROhar |
|
|
|
|
|
|
|
|
Access OLAP through a Client