Pivot client: Elements

14 Feb 201911 minutes to read

Cube selector

The cube selector allows you to select any one of the cubes available in the connected database. This can be achieved with a drop-down list displaying the list of cube names. By selecting a cube from the drop-down list, the corresponding cube element gets loaded.

Cube Selector in ASP NET Core pivot client control

Cube dimension browser

The cube dimension browser is a tree view like structure that organizes the cube elements such as dimensions, hierarchies, measures, etc., from the selected cube into independent logical groups.

Drag and drop

You can alter the report on fly through the drag and drop operation.

Treenode drop in ASP NET Core pivot client control

You can also alter the report by using the context menu.

Context menu for tree view elements in ASP NET Core pivot client control

Types of node in cube dimension browser

Display folder: A folder that contains a set of similar elements.
Measure: Quantity available for analysis.
Dimension: A name given to the parts of the cube that categorizes data.
Attribute hierarchy: Level of attributes down the hierarchy.
User-defined hierarchy: Members of a dimension in a hierarchical structure.
Level: Denotes a specific level in the category.
Named Set: A collection of tuples and members, that can be defined and saved as a part of cube definition.

Attribute hierarchy

Attribute hierarchy contains the following levels:

A leaf level that contains distinct attribute member and each member of the leaf level is known as a leaf member.
Intermediate levels if the attribute hierarchy is a parent-child hierarchy.
An optional (all) level (IsAggregatable=True) contains the aggregated value of the attribute hierarchy’s leaf members, with the member of the (all) level also known as the (all) member.

User-defined hierarchy

User-defined hierarchy organizes the members of a dimension into hierarchical structure and provides navigation paths in a cube. For example, take a dimension table that supports three attributes such as year, quarter, and month. The year, quarter, and month attributes are used to construct a user-defined hierarchy, named calendar, in the time dimension which relates to all levels.

Differentiating user-defined hierarchy and attribute hierarchy

User-defined hierarchy contains more than one level whereas attribute hierarchy contains only one level.
User-defined hierarchy provides the navigation path between the levels taken from attribute hierarchies of the same dimension.
The attribute hierarchy and user-defined hierarchy are represented in different ways as shown in the following table:

Symbolic representation of the nodes in cube dimension browser

Name	Node type	Is Draggable
Display Folder	Display Folder	False
Measure	Measure	True
Dimension	Dimension	True
User Defined Hierarchy	Hierarchy	True
Attribute Hierarchy	Hierarchy	True
Levels (in order)	Level Element	True
Named Set	Named Set	True

Axis element builder

The axis element builder allows you to build the elements in the axes of pivot client. It supports four axes namely columns, rows, filters, and values. Based on the construction of axes, the pivot grid and pivot chart will display the resultant data.

Columns

The column axis defines one or more elements that are displayed along the chart’s y-axis as labels and in the columns of the grid. If more than one dimension is present on the categorical axis, then the chart/grid will stack each dimension. The stacking order of dimensions is based on the order that they appear on the column axis.

Rows

The row axis defines one or more dimensions that are displayed along the chart’s x-axis as labels in the rows of the grid. If more than one dimension is present on the series axis, then the chart/grid will stack each dimension. The stacking order of dimensions is based on the order that they appear on the row axis.

Filters

The filter axis filters the multidimensional data displayed in the chart/grid. It allows you to analyze any member of a dimension in-depth. To display the member’s data in the slicer, that corresponding member must not be present on both the column axis and row axis.

Values

The value axis defines one or more measures (values) that are displayed along the chart’s series points in Y-axis as labels and in the value cell of the grid.

Axis element builder in ASP NET Core pivot client control

Split button

The split button highlights the elements in the axis element builder, and holds measures, dimensions, and named sets. When a dimension/hierarchy/level/named set node is dragged and dropped from the cube dimensional browser into the axis element builder, a split button is created and displayed along the corresponding dimension/named set caption.

When a measure node is dragged and dropped, the axis element builder will create a split button for holding the measures. The next time, a measure is added, it will maintain the same single split button to hold the entire measure collection.

The split buttons can be removed with the help of remove button which is available on its side.

Measure split button in JavScript pivot client control

Dimension split button in ASP NET Core pivot client control

Addition elements to an axis

The measure, dimension, hierarchy, level, and named set elements can be dragged from the cube dimension browser and dropped into the axis element builder at the desired position by using the drag and drop operation. These elements can be moved from one axis to another by dragging an appropriate split button and dropping them at the desired position.

Adding elements to an axis in ASP NET Core pivot client control

Remove elements from an axis

To remove measures, dimension, hierarchy, level, and named set elements from the axis element builder, click the remove button available next to the split button.

Removing elements from an axis in ASP NET Core pivot client control

Rearrange elements in an axis

Rearranging can be done by dragging and dropping the elements at the desired position.

Rearranging elements in an axis of ASP NET Core pivot client control

Rearranged elements in ASP NET Core pivot client control

You can alter the report by using the context menu.

Context menu for pivot button in ASP NET Core pivot client control

Elements editor

Member editor

