Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
50
Can't connect to OLAP datasource
posted

I am developing my first Silverlight DV application.  I thought I would start simply with a grid, a splitter, and a dataselector.  I already had a datacube, so I followed the instructions on MS Technet to set up Http access to it.  Here is the code:

<UserControl x:Class="TestPivotGrid.MainPage"
    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"
    d:DesignHeight="480" 
    d:DesignWidth="640" 
    xmlns:olap="http://schemas.infragistics.com/olap" 
    xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk" 
    xmlns:xmla="clr-namespace:Infragistics.Olap.Xmla;assembly=InfragisticsSL4.Olap.Xmla.v11.1"
    xmlns:igPivot="clr-namespace:Infragistics.Controls.Grids;assembly=InfragisticsSL4.Controls.Grids.XamPivotGrid.v11.1" >
 
 
    <Grid x:Name="LayoutRoot" Background="White" DataContext="{Binding}">
        <Grid.ColumnDefinitions>
            <ColumnDefinition MinWidth="310" />
            <ColumnDefinition Width="Auto" />
            <ColumnDefinition MinWidth="300" Width="300" />
        </Grid.ColumnDefinitions>
        <Grid.Resources>
            <olap:XmlaDataSource 
                  x:Key="DataSource" 
                  ServerUri="http://imsds1/olap/msmdpump.dll"  >
                <olap:XmlaDataSource.Credentials>
                    <olap:XmlaNetworkCredential Password="xxxx" UserName="JSmith">
                    </olap:XmlaNetworkCredential>
                </olap:XmlaDataSource.Credentials>
            </olap:XmlaDataSource>
        </Grid.Resources>
        <igPivot:XamPivotGrid DataSource="{StaticResource DataSource}" DataContext="{Binding}" Grid.Column="0" HorizontalAlignment="Stretch" Margin="0" Name="XamPivotGrid1" VerticalAlignment="Stretch" />
        <sdk:GridSplitter Grid.Column="1" Grid.ColumnSpan="1" HorizontalAlignment="Center" Margin="0" Name="GridSplitter1" VerticalAlignment="Stretch" Width="4" HorizontalContentAlignment="Stretch" Background="DarkGray" />
        <igPivot:XamPivotDataSelector DataSource="{StaticResource DataSource}" DataContext="{Binding}" Grid.Column="2" HorizontalAlignment="Stretch" Margin="0" Name="XamPivotDataSelector1" VerticalAlignment="Stretch" />
    </Grid>
</UserControl>

In the ServerUri above, if I change "imsds1" to Sampledata.Infragistics.com", it works fine.  I can see the AdventureWorks DB in the dataselector.  If I change it back to "imsds1" I get nothing.  This would suggest that something is wrong with my Http setup.  However, it passes both tests given in the Technet article for testing your connection.  If I enter http://imsds1/olap/msmdpump.dll in IE, I get the following correct response:

- <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

- <soap:Body>
- <soap:Fault xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<faultcode>XMLAnalysisError.0xc10e0002</faultcode>
<faultstring>Parser: The syntax for 'GET' is incorrect.</faultstring>
- <detail>
<Error ErrorCode="3238920194" Description="Parser: The syntax for 'GET' is incorrect." Source="Unknown" HelpFile="" />
</detail>
</soap:Fault>
</soap:Body>
</soap:Envelope>

In SSMS, if I select Connect to Analysis Services and enter http://imsds1/olap/msmdpump.dll, it connects just fine and shows the databases and cubes.

I thought perhaps it was an authentication problem, so I changed the access from Windows Authentication to Anonymous.  I also checked the permissions on the directories to make sure they are accessible to Everyone.

I saw some posts about problems with the grid in 10.3, so I upgraded to 11.1.  No change.

At this point I'm stumped.  Any suggestions?