Connection to oracle olap cube

2 posts, 0 answers
  1. Ed
    Ed avatar
    1 posts
    Member since:
    Sep 2013

    Posted 03 Sep 2013 Link to this post

    Dear Telerik Support Team!

    I am so beginner with C# and WPF technologic. My managers liked the telerik's options what they could saw with your demos.
    I have to use Oracle 11g database server, therefore I maked a sample OLAP database and sample cubes.
    I have a hostname(, a port(1521), and a SID(orcl), and a username, and password to identify that oracle database connection. I found some sample what you have done (RadPivotGrid-XmlaDataProvider-SimpleApp-SL) it looks like those maked to microsoft databases.
    The cube name is SALES_CUBE and the used dimensions are: CHANNEL, TIME, GEOGRAPHY, PRODUCT.
    Do you have any sample code how could i use any provider to oracle olap cube?

    Thank you in anticipation,
    Best regards,

  2. Rosen Vladimirov
    Rosen Vladimirov avatar
    640 posts

    Posted 03 Sep 2013 Link to this post

    Hello Ed,

    First of all thank you for evaluating Telerik controls. We are always trying to satisfy our customers and give them the best controls on the market.
    RadPivotGrid has XmlaDataProvider that can be used with any cube that supports XMLA access. As far as I know, Oracle OLAP doesn't support XMLA access (through http) out of the box, but there are some other tools that can give you such access. I've searched and I've found this one, but you can choose any of the tools that will give you XMLA access. After that you can use XmlaDataProvider as described in our online help. Just put the correct url and define your descriptions. 

    Hopefully this helps.

    Rosen Vladimirov
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
Back to Top