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