Oracle Reporting Tools Forum Up and Running

The Blog Forum is up and running now over at http://www.rittman.net/forum.

I set this up for two reasons. First is that I get a number of technical questions through directly, and I often don't have the time (or the answer to hand) to be able to help out straight away. If you post to the forum instead I'll try and answer there, and if I don't perhaps someone else will. The second reason (and this is what hopefully makes it unique) is that I want to promote discussion of all BI & reporting tools running on Oracle, not just Discoverer, Reports and Portal. So, if you're running Business Objects against an Oracle database, Cognos or Crystal Reports, feel free to ask a question and contribute to the debate. I'd also be interested in hearing from any users of Microsoft Analysis Services who run MS's OLAP server but source their data from an Oracle database - how good a solution is this, and were you perhaps an Oracle Express Server user before?

As a taster, here's three questions that were posted today:

From glasky :

"Hello!

Has anyone come up with a way to grant users access to the EUL without giving them insert,update, and delete on all the underlying EUL tables? Any clever workarounds or risk mitigation strategies?

Any info would be greatly appreciated!"

From Pete_S :

"Well as Mark has set up polling...

If you use Materialized Views for Data Warehouse summaries and have type 1 slowly changing dimensions I would be intersted in your opinion ... Do You Use Fast Refresh on type 1 SCD aggregate M-views?"

From me :

"A question for everyone.

What query tool do you use on your BI&W application? Do you use Discoverer, or have you gone for a third-party tool such as Business Objects, Cognos or Brio?

If you've gone for a non-Oracle solution, what made you go elsewhere, what are the benefits over Discoverer?

Now that Discoverer 10.1.2 is out, has this changed anyones' decisions?"