Free-Form enables you to generate reports based on SQL queries of the CA Business Service Insight database or any external database. They are commonly used to configure statistical reports based on data created by the Business logic methods Tools.SaveRecord and Tools.SaveFields. For example, you can configure a free-Form report displaying relevant statistics regarding the help desk.
Free-Form reports connect to a selected database with a connection string, and execute an SQL query on that database using a query string. Parameters can be added to both strings to create dynamic reports that allow the user to enter or select specific values to include in the query, such as the user name and password for connecting to the database.
Free-Form reports are displayed in Chart, Data and Filter tabs similar to reports generated using the Report Wizard. They can include charts only if all columns, excluding the first column, are numeric. The data in the first column is used for the X-axis titles. Column names are used for other titles.
A Free-Form report can also be displayed as a heat map, which is a graphical representation of data where the values taken by a variable in a two-dimensional map are represented as colors.
Note: The method is executed by the engine only in the context of calculation of the tracking period of the metric, and is ignored in all other granularities.
Note: See also EXTERNAL_VALUE.
|
Copyright © 2012 CA.
All rights reserved.
|
|