Hello,
I search a olap pivot grid control WPF who contains the list of features below. Please can you tell me If these features are present in your control olap and if you plan to implement them in the future ?
1/ Display in value/percent 2 / Save in HTML/XLS. 3 / Save in native format 4 / Possibility to customize the cell color of total value 5 / Formatting data : we would like to control the Font, FontSize, FontStyle, background, foreground etc… For row headers, column headers, totals, detail
6 / Format value : number of decimal, symbol…7/ Print/ Print preview 8/ Dynamic sort 9/ Drill-down 10/ Custom cell with custom operation (sum, average etc.. ) 11/ Aggregation cell like Merge month in quarter or years etc…
12 / SizeToFit -> resize the row and the column automatically to the size of the content 13/ Event : MouseUp/MouseDown/ Selection Changed
I would like to know which data type I can bind the control ? We do not have an OLAP cube, we use a rarely known database called Raima. So we could generate an xml file or maybe create a dataset to provide data to the OLAP cube. We really need your help on that issue with samples to understand how we could provide data to the OLAP grid. Also, using an alternative way for providing data to the olap grid, will we lose some features like dynamic sort, expand/collapse data... ?
Hi
In our new release we already have control called XamPivotGrid which is olap pivot grid control for WPF . You can take a look of Silverlight equivalent of the control on the follow link http://labs.infragistics.com/silverlightdv/2010.2/#/Samples/Welcome/HomePage .
Now for list of features you listed:
1/ You can format the value with any string format.
2/ The control doesn’t have build in support for export/save data, but with little extra work from user side, it is easy do that using the control object model.
3/ same as 2. One addition. We have Excel library which can help you with export to excel you want this.
4/ the XamPivotGrid exposes a variety of styles for customization all parts of the control (Headers, Cells, Totals rows and columns )
5/ with the styles exposes by control you can change all UI properties like Font, FontSize, FontStyle, background, foreground etc…
6/ you can apply any format string to your data
7/ The control doesn’t have build in support for print/print preview
8/ You can sort you data in either direction ascending or descending sort order
9/ you can drill down your hierarchies
10/ we plan to implement such feature. Could explain a little bit more about your expectation here.
11/ I could not understand this feature. Where this cell have to be? Could explain a little bit more.
12/ by default XamPivotGrid resizes the rows and columns automatically to the size of the content. Also the control support column resizing by user interaction with mouse.
13/ the XamPivotGrid has a lot of events that notify for different actions like resizing, sorting, expanding, MouseClick etc..
The datasource of the control can be MS SQL Analysis server, or flat data table. In your case you can generate dataset to provide data to our FlatData engine. The engine will analyses the dataset and will generate appropriate pivot data. This will not impact the sorting, expand/collapse ect..
Is it possible to get some sample code for the Silverlight XamPivotGrid which shows how to change the colour of the cells based on value?
For example, I have a data set coming back where I want the cells to be red if they are below 5, black if they are between 6 - 8 and green if they are over 8.
This can be a style in the XAML, or more preferably a code behind example.
Cheers
Brendan
Hi Brendan,
To implement your case you should define 3 styles for Yellow, Green and Black cells. Below is sample how to do that in your xaml file
<Style x:Key=" YellowStyle " TargetType="igPivot:PivotCellControl">
<Setter Property="Background" Value="Yellow" />
</Style>
<Style x:Key=" BlackStyle " TargetType="igPivot:PivotCellControl">
<Setter Property="Background" Value="Black" />
<Style x:Key=" GreenStyle " TargetType="igPivot:PivotCellControl">
<Setter Property="Background" Value="Green" />
Also you should subscribe for CellControlAttached event
<igPivot:XamPivotGrid x:Name="pivotGrid" CellControlAttached="pivotGrid_CellControlAttached" />
And implementation is as follow
private void pivotGrid_CellControlAttached(object sender, Infragistics.Controls.Grids.PivotCellControlAttachedEventArgs e)
{
if (e.Cell.Data != null)
Style s;
int data = int.Parse(e.Cell.Data.ToString());
if (data <= 5)
s = this.Resources["YellowStyle"] as Style;
}
else if (data >= 6 && data <= 8)
s = this.Resources["BlackStyle"] as Style;
else if (data > 8)
s = this.Resources["GreenStyle"] as Style;
// this check increase performance
if (e.Cell.Style != s)
e.Cell.Style = s;
Regards
Todor
Hi,
Similar to the requirement '10' above for custom aggregators on the Pivot control.
The requirement that we have is to create custom measures. I can see simple aggregators like Sum, Min, Max, Count and Average; but what we want is a custom calculated aggregator.
Some thing like:
Step1: Create a Simple Sum aggregator on Measure1.
Step2: Create a Custom Aggregator that uses the runtime calculated value of the 'Sum aggregator' of Step1 and computes a value using some other column of the data and a custom formula.
Can you please let me know or provide me a sample of such a Custom Aggregator in the Pivot control.
Many Thanks.