Member Editor is a dialog that displays the members of current hierarchy in a tree view structure.

Member editor in ASP NET Core pivot client control

The “Check All” and “Uncheck All” option in the dialog allows you to select and unselect the entire nodes for filtering. To learn more details about filtering, click here.

Toolbar in ASP NET Core pivot client control

The options available in the toolbar are:

New report: Creates a new reports list and clears the existing report collection to provide a new platform for new deployment based on the existing cube elements.
Add report: Adds a new report to the existing list of reports.
Remove report: Removes the current report from the report list. If the report list contains only one report, you cannot remove it.
Rename report: The rename option allows you to change the name of the current report.
Report manipulation in DB: Contains options to manipulate the reports in the database.
MDX query: Displays the executed MDX query to retrieve the data at that instant.
Export to Excel: Exports the grid and chart to an Excel worksheet.
Export to Word: Exports the grid and chart to a Word document.
Export to PDF: Exports the grid and chart to a PDF document.
Full screen view: Displays the active control (chart/grid) in full/maximized view.
Toggle axis: Interchanges the items between categorical and series axes.
Chart types: Allows you to change the chart type dynamically.
Report list: Holds all reports of the current session of the pivot client control and displays the reports in a drop-down list. You can select a report from the drop-down list.

Following are the options available for database report manipulation:

Report manipulation icons in ASP NET Core pivot client control

Save: Saves the report collection by only one name in a database.
Save As: Save the report collection by more than one name in a database.
Load: Picks the saved report collection from the database and loads this by clearing the existing collection of reports.
Remove: Removes the selected report from the saved report list in the database.
Rename: Allows you to change the name of the selected report from the saved report list in a database.

Report manipulation

New report

This option allows you to create a new report collection with a single report by clearing the existing report collection. By clicking the new report icon in the toolbar, the New Report dialog opens as follows:

New report dialog in ASP NET Core pivot client control

After giving the required name and click OK. The report collection gets loaded with only one empty report having the entered name. By clicking Cancel, the new report creation gets canceled.

New report in ASP NET Core pivot client control

Add report

This option allows you to add a report to the existing report collection. By clicking the Add Report icon in toolbar, the Add Report dialog opens to provide a name for the report to be added as follows:

Add report dialog in ASP NET Core pivot client control

After an appropriate name has been provided in the respective column, click OK. A report with the entered name is added to the collection. By clicking Cancel, the report creation gets canceled.

Adding a report in ASP NET Core pivot client control

Remove report

This option allows you to remove the current/active report from the report collection. By clicking the remove icon on the toolbar, a dialog will open for user’s confirmation on removal of the report as shown below:

Remove report dialog in ASP NET Core pivot client control

Click OK to remove the report from the collection or click Cancel to withdraw the removing operation.

This option works only if the report collection has more than one report. If not, the following dialog will open:

Alert dialog for single report in ASP NET Core pivot client control

Rename report

This option allows you to rename the current/active report. By clicking the rename icon on the toolbar, the following dialog will open:

Rename report dialog in ASP NET Core pivot client control

After an appropriate name has been provided, click OK. The active report is refreshed with the new name.

Renaming of the previous report in ASP NET Core pivot client control

Save

The save option saves the entire report collection by only one name to a database. The database is connected to the application through a connection string provided in the service.

By clicking the save icon, the following Save dialog will open:

Save report dialog in ASP NET Core pivot client control

After an appropriate name has been provided, click OK. The report collection will be saved to the connected database. Otherwise, click Cancel to withdraw the saving operation.

Save As

The save as option saves the entire report collection by two or more names in the database. The database is connected to the application through a connection string provided in the service.

By clicking the save as icon, the following Save As dialog will open:

Save As dialog in ASP NET Core pivot client control

After an appropriate name has been provided, click OK. The report collection will be saved to the connected database. Otherwise, click Cancel to withdraw the saving operation.

Load

The load option loads the saved report collection from the database through the service. By clicking the load icon on the toolbar, the following load dialog will open:

Load dialog in ASP NET Core pivot client control

Select a report from the report collection through the drop-down list and click OK for loading the selected report collection. Otherwise, click Cancel to abort the report loading operation.

ASP NET Core pivot client control loaded with saved report

Remove

The remove option removes the saved report from the report collection. By clicking the remove icon on the toolbar, a remove dialog will open for user’s confirmation for removal of the report as shown below:

Removing saved report from database of ASP NET Core pivot client control

Click OK to remove the report from the collection. Otherwise, click Cancel to withdraw the remove operation.

Rename

The rename option allows you to rename the saved report. By clicking the rename icon on the toolbar, the following dialog will open:

Renaming saved report of ASP NET Core pivot client control

After an appropriate has been provided, click OK. The active report is refreshed with the new name.

Report list

The report list drop-down contains the names of all reports in the report collection.

Report collection in ASP NET Core pivot client control

Select the required report from the report list. The selected report will be set as active report, and loaded.

ASP NET Core pivot client control with selected report

Pivot grid and pivot chart

The pivot grid and pivot chart controls will be rendered with respect to the operations done at the axis element builder.