Hi,
I am using V10.3. For binding PivotGrid i am using FlatDataSource. Here my source is dynamic i.e. based on user selection.
So, for creating the IEnumerable for FlatDataSource's ItemsSource, i am using DynamicTypeBuilder provided by Infragistics.
The problem is that i am not able to see the Dimension in the Row area even though it's being seen in PivotDataSelector. And if i drag the dimension into the Row Area, it gets displayed in the PivotGrid.
In my final app, i don't want to use PivotDataSelector, as will be creating my own selection control.
I have included word doc as attachment.
If from the PivotDataSelector if i drag dimension "[Age Group].[Age in Years]" into row area, then i am able to see the row and it's corresponding value.
Kindly let me know where i am wrong in the code as soon as possible.
Thanks,Sachin
Hi
The reason the dimention is not visible in rows area is the name of properties you create. Please remove the start and end brackets(“ []”) from name of properties and they will be displayed initially into rows area.
If you want to change the name displayed into dimension box you can use next code
CubeMetadata cubeMetadata = new CubeMetadata
{
DataTypeFullName = "ExcelData",
DisplayName = "Sheet1 Data"
};
cubeMetadata.DimensionSettings.Add(new DimensionMetadata { SourcePropertyName = "Date", DisplayName = "Sales Dates", AutoGenerateField = true });
flatDataSource.CubesSettings.Add(cubeMetadata);
Regards
Todor
this doesn't work. just installed the v11.1 ultimate
Hello,
Does it not work if you are using initial items for Rows/Columns or it does not work at all?
11.1 supports multiple hierarchies over singe dimension, so when you use the initial items feature you have to specify the unique name of the hierarchy like: [Date].[Date], whereas in 10.3 is enough to specify just the dimension name - [Date].
Best regards.
PPilev.
I think that the online samples are a good point to start.
ok so this works. can you please point to the documentation on how to initialise cubes, and their hierarchies in 11.1.
thanks.