Page History
...
Table B-1 Table tag attributes
| Attribute | Description |
|---|---|
| name | Specifies the table name as defined in the database schema. For a statistics table type, you can use the $sumlvl variable. In this case, you must set also the summary_levels attribute. When executing the customized report, the $sumlvl variable uses the value that you set in the summary_levels attribute. |
| type | Defines the table type, as follows:
|
| summary_levels | This attribute is only relevant for a statistics table type. It lists the available summary levels for this table. These values include:
|
| time_field | Defines the timestamp column name. Use this attribute only if the column name is different than the standard xxxx_timestamp column name, where xxxx indicates the name of the table (abbreviated). |
| noteable_name | A flag that enables or disables Join conditions. Set this flag to true for tables that contain Join conditions written in Java code. In this case, replace the table-name with the table name whose Join conditions you want to disable. For example, noPS_INSM_SERVER_MACHINE="true", will disable the Join conditions in table PS_INSM_SERVER_MACHINE. |
| alias | Defines an alias name for a table that is used frequently. For example, you can use the same lookup table again for different purposes. |
| Anchor | ||||
|---|---|---|---|---|
|
...
Table B-2 Join tag attributes
| Attribute | Description |
|---|---|
| toTable | Specifies the table that is joined with the current table. |
| otherTables | Specifies the name of a connection table. This attribute is used if the Join is performed through another table. |
| normalization_field | Defines a Join condition for a Lookup Table, whose name ends with _N. You can use the normalization_field attribute to specify the name of the normalization column. In this case, the select will include a ‘group by’ with the normalization_field column and will be wrapped by another select, which joins with the Lookup Table specified in the toTable attribute. The reasons for applying this method are:
|
| Anchor | ||||
|---|---|---|---|---|
|
...
Table B-3 Related tag attributes
| Attribute | Description |
|---|---|
| table | Defines the name of the Statistics Table. |
| depend | Specifies the dependency condition identifier. This identifier is defined in the def.xml file. If the dependency condition is met, then the table specified in the table attribute is used to retrieve the list of entity identifiers. |
| Anchor | ||||
|---|---|---|---|---|
|
...
Table B-4 Group tag attributes
| Attribute | Description |
|---|---|
| name | Defines a string representing the group name. Report Manager translates this string to a text defined in the udrTxtResource.xml resource file, and then displays the translated text in the Data Tree. |
| desc | Defines a unique numeric identifier that represents the description of the group. Report Manager translates this number into text defined in the udrTxtResource.xml resource file. Before adding a new identifier to the file, you must verify that this number is not already in use. (The numeric identifier at the end of the file list is not necessarily the highest one.) |
| isApptier | Defines whether the group is an Tier group or not. |
| tech | Defines a string that represents the technology of the Tier group. Report Manager translates this string into text defined in the udrTxtResource.xml resource file. |
| installCode | Defines a string that represents the installation code. Its format is a combination of the product code and init code. For example, IS-FP, where IS is the product code and FP is the init code. |
Report Manager validates the installation code using the Infrastructure Installation Table named PS_INLL_INSTALLATION, to determine whether or not to display this group in the specific Precise application. (The Infrastructure Installation Table contains information regarding the application’s system installations.)
...
Table B-5 Object tag attributes
| Attribute | Description |
|---|---|
| id | Defines a numeric identifier of the data field. |
| type | Defines a string that represents the type of object. The value can be one of the following:
|
| data_type | Describes the type of each data field. Default values include:
It is possible to override the default type of the data field type by defining the data_type attribute. Possible values include: string, time, int, and float. |
| xls_format | The format of each type of data field has a default value used by Microsoft Excel. By default, Microsoft Excel uses no special format for strings. For numeric data types, Microsoft Excel uses the floating decimal point format. For date/time data types, Microsoft Excel uses the numeric format. You can override the default format by defining the xls_format attribute. For example, you can override the format of the date/time data type with one of the following formats: m/d/yy, d-mmm-yy, d-mmm, mmm-yy, h:mm AM/PM, h:mm:ss AM/PM, h:mm, h:mm:ss, and m/d/yy h:mm. |
| name | Defines a string that represents the data field name. Report Manager translates this string into a text defined in the udrTxtResource.xml resource file, and then displays the translated text in the Data Tree. |
| desc | Defines a unique numeric identifier that represents the description of the data field. Report Manager translates this number into a text defined in the udrTxtResource.xml resource file. Before adding a new identifier to the file, you must verify that this number is not already in use. (The numeric identifier at the end of the file list is not necessarily the highest one.) |
| installApp | Defines a string that represents a Tier code. A specific data field may depend on a specific Tier, so if the Tier is not installed in the current application, the data field will not be displayed in the Data Tree. The Tier installation is verified against the Infrastructure Tier Table named PS_INAP_APP_TIER. |
| installCode | Defines a string that represents the installation code. Its format is a combination of the product code and init code. For example, IS-FP, where IS is the product code and FP is the init code. Report Manager validates the installation code using the Infrastructure Installation Table named PS_INLL_INSTALLATION, to determine whether or not to display this group in the specific Precise application. (The Infrastructure Installation Table contains information regarding the application’s system installations.) |
| includeQ | Defines a new query used if the object returns no data (in this case, the data field is not displayed). For example: <object id="4026" type="id" name="SQSiebelView" desc="446" |
About the Objref tag
This tag defines a reference to another Object that is already defined in the Data Tree definition. Use the Objref tag if the data field you want to add to the Data Tree has the same attributes as an existing object (instead of repeating the entire definition of the object).
...
Table B-6 Alt tag attributes
| Attribute | Description |
|---|---|
| select | Defines a table column name or an expression. For a counter (type="cnt"), an expression with an aggregated function is required. The expression can include the $timeFld string, which Report Manager replaces with the timestamp column of the table used in the query. In this case, the table attribute must be empty. |
| table | Specifies the name of the table as defined in the Performance Management Database. |
| depend | Specifies the name of the dependency condition as defined in the def.xml file. If the specified condition is met, Report Manager uses the alternative SELECT. |
| otherTables | Defines a name of a connection table. If you need to join one table to other tables for this data field only, you can specify its conditions in the alt tag and it is therefore not necessary to define this Join in the db.xml file. |
Precise. Performance intelligence from click to storage. Learn more > >
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal