Here is my source code
<UserControl x:Class="mytest.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" xmlns:olap="http://schemas.infragistics.com/olap" xmlns:xmla="clr-namespace:Infragistics.Olap.Xmla;assembly=InfragisticsSL4.Olap.Xmla.v10.2" mc:Ignorable="d" d:DesignHeight="300" d:DesignWidth="400" xmlns:ig="http://schemas.infragistics.com/xaml"> <Grid x:Name="LayoutRoot" Background="White"> <!--<Grid.Resources> <olap:XmlaDataSource x:Key="DataSource" ServerUri="http://sampledata.infragistics.com/olap/msmdpump.dll" Database="Adventure Works DW Standard Edition" Cube="Adventure Works" /> </Grid.Resources>--> <Grid.Resources> <olap:XmlaDataSource x:Key="DataSource" ServerUri="http://localhost/olap/msmdpump.dll" Database="Animal Cube" Cube="Crop Test" /> </Grid.Resources> <ig:XamPivotDataSelector HorizontalAlignment="Left" Margin="249,0,0,0" Name="xamPivotDataSelector1" VerticalAlignment="Top" DataSource="{StaticResource DataSource}" /> <ig:XamPivotGrid HorizontalAlignment="Left" Name="xamPivotGrid1" VerticalAlignment="Top" DataSource="{StaticResource DataSource}" Width="243" /> </Grid></UserControl>
when I use the first Datasource(ServerUri="http://sampledata.infragistics.com/olap/msmdpump.dll"),everything is ok;but when I use my own Datasource(ServerUri="http://localhost/olap/msmdpump.dll) the XamlPivotGird and XamPivotDataSelector do not work. ServerUri="http://localhost/olap/msmdpump.dll is correct,and I used it in WPF version.
I have checked the log files of SQL and the web server, but I can't find any problem.
Where the client access policies should be placed?
Are there any other problems in my code?
Can you give me a simple example about XamlPivotGird?
Could you provide more debug info. Try using fiddler to see if any exceptions are thrown. Also enable the Common Language Runtime Exceptions from the Debug->Exceptions dialog.
Have you looked into the log for your web server? Are you sure the client access policies are in the right place (in the root of the application directory - its a common error)?
How about the SQL log files? Any messages that might point us in the right direction?
The msmdpump.dll do well in WPF version, so I think there is not something wrong with it.
I added clientaccesspolicy.xml to deal with the client access policies.
But the problem can't be resolved either.
Do you have any suggestions?
Hi, guys,
Have a look at this article:
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
Take a special note on the part where you set the permissions for the access and also the client access policies.
All the best,
Atanas Dyulgerov
Hello, I have the same issue.
Do you have a solution for it? I can connnect to my OLAP server through http but the XamlPivotGrid cann't.