![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
|
Hi, I would like to know your experiences with MS Analysis Services 2000 / OLAP Frontends, like Excel, Panorama Novaview, ProClarity, ReportPortal and XMLA. Regards, Marco |
#2
| |||
| |||
|
|
Everybody knows how to use Excel, but the OLAP functionality is limited to browsing unless you do a lot of custom programming. Several vendors make Excel add-ins and those are worth looking at. XMLA is a protocol, not a product. The advantage of XMLA is when you have really large dimensions. It keeps the dimensional metadata on the server so you don't have to download massive volumes of metadata to the client. I have experience with ProClarity and Panorama. It's hard to beat the ProClarity Professional thick client. The zero footprint, browser based clients are OK if you are doing basic (read that as really, really basic) reporting. Otherwise they are all underpowered. "Marco Groeneveld" <olap (AT) gmsbv (DOT) nl> wrote in message news:211f845f.0502160007.651157c7 (AT) posting (DOT) google.com... Hi, I would like to know your experiences with MS Analysis Services 2000 / OLAP Frontends, like Excel, Panorama Novaview, ProClarity, ReportPortal and XMLA. Regards, Marco |
![]() |
| Thread Tools | |
| Display Modes | |
| |