XMLA Data Provider

[purdav]

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

[Rosen Vladimirov]

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

[purdav]

Hi, 
great! I wait for next internal build!

Many thanks for the support!

Regards, 
Davide

[purdav]

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

[Rosen Vladimirov]

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

[henley]

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>

[Rosen Vladimirov]

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

[henley]

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

[Rosen Vladimirov]

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

[henley]

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.

[Rosen Vladimirov]

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

[henley]

Hi,Reson

When release 2013 Q1?

[Rosen Vladimirov]

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

[henley]

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?

[Rosen Vladimirov]

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

[henley]

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

thanks!

[Rosen Vladimirov]

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

[henley]

         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.

[Rosen Vladimirov]

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

[henley]

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

[Rosen Vladimirov]

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

[henley]

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

[Rosen Vladimirov]

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

[henley]

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.

[Rosen Vladimirov]

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

[henley]

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!

[Milan]

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