Pivot: Create Pivot Table from Grid Data
Tag: Pivot
The Pivot tag lets you automate theFlexyView's integrated Pivot Table tool.
<Pivot FilePath="databaseEZ-pivot-setup.xml"/>Tag Attributes
| Attributes | Attribute Values | Value Description |
|---|---|---|
| Target | Applicable Grid Code | N/A - Not Required (See detailed description) |
| FilePath | User definable | The file path to the previously saved Pivot configuration XML file - Required |
| Server | Abbreviated server names (separated by comma) | N/A - Only applicable in consoleEZ (See detailed description) |
| Index | Positive integer | Window index number - Only applicable in consoleEZ (See detailed description) |
Detailed Description
When using the attribute FilePath to retrieve incoming files, it will validate if both the folder path is correct and that the file itself exists.
The configuration for the Pivot Table generator CANNOT be automated directly. The attribute FilePath, along with a saved configuration file must be used.
<Pivot FilePath="databaseEZ-Pivot-setup.xml"/>General grid automation actions can be used to configure the resulting pivot table, but these actions MUST be embedded within the Pivot action block.
The Server attribute is only applicable to consoleEZ, in which case it will be mandatory for Target="LogAnalyzer" or Target="VolumeAnalyzer".
The Index attribute is also only used in consoleEZ and is mandatory when using Target="LogAnalyzer" or Target="VolumeAnalyzer", it is the value found on the Log Analyzer and Volume Analyzer windows.
General grid automation actions can be used to configure the resulting pivot table, but these actions MUST be embedded within the Pivot action block.
Example Script
<ytriaAutomation>
<Load Server="ACME01/ACME" Select="True"/>
<Pivot FilePath="C:\pivot_config.xml">
<Export>
<SetParam field="FilePath" value="D:\temp-exports\PivotExport.html"/>
<SetParam field="ExportType" value="HTML"/>
<SetParam field="FileOutput" value="Unicode"/>
<SetParam field="OpenFileOnceGenerated" value="true"/>
</Export>
</Pivot>
</ytriaAutomation>
In the script above, the entire server "ACME01/ACME" will be loaded into the database tree and all databases will be selected and loaded into the main grid. The action Pivot will trigger the retrieval of the saved Pivot Table configuration file "pivot_config.xml" and generate a pivot table of the data in the main grid based on this based on this configuration. The resulting table will be exported to an HTML file; the file will open once it has been generated.