This content has been marked as final. Show 1 reply
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 220.127.116.11.2 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.
Since you will be using 18.104.22.168 database and OBIEE 22.214.171.124, 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 126.96.36.199), 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