Oracle 10g OLAP option

[DeanFarrow]

Hi all

Do we support creating a universe against an Oracle 10g OLAP database and how do we do this to report against OLAP data?

I notice that there isn't an OLAP universe option for this, so I presume that if we can then we do this via OLAP SQL expressions?

Thank you for your help and kind regards,

Deam

[Former Member · Accepted solution]

Hi,

You are right, we are supporting Oracle OLAP 10g using SQL.

In fact we provide an option in Universe Designer where you can automatically create an Oracle view based on an AW (Analytical Workspace) and then generate the universe:<ul><li>Select "Metadata exchange" menu option from "File" menu

<li>Then select "Oracle OLAP 9i/10G/11g" option

</ul>You can therefore customize the universe by adding objects, filters, measures, etc.

You can also add other tables in the scema in order to provide drill-though capabilities.

Regards,

Didier