Hi,
I am trying to connect to an olap cube where the IIS olap website is setup with basic authentication.
The xaml is as follows:
-------------------------------------------------------------------
<navigation:Page x:Class="CFSapp.Views.PivotGrid"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
mc:Ignorable="d"
xmlns:navigation="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Navigation"
d:DesignWidth="640" d:DesignHeight="480"
Title="PivotGrid Page" xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk"
xmlns:ig="http://schemas.infragistics.com/xaml">
<Grid x:Name="LayoutRoot">
<ig:XamPivotDataSelector HorizontalAlignment="Right" Margin="0,25,0,0" Name="dataSelector" VerticalAlignment="Top" />
</Grid>
</navigation:Page>
-----------------------------------------------------------------------------
and the code behind is as follows:
XmlaDataSource xmlaDataSource1 = new XmlaDataSource();
xmlaDataSource1.ServerUri = new Uri(https://remotewebsite/olap/msmdpump.dll);
xmlaDataSource1.Credentials = new XmlaNetworkCredential("username", "password","domain");
this.dataSelector.DataSource = xmlaDataSource1;
________________________________________
When i open the page I get a login box to connect to the "remotewebsite", so I enter the credentials again, but the data selector does not get connected.
Using the same address and credentials, I can connect to "remotewebsite" with Excel pivot. I can also connect to infragistic sampledata by changing the URI and removing the xmlaDataSource1.Credentials = new XmlaNetworkCredential("username", "password","domain"); line from the code behind.
Any clue how to connect to my olap database which is setup with basic authentication?
PS: I am using the assemblies from InfragisticsSL4.v10.3
Cheers,
Oyvind
Hello Yohan,
I can suggest you see these blogs:
https://ko.infragistics.com/community/blogs/b/atanas_dyulgerov/posts/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application
and
https://ko.infragistics.com/community/blogs/b/atanas_dyulgerov/posts/xampivotgrid-and-local-offline-ssas-cubes
where it is described step by step how to use SSAS.
Hi ,
Could you please tell me where to find the clientaccesspolicy.xml file. Sorry i'm new to silverlight :( .
I have followed all the instructions above but still unable to retrieve data from a SSAS cube.
Could you please help me out.
Regards,
Yohan
Hello,
I have a slightly different problem, PivotGrid can connect to the OLAP cube with Basic Authentication using HTTP but not HTTPS.
Excel can connect via HTTPS. It should work with HTTPS right?
Thanks,
Fredy
[UPDATE] We were having issues when trying to access the cube through HTTPS MSMDPump.dll but we found the solution. The application calling the HTTPS msmdpump shoudl also be HTTPS.
Perfect. It works. I had mine set to:
<allow-from http-request-headers="SOAPAction">
Thanks for the help!
Ok, now I think I’ve located the problem. I think you have to change your clientaccesspolicy.xml to accepts any headers because the credentials are send as authenticate header.
<allow-from http-request-headers="*">
<domain uri="*"/>
</allow-from>
Try it and let me know if it works.
Regards.
Plamen.