Pivot Preview View
The Pivot view is a dynamic pivot table that allows execution of, and displays results for, any Pivot setup in the system and it's underlying results from a SQL Wrapper. This provides a consistent and easy method for viewing and interacting with the results of the data.
Pivot Features
The pivot view is capable of interacting with, and displaying the result of any Pivot setup in the system.
The table dynamically loads the rows/columns from the Pivot design and resulting data set applying any formatting and options you've specified as it builds the resulting table.
The pivot firsts loads the SQL Wrapper schema itself and them loads the pivot design definition which references that schema. From this the system can design the table including the correct order of columns, rows, fields, values and groupings/totals.
Next the system executes the SQL Wrapper itself using any preset parameters, or prompts if required. The results determine the amount of rows/columns depending on your design and the system aggregates the data and displays it correctly throughout the table.
Using advanced options you can provide drill down settings so when a user clicks on a cell it opens up another sql wrapper/chart/pivot and passes parameters automatically into that so it can display further details of the data in that cell.
As you are editing Pivots if you make changes to the rows, columns, filters, values and they aren't immediately reflected in this pivot tabe, you can just close and re-open the Pivot to dynamically load those changes in, or re run the "Run" command.
Running The Results
You can easily run the results of the Pivot by clicking the
Just like a SQL Wrapper this will first popup a parameter dialog with the parameters that are specified in the SQL Wrappers Parameters. The system will automatically apply the correct controls for the user to select values from. If you have setup default values or formulas, then they will be evaluated and entered by default for those parameter values.
The system will then execute and display the results in the pivot table.