1 Reply Latest reply: Apr 25, 2013 4:40 PM by Nasar-Oracle RSS

    AWM Olap Tutorials

    1001997
      All,
      Need help with learning how to create cubes using AWM- OLAP option (Oracle 11G) Can you please share with me any relevant documentation , tutorials, examples. The reporting tool for these cubes is OBIEE 11.1.1.6 ( or current version).

      Thank you.
        • 1. Re: AWM Olap Tutorials
          Nasar-Oracle
          Your best source is the OLAP page on Oracle OTN site
          http://www.oracle.com/technetwork/database/options/olap/index.html

          Download GLOBAL Sample schema from:
          http://www.oracle.com/technetwork/database/options/olap/global-11g-readme-082667.html

          Download OLAPTRAIN sample schema from:
          http://www.oracle.com/technetwork/database/enterprise-edition/readme-098894.html


          If you face any issue, then first search this OLAP forum. Lot of questions have already been answered here in the past.


          Additionally, you should download free Oracle OBIEE SampleAppV207 image, which has lot of OBIEE 11.1.1.6.2 demos, including Oracle OLAP cubes and obiee dashboards against those OLAP cubes. The linux image is available here:
          http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

          It works well with atleast 8 GB of RAM.

          If you need more info about how to use this linux vm image, then post here again.


          One clarification:
          Since you will be using 11.2.0.2 database and OBIEE 11.1.1.6, do not look at tutorial "Creating OBIEE Metadata for OLAP 11g Cubes" AND also do not use the plugin "Automatically Generate BI EE Metadata Over OLAP Cubes". Both of these were created for older version of OBIEE.

          For the new version of OBIEE (starting with 11.1.1.5), this is the new way of importing OLAP metadata into RPD: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi11115/olap/olap.htm

          Initially you may face some issue while importing OLAP cubes into RPD. Take a look at this OBIEE - OLAP Troubleshooting guide: http://www.oracle.com/technetwork/database/options/olap/troubleshootingbieeconnections-504856.pdf

          .