XMLA Data Provider

27 posts, 0 answers
  1. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 16 Nov 2012 Link to this post

    Hi, 
    I've tried Xmla Data Provider. It works great but If I have several databases on same SSAS server, it takes always the first one. 
    I have a RadPivotFieldList and a RadPivotGrid: RadPivotFieldList updates fields list correctly and accordingly to the specified database/cube but RadPivotGrid connects to wrong database (the first in analysis services).

    Is there a way to specify the correct catalog with Xmla data provider? 
    My configuration is: 

    <telerikDataProviderXmla:XmlaDataProvider x:Key="dataProvider">
                <telerikDataProviderXmla:XmlaDataProvider.ConnectionSettings>
                    <telerikDataProviderXmla:XmlaConnectionSettings 
                        Cube="MY_CUBE"
                        Database="MY_DATABASE_01"
                        ServerAddress="http://MY_WEBSERVER:8888/msmdpump.dll" />
                </telerikDataProviderXmla:XmlaDataProvider.ConnectionSettings>
            </telerikDataProviderXmla:XmlaDataProvider>

    In this case, if I have also MY_DATABASE_00 it connects to MY_DATABASE_00.

    Many thanks in advance!
    Regards!
    Davide

  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 19 Nov 2012 Link to this post

    Hi Davide,

    Your definition is fine, there was a problem with our DataProvider, but we have already found it and fixed it. The resolution will be included in this week's internal build which should be available for download later today or tomorrow. Please test it from your side and inform us if you have any other concerns for this case.

    Thank you for evaluating RadPivotGrid. Please inform us for any kind of problems you face while using it.

    All the best,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  3. UI for WPF is Visual Studio 2017 Ready
  4. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 19 Nov 2012 Link to this post

    Hi, 
    great! I wait for next internal build!

    Many thanks for the support!

    Regards, 
    Davide
  5. purdav
    purdav avatar
    26 posts
    Member since:
    Feb 2007

    Posted 20 Nov 2012 Link to this post

    Hi, 
    now is done, thanks!!

    A little question about internal build: what means "Label Filter: Added new option to specify if filter is case sensitive"?
    I know I can't use filters, because they are still in beta (or hidden)... If I drag a field into "report filter" section the field disappear at the moment, is correct in these builds? Or I have problems with filters?

    Many thanks, 
    Davide
  6. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 20 Nov 2012 Link to this post

    Hello Davide,

    While using XmlaDataProvider you are not able to use Filters. The mentioned change is for LocalDataSourceProvider but it is not dedicated to Report Filter. There are other filters which you may apply on your RowGroupDescriptions or ColumnGroupDescriptions. You can do it very easy with RadPivotFieldList - when you click on a property in one of these two group descriptions, you will see a drop-down content where you can specify LabelFilter, ValueFilter or Top10Filter. Unfortunately with the current version this is available only for LocalDataSourceProvider.

    Don't hesitate to contact us in case of any problems.

    Regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  7. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 11 Dec 2012 Link to this post

    hi,Rosen Vladimirovwhich version was fix this question?
    I downed it at this month, I can't Connection it now.
    My configuration is: 

    <pivot:XmlaDataProvider.ConnectionSettings>
                    <pivot:XmlaConnectionSettings 
                        Cube="DW Demo" 
                        Database="DW_Demo" 
                        ServerAddress="http://192.168.1.100:8001/OLAP/msmdpump.dll"/>
     </pivot:XmlaDataProvider.ConnectionSettings>


  8. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 11 Dec 2012 Link to this post

    Hello Henley,

    I suggest you to download our latest official release - 2012 Q3 SP1 and test your application with it. If you are already using this version of RadControls you can check if you have access to your cube. You can trace http requests and responses with Fiddler.  I'm sending you a short video how to use Fiddler for this purpose. Maybe your user doesn't have access to the Cube or something else is preventing you to connect.

    Please check the attachment and the responses from the OLAP cube - they will give us more information and we will be able to provide you better help.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  9. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 11 Dec 2012 Link to this post

    hi,
    Rosen

    the first,thanks for your help,

    I use fiddler debug it,find the reason was "cross domain".
    404 http localhost:8010 /clientaccesspolicy.xml
    404 http localhost:8010 /crossdomain.xml
  10. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 11 Dec 2012 Link to this post

    Hi Henley,

    I hope you have fixed your problem. If not you can check our online help how to configure http access to your OLAP Cube.

    Thanks for choosing RadPivotGrid. Don't hesitate to send us your suggestions or any concerns you may have.

    Greetings,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  11. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 12 Dec 2012 Link to this post

    Hi,Rosen
    Thanks for you help!

    I Had 2 problems:
    1)Pivot grid export to excel file.
    2)How to save grid 's search condition.how to get this report's Report Filter ,column Lables,Row Labels and Values.

  12. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 12 Dec 2012 Link to this post

    Hi Henley,

    Export to excel is in our to-do list and most probably it will be ready for our official release 2013 Q1.
    For your second problem - could you give us more details what do you want to save, where do you want to save it and what would you do with this save. This information is needed to provide you better help for this issue.

    Looking forward to hearing from you.

    Greetings,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  13. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 13 Dec 2012 Link to this post

    Hi,Reson

    When release 2013 Q1?
  14. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 14 Dec 2012 Link to this post

    Hi Henley,

    The release will be in the end of February or beginning of March.

    Do not hesitate to contact us if you have any suggestions or concerns.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  15. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 17 Dec 2012 Link to this post

    Hi,Reson
    1.I using http access  OLAP Cube,How to Controls permissions?
    e.g. different user access different measures? 

    2.Silverlight not support AdomdDataProvider ?

    3.How to using XmlaConnectionSettings.Credentials?
    this username,password,domain are Windows OS user?,How to use?

  16. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 18 Dec 2012 Link to this post

    Hello Henley,

    1) This should be done in your Cube. You can check this thread how to do it.
    2) Yes, AdomdDataProvider is used only in WPF. In Silverlight you should use XmlaDataProvider.
    3) By default if you don't set any authentication your application will use the default Windows credentials. You can check our online help how to set credentials for XmlaDataProvider and AdomdDataProvider. Note that for XmlaDataProvided the syntax is:
    <pivot:XmlaDataProvider x:Key="XMLADataProvider"  >
        <pivot:XmlaDataProvider.ConnectionSettings>
            <pivot:XmlaConnectionSettings
                    Cube="Adventure Works"
                    Database="Adventure Works DW 2008R2"
                    ServerAddress="http://demoOLAP.com/olap/msmdpump.dll">
                <pivot:XmlaConnectionSettings.Credentials>
                    <pivot:XmlaNetworkCredential UserName="TestUser" Password="12345678"/>
                </pivot:XmlaConnectionSettings.Credentials>
            </pivot:XmlaConnectionSettings>
        </pivot:XmlaDataProvider.ConnectionSettings>
    </pivot:XmlaDataProvider>

    While for AdomdDataProvider you should define the credentials in the connection string by using User Id and Password:
    "Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;"

    Hopefully this helps.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  17. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 18 Dec 2012 Link to this post

    The third question,whether support Silverlight?
    XmlaDataProvider.ConnectionSettings.Credentials,How to use?

    thanks!
  18. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 18 Dec 2012 Link to this post

    Hello Henley,

    I'm sending you a very simple project illustrating how you can set the credentials in your XAML and in code behind. Please check it and inform me if you still have any problems.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  19. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 18 Dec 2012 Link to this post

             XmlaDataProvider dataProvider = new XmlaDataProvider();
                dataProvider.BeginInit();
                dataProvider.ConnectionSettings = new XmlaConnectionSettings()
                {
                    Credentials = new XmlaNetworkCredential()
                    {
                        UserName = "administrator",
                        Domain = ".",
                        Password = "henley"
                    },

                    Cube = "DW Demo",
                    Database = "DW_Demo",
                    ServerAddress = "http://localhost:8010/OLAP/msmdpump.dll"
                };
                //If you want to set it in code behind uncomment these two lines
                this.radPivotFieldList.DataProvider = dataProvider;
                this.radPivotGrid.DataProvider = dataProvider;
                dataProvider.EndInit();

    Add "Credentials" property  do not access,this "Domain" means??
    and I have not domain. OLAP Server is localhost.
  20. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 18 Dec 2012 Link to this post

    Hello Henley,

    You can check these articles for explanation what is Domain: link1, link2. In your case you are using localhost so you should be able to access the data without setting Domain, just remove it from your declaration.
    Also I strongly recommend you to check these two articles in our online help
    - Set HTTP access to SQL Server
    - Debugging XMLA problems

    The first one describes the steps you have to do to have access to your OLAP Cube over HTTP protocol (XmlaDataProvider uses this protocol). The second one will help you to debug your application with Fiddler.

    Hopefully this clears it out.

    Greetings,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  21. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 18 Dec 2012 Link to this post

      dataProvider.ConnectionSettings = new XmlaConnectionSettings()
                {
                    Credentials = new XmlaNetworkCredential()
                    {
                        UserName = "administrator",
                        // Domain = ".",
                        Password = "henley"
                    },

                    Cube = "DW Demo",
                    Database = "DW_Demo",
                    ServerAddress = "http://localhost:8010/OLAP/msmdpump.dll"
                };

    I setting like this, using Fiddler to debug,I do not find to request "http://localhost:8010/OLAP/msmdpump.dll" ,that is why???
  22. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 18 Dec 2012 Link to this post

    Hi Henley,

    I would suggest there is a problem with your clientaccesspolicy.xml file. Most probably it looks like this:
    <?xml version="1.0" encoding="utf-8"?>
    <access-policy>
      <cross-domain-access>
        <policy>
          <allow-from http-request-headers="SOAPAction">
            <domain uri="*"/>
          </allow-from>
          <grant-to>
            <resource path="/" include-subpaths="true"/>
          </grant-to>
        </policy>
      </cross-domain-access>
    </access-policy>

    As described in our online help if you intend to use Authentication you should set the http-request-headers to: http-request-headers="SOAPAction,Authorization" in the file.

    I would suggest you to check very carefully if you have performed all steps described in this article. The clientaccesspolicy.xml setup is at the end of it, but please be sure you have completed all steps.

    Kind regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  23. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 18 Dec 2012 Link to this post

    I am sure has completed all steps.
    dataProvider.ConnectionSettings = new XmlaConnectionSettings()
                {
                    Cube = "DW Demo",
                    Database = "DW_Demo",
                    ServerAddress = "http://localhost:8010/OLAP/msmdpump.dll"
                };

    I setting like this,that is OK! No problem!



    dataProvider.ConnectionSettings = new XmlaConnectionSettings()
                {
                    Credentials = new XmlaNetworkCredential()
                    {
                        UserName = "administrator",
                        Password = "henley"
                    },
                    Cube = "DW Demo",
                    Database = "DW_Demo",
                    ServerAddress = "http://localhost:8010/OLAP/msmdpump.dll"
                };
    But I setting like this,Do not have any display,
    and using Fiddler to debug,I do not find to request "http://localhost:8010/OLAP/msmdpump.dll" , why???

  24. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 19 Dec 2012 Link to this post

    Hello Henley,

    It looks like there is a problem with the permissions of your user or the configuration of IIS. Can you check if your clientaccesspolicy.xml has the following syntax:
    <?xml version="1.0" encoding="utf-8"?>
    <access-policy>
      <cross-domain-access>
        <policy>
          <allow-from http-request-headers="*">
            <domain uri="*"/>
          </allow-from>
          <grant-to>
            <resource path="/" include-subpaths="true"/>
          </grant-to>
        </policy>
      </cross-domain-access>
    </access-policy>

    Also you can try to break when there is an exception - in Visual Studio go to Debug -> Exceptions and mark all checkboxes. This may give you more information what is the problem.
    The reason why you cannot see anything with Fiddler is of the Silverlight itself. Its behavior is to test to connection itself (not over http protocol) and in your case the user doesn't have permissions or some other error happens, so other requests are not sent.

    Hopefully this helps.

    Regards,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  25. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 20 Dec 2012 Link to this post

    Hi,Reson
    1.I prepare a server machine with sqlserver server and iis installed and i'm sure that the iis windows authorization is enabled. So when i use xmlaprovider without credential, a standard window will be prompted to ask me to input user and password. After i input it, a pivot table with right data will be displayed. But if i set the credential property of xmlaprovider object with user and password (both of them is right), nothing is displayed. I also check Fiddler log meantime, and no http request can be finded.
    So please help.

    2.Will the 2013q1 version support ADOMD in SL? wpf has already support it now.

    3.Is there any plan to support MDX query in RadPivotGrid.

    Thanks.

    see attach.
  26. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 21 Dec 2012 Link to this post

    Hello Henley,

    You are correct, finally we have reproduced the problem and the fix will be included in the next internal build. Meanwhile you can add this line in your application (before initializing the DataProvider):
    WebRequest.RegisterPrefix("http://", System.Net.Browser.WebRequestCreator.ClientHttp);
    This should do the job for you. We are sorry for the caused inconvenience. I have updated your Telerik points as a small sign of our appreciation.
    Please note that there is no way to use ADOMD in Silverlight as this library is not compiled for Silverlight - it is .NET library.
    Can you give us more information what do you want to do with the MDX queries - do you intend to create calculated items or you have something else in mind? We will consider all your needs and suggestions.

    Looking forward to hearing from you.

    Greetings,
    Rosen Vladimirov
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

  27. henley
    henley avatar
    14 posts
    Member since:
    Nov 2012

    Posted 23 Dec 2012 Link to this post

    Hello Reson,

    1.How to validate the result of windows authorization,how to know I inputed username and password is correct or wrong?

    2.About support ADOMD and MDX query,you can reference Ranet-uilibrary-olap https://code.google.com/p/ranet-uilibrary-olap/

    Many thanks for the support!

  28. Milan
    Admin
    Milan avatar
    1989 posts

    Posted 27 Dec 2012 Link to this post

    Hello,

    I am afraid that ensuring that credentials are okay is not a responsibility of our RadPivotGrid component. If authentication fails you will get an exception but using those exceptions for  authentication management is not recommended. Fiddler should be able to help you with identifying connection problems.

    Thanks for providing us with more information about those MDX capabilities. We have no immediate plans of having such support for MDX queries. Currently we are focusing on features like localization, exporting and selection.

    Let me know if we can be of any further help,

    Kind regards,
    Milan
    the Telerik team

    Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Back to Top
UI for WPF is Visual Studio 2017 Ready