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,
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
1. 10.3
2. five
3. no
Thanks.
Hello,
Is there any chance to send us the visual studio analysis services project and some portion of database you use. If I’m able to deploy it on some of our development machines I may find what’s wrong. If you have concerns to post it into the public space you can contact me at PPilev@infragistics.com
There was a bug that produces similar behavior when the user try to execute queries against database after the first one of the SSAS databases list. That’s why Todor asked you about what’s happen when you run the pivot grid connected to the first database of list of SSAS databases.
Thank you for your patience and feedback.
Best regards.
Plamen.
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