The Pivot Grid is a component that enables you to create a pivot table, utilizing data from any existing and new Data Adapters to perform multi-dimensional analysis. At run-time, the user can customize the layout of the report using simple drag-and-drop operations and conditional formatting based on their analysis requirements. In the Pivot Grid, data can be summarized, and calculated fields, both text and decimal, can be added and displayed in a cross-tabular format that can be sorted, grouped and filtered. The Pivot Grid also supports drill-down, which enables you to view the underlying Data Adapter Results Table. The resulting output can be printed or exported to various file formats, such as PDF, XLS and XLSX.
All Data Adapters are supported when using the Pivot Grid. Utilizing Cube View MD (Multi-Dimensional) as the source of a Data Adapter will return the selected Cube View as a Multi-Dimensional Fact Table and provide a source table for the Pivot Grid. The results of the Cube View MD are the following Dimensions as columns: Entity, Consolidation, Scenario, time, View, Account, Flow, Origin, IC, and UD1-UD8.
General
Name
The name of the Pivot Grid.
Description
A description of the Pivot Grid.
Maintenance Unit
The Maintenance Unit the Component belongs in.
Component Type
The type of Component
Pivot Grid
Show Toggle Size Button
Select True to enable the toggle button and let users toggle the size of the Component at run-time. Select False to hide the toggle button.
Row Fields
Enter a comma separated list of Column Names from the Results Table to be placed in the Row Area of the Pivot Grid by default.
Column Fields
Enter a comma separated list of Column Names from the Results Table to be placed in the Column Area of the Pivot Grid by default.
Data Fields
Add a Measure from the Results Table to be assigned as the default Measure. Multiple measures can be added using a comma to separate the column names.
Field Groups
Enter a comma separated list of Column Names from the Results Table to be grouped together as a default.
Save State
When set to True, the Save Button is enabled on the Pivot Grid. When set to False, the Save Button on the Pivot Grid is disabled.
NOTE: Layout button on Pivot Grid when copying Dashboards: When copying a Dashboard that contains a Pivot Grid or Large Data Pivot Grid, the Pivot Grid and Large Data Pivot Grid component layouts are saved per dashboard location, not by component. Next time each dashboard is run, the Pivot Grids should have different saved layouts.
