Rittman Mead - Delivered Intelligence

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?"

Posted in Uncategorized | 1 Comment »