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.