I have set up everything and have the pivot grid displaying in the page and sending XAML commands to the database but it cannot find my Cube.
I followed the steps in this example:
http://community.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
(this is the only documentation I have. I have found nothing else to help by the way)
My project is in VB and here's the code...
Partial Public Class MainPage
Inherits UserControl
Public Sub New()
InitializeComponent()
'this.Loaded += (sender, e) => { pivotGrid.ViewModel.LoadCubesAsync(); };
End Sub
Private Sub MainPage_Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles Me.Loaded
pivotGrid.ViewModel.LoadCubesAsync()
End Class
Whenever the "pivotGrid.ViewModel.LoadCubesAsync()" is called the Sql Profiler shows this XAML command on arriving at the database:
<RestrictionList xmlns="urn:schemas-microsoft-com:xml-analysis" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://schemas.xmlsoap.org/soap/envelope/"><CATALOG_NAME xmlns="">TestCube</CATALOG_NAME></RestrictionList>
But it does not find the cube I made called TestCube. I am completely stuck at this point. Can anyone please help?
Thanks,
Len
Hi Len,
From the Request you are setting the Catalog name to TestCube. Is the name of the catalog the same like the name of the Cube?
Could you try with executing these request with SQL Management studio and see what it will return?
Thanks,George
Hi George. Sorry, I didn't describe that very well. The Catalog is named "TestCube," the cube itself is named "Adventure Works"
It's really strange because the XAML that is being sent isn't valid if I past it directly into a XAML query in Sql Management studio, and it also isn't logical when you just look at it. It looks like it is just the 'filter' portion of what should be a bigger chunk of text.
Here's the error I get if I run it in Sql Management Studio:
The RestrictionList element at line 7, column 33 (namespace urn:schemas-microsoft-com:xml-analysis) cannot appear under Envelope/Body/Execute/Command.
The XAML is sent by the pivotGrid.ViewModel.LoadCubesAsync() method. I confirmed this by pasting that same method-call in there 5 times in a row and sure enough I saw 5 entries in Sql Profiler.
Can you try to connect to this cube with some other application using the same url of the service that you are using in Pivot Grid? For Example I often test it with Excel. It seems like permissions problem.
Hi can you please share the sample code for working on XamPivotGrid
How can I download XamPivotGrid control? I downloaded DataVisualization 2010 Vol.2Complete Bundle. But in that XamPivot Grid Contrl is not there.
Hi,
As a start point you can take a look at the samples: http://samples.infragistics.com/
You can browse them online or download and install them locally.