Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Debajyoti Dey
40
oracle olap
posted

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 ?

Parents
  • 8831
    posted

    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:XmlaQueryProperty PropertyName="DATASOURCEINFO"

                            Value="Provider=Essbase;Data Source=[serverName]"/>

        </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

Reply Children