3 Replies Latest reply: Nov 10, 2008 8:25 AM by 624047 RSS

    How to Design cube in OBIEE

    user652652
      Hi experts

      Please tell me the steps how we can design cubes in OBIEE with AWM . If there is any other aproach to design cube in OBIEE without using AWM.



      Thanks in advance

      Regards
      Frnds
        • 1. Re: How to Design cube in OBIEE
          Wobiee1-Oracle
          Hi,

          Oracle OLAP cubes cannot be created with OBIEE. You have to use the current tools (AWM or OWB). When you have created the cube you can import the SQL view of it in OBI EE, model it and report on it. See also this blog: http://www.rittmanmead.com/2006/08/10/using-oracle-olap-data-with-oracle-bi-suite-enterprise-edition/

          Regards
          • 2. Re: How to Design cube in OBIEE
            user652652
            Thanks buddy
            • 3. Re: How to Design cube in OBIEE
              624047
              Three things, please.

              First, change your visible moniker from 652652 to your name. That way, we can remember who we're talking to.

              Second, you can learn about building cubes in AWM and using them in OBIEE at this site:

              http://www.oracle.com/technology/products/bi/olap/index.html

              On that page, there are two links on the right hand side. You'll need to do both of them.

              Oracle by Example -AWM 10g
              http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/olap/index.html

              Using Oracle OLAP with OBIEE 10g R3 Lesson
              http://www.oracle.com/technology/obe/10gr2_db_single/bidw/awm/awm_otn.htm

              Third, close the duplicate thread number 824690. If you want to ping a thread, ping it, but please don't create a brand new thread identical to an existing one that is still unanswered and is still active.