Hi experts:
I am using the trial version to evaluate the xamlPivotGrid, I used the sample to connect my owned cube (SSAS 2005), I can see the Databases, Cubes and Dimensions. But when I drag the measure into the data area, the value is not shown. It can work if I connected it to http://sampledata.infragistics.com/olap/msmdpump.dll.
I also used Excel to connect my owned cube, it's not problem. Could you please give me some hints to fix it? Thanks.
Hi damh12345,
do you connect to more than one database? If you connect to more than one database do you receive this issue when you change the database to which the pivot grid is connected?
Dimitrina
Hi Dimitrina:
The code is as below:
<Grid.Resources> <olap:XmlaDataSource x:Key="DataSource2" ServerUri="http://tao-pdmnet-1/olap/msmdpump.dll"> </olap:XmlaDataSource> </Grid.Resources> <ig:XamPivotGrid x:Name="pivotGrid" DataSource="{StaticResource DataSource2}" Grid.Column="0"/> <ig:Expander Grid.Column="1"> <ScrollViewer> <ig:XamPivotDataSelector x:Name="dataSelector" DataSource="{StaticResource DataSource2}" MaxWidth="250" /> </ScrollViewer> </ig:Expander>
When I change to different database, the cubes are also refreshed. But the value still could not show on the data area after dropping.
Hi,
I setup the initial database, cube and measure as below
Database="igpivot1" Cube="PDM" Filters="" Columns="" Rows="" Measures="Iedepart Count"
But all are not shown on the pivot grid. Thanks for help.
I just tried similar case, set everything in xaml but I cannot reproduce your case. Please can you attach your sample application to test it against our test server.
Greetings,
It can work normally against your test cube (http://sampledata.infragistics.com/olap/msmdpump.dll). So I think the problem is in the cube I created. What configuration should I check? I can use SSMS and Excel to connec it (http://tao-pdmnet-1/olap/msmdpump.dll) without problem. Thanks for your patience.
BTW, can this version support SSAS 2008 R2?
I attched the screen cut for your reference, Excel can show the value but xamPivotGrid cannot. Thanks.
Hi
I would ask you which version of control do you use (10.2 or 10.3)?
Also how many databases do you have on your server?
Can you see data when you connect to first database from dropdown (select database dropdown in XamDataSelector control).
Regards
Todor
Thanks.
It works now, thanks a lot.
I have created support case (CAS-58831-SYJ78F) for you and will send you in private the link of the latest service release.
Sincerely,DimiDeveloper Support EngineerInfragistics, Inc.
How to get the latest version? I downloaded the trial version again but it still cannot work.
Do you use the latest version of pivot grid. We had Service Release on 16 Dec 2010. The bug is fixed in this SR