Hi we hav a data base with oracle database OLAP not essbase
now we are looking for a online web componant like your pivot grid which can directly access the olap cube and can show tabular data
is it possible ?
Correct me if I'm wrong but as far as I can see Oracle OLAP does not provide direct access to its services through XMLA. That's why I think you have to use something like Oracle Essbase or Simba XMLA Provider for Oracle OLAP 2.0.
Regards,Plamen.
As i said earlier we have Oracle database with OLAP option not essbase which is a stand alone costly product from oracle
You can find difference here - http://blogs.simba.com/simba_technologies_ceo_co/2008/10/oracle-database-olap-option-vs-oracle-hyperion-essbase.html
We currently looking for http://www.oracle.com/in/products/database/options/olap/overview/index.html (oracle OLAP whcih came with Oracle enterprise edition)
and a web component to access it.
kindly revise your answer
Hello,
I guess in first place you need Oracle Essbase running which should provide an access to OLAP services through XMLA. Then you can try our XamPivotGrid with XmlaOracleDataSource to your services.
Here it is how you can configure XmlaOracleDataSource:
<olap:XmlaOracleConnectionSettings x:Key="oracleSettings" Encoding="UTF-8" ServerUri="http://[serverName]/aps/XMLA">
<olap:XmlaOracleConnectionSettings.DiscoverProperties>
<olap:XmlaQueryProperty PropertyName="DATASOURCEINFO"
Value="Provider=Essbase;Data Source=[serverName]"/>
</olap:XmlaOracleConnectionSettings.DiscoverProperties>
<olap:XmlaOracleConnectionSettings.ExecuteProperties>
</olap:XmlaOracleConnectionSettings.ExecuteProperties>
</olap:XmlaOracleConnectionSettings>
<olap:XmlaOracleDataSource x:Key="oracleDataSource"
Database="Demo"
Cube="Demo.Basic"
ConnectionSettings="{StaticResource oracleSettings}">
<olap:XmlaOracleDataSource.Credentials>
<olap:XmlaNetworkCredential UserName="[UserName]" Password="[Password]">
</olap:XmlaNetworkCredential>
</olap:XmlaOracleDataSource.Credentials>
</olap:XmlaOracleDataSource>
Regards,Plamen