Named Set in EJ 1 Angular PivotGrid
28 Sep 2017 / 1 minute to read
Named sets is a multidimensional expression (MDX) that returns a set of dimension members, which can be created by combining cube data, arithmetic operators, numbers and functions.
You can bind the Named Sets in PivotGrid by setting it’s unique name in the fieldName
property either in row or column axis and isNamedSets
boolean property to “true”.
<ej-pivotgrid [enableToolTip]="false" dataSource.data="http://bi.syncfusion.com/olap/msmdpump.dll" dataSource.catalog="Adventure Works DW 2008 SE" dataSource.cube="Adventure Works" [dataSource.rows]="rows" [dataSource.columns]="columns" [dataSource.values]="values" [dataSource.filters]="filters">
</ej-pivotgrid>
//..
export class PivotGridComponent {
public rows; columns; values; filters;
constructor() {
this.data = "http://bi.syncfusion.com/olap/msmdpump.dll";
this.cube = "Adventure Works";
this.catalog = "Adventure Works DW 2008 SE";
this.rows = [{ fieldName: "[Date].[Fiscal]" }];
this.columns = [{ fieldName: "[Core Product Group]", isNamedSets: true }];
this.values = [{ fieldName: "[Measures].[Internet Sales Amount]" }], axis: "columns" }];
this.filters = [];
}
}
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page