Can anyone recommend me good reporting tools for querying
data from cubes using MDX

Thanks

Steve

It depends what you're looking for and obviously how much
you're prepared to pay...

If you've got Excel you can use Pivot Tables to connect to
cubes for some limited functionality. Plug-ins exist for
Excel to enhance this functionality try googling 'excel
plug-ins olap'.

If you're looking for a stand-alone desktop client we use
ProClarity (www.proclarity.com) which offers a decent
level of functionality and a moderately useful API, which
you can use to deliver web reports. Cognos
(www.cognos.com) are another company doing well in this
market, and there are lots of others. Usually these aren't
cheap, but it's worth checking out
www.hungrydogsoftware.com for their OLAP client.

Thirdly you can deliver a reporting tool via the browser,
although frequently a ActiveX control is required as well.

And then there's Reporting Services...
http://www.microsoft.com/sql/reporting/default.asp

Finally go to www.olapreport.com for a full breakdown of
your options, though needless to say you need to pay for
some of it...

HTH

Phil.

Hi Phil,

or take a look at http://www.dynasight.com

thomas

I have tried them all.... the one that works the best and is easiest to use
in making complex MDX is Panorama..


Our contact:
Steve Ottinger

Panorama West Sales

Phone: (425) 351-0809

<anonymous (AT) discussions (DOT) microsoft.com> wrote

Frontends:
Panorama NovaView BI Platform 3.5 - www.panoramasoftware.com
Proclarity 5.3 - www.proclarity.com
TemTec Executive Viewer 4.2 - www.temtec.com
ReportPortal 1.2 - www.reportportal.com
DWExplorer 3.3 - www.dwexplorer.com
Cubularity Knowledge Platform 2.2 - www.cubularity.com
ZAP.BI Suite - www.zaptechnology.com
Targit - www.targit.com
DS Panel 4.0 - www.dspanel.com
IQub Browser 2.0 - www.thebitzinc.com
MIS onVision 4.1 - www.misag.com
SoftPro Manager 4.0 - www.softpro.hr
SnowflakeNET 2.6 - www.intellimerce.com
Visual Studio .NET Web Control for Business Intelligence -
http://www.microsoft.com/downloads/d...793-B3C6-4ED5-
ACB3-820D0E832151&displaylang=en
Microsoft BI Portal -
http://www.microsoft.com/downloads/d...d31-ac55-4595-
866f-267606f94f88&DisplayLang=en
....

Excel-addins:
OLAP NaviGo - www.olapnavigo.com
IntelligentApps 4.0 - www.IntelligentApps.com
Panorama NovaView Excel Client - www.panoramasoftware.com
Visual Olap 3.0 - www.visualolap.com
Xlcubed 1.0 - www.xlcubed.com
O2OLAP - www.o2olap.com
MIS Plain - www.misag.com
....


BI Reporting Tools for use with Microsoft SQL Server 2000 Reporting
Services:
Frontends:
Panorama NovaView BI Platform 3.5 - www.panoramasoftware.com
Proclarity 5.3 - www.proclarity.com
ActiveViews 1.0 - www.activeviews.com
Cizer Quick Query 2004 - www.cizer.com
Cizer Report Builder 2004 - www.cizer.com

[]'s

Renato

Brasil >> São Paulo

"minimax" <minimax (AT) dynasight (DOT) net> wrote

Hi,

We have very great results with Panorama NovaView for webbased BI/OLAP
solutions based on MS AS 2000. For a Windows client you should test
both Panorama NovaView and DW Explorer as well. We have trials of both
software for tetsing on your own enterprise systems. Please let me
know if interested.

Regards,
Marco

www.gmsbv.nl

<anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

I have seen the list got posted from time to time - but Crystal Analysis
always got missed out. Any feedback on how good/bad is Crystal Analysis?

Regards,
Yee

"Renato Leandro Giuliana" <renatolg (AT) hotmail (DOT) com> wrote

Yee,

Thank you. Do you have experience with Crystal Reports and/or Crystal Analysis?

Marco

"Yee CN" <NoSpamX_cn.yee (AT) attic-solutions (DOT) com> wrote

Yee-

You must think, when you talk about Crystal, you now have to think of
Business Objects. This past year Business Objects bought out Crystal,
or it might be vice versa... So Crystal Anaysis might, stress might,
be out of the picture.

-todd

"Yee CN" <NoSpamX_cn.yee (AT) attic-solutions (DOT) com> wrote

Actually from VB and VB.net background Crystal reports/Analysis is the first
thing that comes to mind when I think of reporting. I have been playing with
crystal analysis a bit, and it seems decent enough but I don't have any
reference for comparison. I was actually more worry that I am missing out on
something more superior.

It is a worry about it being bought over by Business Objects though.

Regards,
Yee

"Todd" <toddack (AT) hotmail (DOT) com> wrote