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,
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.
I am trying the trial version of Infragistics pivot grid and facing the same problem. Able to access the data from http://sampledata.infragistics.com/olap/msmdpump.dll
But from the Analysis database I have created, the pivot grid does not display any result. I am able to view the measure and dimensions in the data selector.
trying the pull the data through the website http://localhost/olap/msmdpump.dll configured in Windows XP. It does not work.
Any solutions?
Best Regards,
Singaravelan
Do you use the latest version of pivot grid. We had Service Release on 16 Dec 2010. The bug is fixed in this SR
Regards
Todor