Named sets
9 Mar 2018 / 3 minutes 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 the pivot grid by setting it’s unique name in the fieldName
property in the row or column axis and isNamedSets
Boolean property to true.
<div class="e-control">
{{ej-pivotgrid id="PivotGrid" e-dataSource=model.dataSource}}
</div>
export default Ember.Route.extend({
model() {
return {
dataSource: {
data: "http://bi.syncfusion.com/olap/msmdpump.dll", //data
catalog: "Adventure Works DW 2008 SE",
cube: "Adventure Works",
rows: [
{
fieldName: "[Date].[Fiscal]"
}
],
columns: [
{
fieldName: "[Core Product Group]",
isNamedSets: true
}
],
values: [
{
measures: [
{
fieldName: "[Measures].[Internet Sales Amount]"
}
],
axis: "columns"
}
]
}
}
}
});
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