Have Geek Brain

Accessing OLAP data present in Oracle Cubes using C # .NET?

I am new to ORACLE. I would like to access an OLAP cube in Oracle using C #. Could you suggest effective ways to do the same?

0


a source to share


2 answers


So now I have found a library provided by Oracle: Oracle Data Provider for .NET that can help to access OLAP data from Oracle Cubes.



Any hints?

0


a source


Oracle OLAP Option cubes can be accessed through SQL using the OLAP_TABLE function OLAP_TABLE Syntax This requires detailed knowledge of the cube structure as well as the OLAP DML used to manage OLAP cubes. This system is basically the old IRI / Oracle Express system and the language embedded in Oracle Database Server.

The standard SQL used to retrieve data views can be defined to handle OLAP_TABLE functionality on the server.



dbms_aw The PLSQL package provides functions and procedures for executing statements and programs against an OLAP cube. It also provides methods for maintaining and creating cubes

0


a source






More articles:


All Articles