1 Reply Latest reply on Apr 25, 2013 9:40 PM by nasar.ali-khan at -Oracle

    AWM Olap Tutorials

      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 ( or current version).

      Thank you.
        • 1. Re: AWM Olap Tutorials
          nasar.ali-khan at -Oracle
          Your best source is the OLAP page on Oracle OTN site

          Download GLOBAL Sample schema from:

          Download OLAPTRAIN sample schema from:

          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 demos, including Oracle OLAP cubes and obiee dashboards against those OLAP cubes. The linux image is available here:

          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 database and OBIEE, 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, 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