I'm facing a problem when I try to create a repository using Oracle BI admin Tool.
In the second step of Create new repository , I have to choose between a lot of connexion types : ODBC3.5 , Oracle OLAP, OCI 10g/11g .... I don't know which of them I need to choose in my case.
In my case, I have a cube that I created using AWM, and I need to make a report that is based on that cube.
I don't really know how to proceed ...
I have Oracle BI is in a Unix server , and I installed Oracle BI admin tool client in my Windows 7.
Any idea which connexion type I should use, do I need to make an ODBC connexion for all of them ?
My comprehension of this is unclear ... any help ?
Thx all !!
Since AWM is an Oracle OLAP analytic workspace tool, you would choose Oracle OLAP connection type/data source to bring in cubes. For more info refer to this post: http://www.rittmanmead.com/2011/05/untitled-1/
Please mark if helpful/correct.
Starting with OBIEE 18.104.22.168, as it understands Oracle-OLAP metadata in Oracle data dictionary, so to query data from OLAP Analytical workspaces you will always use "Oracle OLAP" as the source in BI-Admin-Tool.
When you will create report in OBIEE, it will then generate the query using the OLAP_TABLE sql function.
Note that automatically generated CUBE_TABLE views in OLAP (the ones suffixed with _VIEW) are not used at all (or even needed) when working with OBIEE 22.214.171.124+.