Friends!

Have you got any expiriences with using SQL Server 2K Reporting Services as
an front-end to OLAP (analysis services) data?
How it can be compared to other solutions?

TIA,
Regards,
Kamil


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.532 / Virus Database: 326 - Release Date: 2003-10-27

kamel wrote:
that's becasue AS is quick. It looks great though and the subscriptions
work really nice. Pity it only exports Excel in XML, so Excel 2000 and
earlier can't handle it.

Anyway, it depends on what you're looking for. It's not in the
technology, that's fine. But why develop an OLAP (you know: On-Line
*Analytical* Processing) system and then put a reporting tool in front
of it? Of course it may come in handy to satisfy some freak requirement,
but imho you'd better save yourself the work of developing an OLAP
system and use the RDBMS as a source for this. That's what reporting
services was designed to do. Burst large volumes of static reports to a
variety of formats.

If you're doing OLAP, don't take the best out of it by putting a
reporting tool in front.

Cheers,

Coen