Good Morning,
I´m new at the forum posts also XamPivotGrid and XamPivotDataSelector are new to me.
I'm trying to build an application that uses Silverlight and XAML, and I have a problem with these two components. I'm using Visual Studio 2010 and SSAS 2005.
I followed the directions that are on the site
http://blogs.infragistics.com/blogs/atanas_dyulgerov/archive/2010/01/27/how-to-set-up-xmla-http-access-for-sql-server-analysis-service-2008-and-access-the-adventure-works-2008-from-an-infragistics-pivotgrid-application.aspx
The problem is when I run the program I can not get data in my components to choose from (Database, Dimensions, Measures ...)
The code XAML I use is below:
<UserControl x:Class="Teste.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="398" d:DesignWidth="888" xmlns:olap="http://schemas.infragistics.com/olap" xmlns:ig="http://schemas.infragistics.com/xaml"> <Grid x:Name="LayoutRoot" > <Grid.Resources> <olap:XmlaDataSource x:Key="xmlaDataSource" ServerUri="http://localhost/olap/msmdpump.dll"> </olap:XmlaDataSource> </Grid.Resources> <ig:XamPivotGrid HorizontalAlignment="Left" Margin="271,49,0,0" Name="xamPivotGrid1" VerticalAlignment="Top" Height="349" Width="617" DataSource="{StaticResource xmlaDataSource}"/> <ig:XamPivotDataSelector HorizontalAlignment="Left" Margin="0,49,0,0" Name="xamPivotDataSelector1" VerticalAlignment="Top" Width="265" DataSource="{Binding xmlaDataSource, ElementName=xamPivotGrid1}"/> </Grid></UserControl>
Below is my C# code:
using System;using System.Collections.Generic;using System.Linq;using System.Net;using System.Windows;using System.Windows.Controls;using System.Windows.Documents;using System.Windows.Input;using System.Windows.Media;using System.Windows.Media.Animation;using System.Windows.Shapes;namespace Teste{ public partial class MainPage : UserControl { public MainPage() { InitializeComponent(); } }}
Can anyone help me?
sseixas
Hello,
The binding you have set to DataSource property for the data selector seems wrong. Just set it in the same way as you did for the pivot grid:
DataSource="{StaticResource xmlaDataSource}"
or fix the existing one:
DataSource="{Binding Path=DataSource, ElementName=xamPivotGrid1}"
Regards.Plamen.
The aplication that I talk is below, sorry
As you se, when I chose Database, The application did not show anything
thanks,
Hello Plamen,
The problem was in firewall and having different versions of SQL on the same machine
Best regards
Plamen,I see the IIS authentication for olap aplication and is Anonymous Authentication.I replace localhost with the name of my machine to bypass the clientaccesspolicy in XAML code.
Could you check what Fiddler says about the traffic from/to msmdpump.dll? Since you have SSAS on your local machine you'll need to set up Fiddler to catch the sessions addressed to localhost too. You can find that information at this post.
Also in your clientaccesspolicy I see
<grant-to><resource path="/aps/XMLA" include-subpaths="true"/></grant-to>
make sure that is the correct path.
Try to run the application as replace localhost with your machine's name, that should skip the policy check.
Also what kind of authentication you have set for your olap application on IIS? Try to have it working in the most simple scenario first, having just Anonymous Authentication enabled.
I look at the post you sent me.
My "clientaccesspolicy" is just you said:
<?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="/aps/XMLA" include-subpaths="true"/> </grant-to> </policy> </cross-domain-access></access-policy>
I have also the role in database, having full control, membership IUSR and the user of my machine.
The XAML code have the credentials of connection
<Grid x:Name="LayoutRoot" > <Grid.Resources> <olap:XmlaDataSource x:Key="xmlaDataSource" ServerUri="http://localhost/olap/msmdpump.dll"> <olap:XmlaDataSource.Credentials> <olap:XmlaNetworkCredential Password="XXX" UserName="XXX"> </olap:XmlaNetworkCredential> </olap:XmlaDataSource.Credentials> </olap:XmlaDataSource> </Grid.Resources>
<ig:XamPivotGrid HorizontalAlignment="Left" Margin="271,49,0,0" Name="xamPivotGrid1" VerticalAlignment="Top" Height="349" Width="617" DataSource="{StaticResource xmlaDataSource}"/> <ig:XamPivotDataSelector HorizontalAlignment="Left" Margin="0,49,0,0" Name="xamPivotDataSelector1" VerticalAlignment="Top" Width="265" DataSource="{Binding Path=DataSource, ElementName=xamPivotGrid1}"/>
The problem continues. Any ideas?
Thanks
Look at this post.