Skip to Content
author's profile photo Former Member
Former Member

oracle OLAP

Does WEBI support oracle OLAP? I don't see that's an option when we create a new universe? I thought having a oracle OLAP will help normal SQL query performance as well, since Oracle will optimize the query to take advantage of the OLAP.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2011 at 08:31 PM

    Hi,

    Rather than move all your data to another cube like SSAS as has been suggested, or go back to the relational source, why not just use Voyager to connect directly to the Oracle OLAP cube you have already built?

    Simba's MDX Provider for Oracle OLAP allows Voyager to do this.

    This would be much simpler than introducing a new tier of server (SSAS), and allows you to take advantage of the performance of the OLAP engine in the Oracle database.

    http://www.simba.com/oracle

    in particular, look at the document that describes how to set this up:

    http://www.simba.com/docs/Using-Simba-MDX-Provider-for-Oracle-OLAP-with-SAP-BusinessObjects-Voyager.pdf

    Mike

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2011 at 05:02 AM

    Hi,

    you can use voyager to create OLAP Reports.Using voyager you can directly connect to OLAP Cube created in SSAS.

    This link is useful to do your process easily:

    http://www.forumtopics.com/busobj/viewtopic.php?p=534173&sid=19c3e033fe0bc8c79ca17c39d3820b50

    All the Best,

    Madhu...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2011 at 07:52 AM

    In 11.2, and 11.1 as well I think, you can certainly create a cube materialised view which can be a query rewrite target for relational queries, and which can be maintained automatically with changes to relational data. However this would be invisible to the application and you'd still create your universe with an Oracle RDBMS data source as the query rewrite is internal to the database.

    The Oracle docs have got some good examples of this.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.