Chat now with support
Chat with Support

Stat 6.3 - System Administration Guide

Overview of Stat Administration Administrative Utilities Stat Security General Maintenance Tables
System Maintenance Service Domain Maintenance Department Maintenance Issue Tracking Maintenance Country Maintenance Customer Maintenance Object Type Maintenance PeopleSoft Environment Connection Maintenance Pre/Post Migration Steps Parameters Oracle Applications Configuration Oracle Applications Connection Maintenance Generic Application Connection Maintenance Schema Object Parameters Maintenance Data Object Maintenance PeopleSoft Search Configurations Stat Report Definition Maintenance Version Control Management Connection Maintenance
Service Domain-Specific Maintenance Configuring the Stat Central Agent Email Configuration Object Security Appendix: Sample Service Domain Configuration Appendix: User Class Rights Appendix: Creating a Staging Database Appendix: Database Tuning Appendix: Oracle Applications File Type Directory Appendix: Ports and Firewalls Appendix: REST Web Services API Appendix: SOAP-Based Web Services API Appendix: Troubleshooting Chart Appendix: stat.conf Configuration Appendix: Custom Report Files

Adding Custom Reports

All Stat reports are defined by corresponding .jrxml files. Custom reports are created by formatting a .jrxml file using the 3rd party reporting tool Jaspersoft Studio. You can create a report file from scratch, or you use a copy of an existing file as a starting point. For more information on creating report files, see Appendix: Custom Report Files .

After you have defined the .jrxml file that is the basis for your custom report, you can add it to the Stat Report Library.

1
Click New.
2
Click Load and select the custom report .jrxml file you want use as the basis for the report.
The file name is displayed in the Report field without the extension. This file name must be unique. This is the name that the agent searched for to compile the report.
8

Turning off the Emailing of Blank Reports

Stat reports are configured to bring up a blank page with a report title if there is no data. This is intended to demonstrate to the user that the report actually ran. Some sites however may not want Stat to email blank reports.

Stat report files (.jrxml files) are stored on the Stat Central agent under Stat_home/report/%category%/format. The subfolder they are stored under is named the same as the Report Category drop down listing on the Stat Report Wizard. Under each category subfolder the .jrxml files are located in the /format folder.

Each report has a file name that starts with dw_ and has a .jrxml extension. The linkage between the file name and the report name is in the STAT_REPORT_DEFN table.

Select DESCR, DW_NAME, CATEGORY from STAT_REPORT_DEFN where DESCR like '%Report name from Stat Report Wizard%' will give you the file name that needs to be modified.

As with customized reports, if you modify the .jrxml file in situ it may be overridden the next time you upgrade Stat. If this is a concern, then follow the procedure for creating a custom report which places a copy of the .jrxml file in the stat_home/report/custom directory/format folder and add the custom report to the Stat repository.

3
In Report Properties View, open the Advanced tab, scroll down to the option When No Data and change the value from All Sections, No Detail to No Pages.

Version Control Management Connection Maintenance

You can integrate Stat with your 3rd party version control management (VCM) system. This allows you to save your file objects from a VCM repository directly into Stat to control the process and the migration of the objects. Currently Stat supports the following VCM platforms: SVN, PVCS, Perforce, and CVS.

VCM Maintenance security is controlled by the following user class rights:

The 3rd Party Version Control Connection maintenance table is displayed in a standard maintenance window. To open this window, select Maintenance | General | VCM Connect.

Options include CVS, PVCS, SVN, P4, GIT, and TFS.
Click Apply to save your work.
5
Click Setup.

CVS_CONNECTION_TYPE

CVS connection type

CVS_HOST

CVS host machine

CVS_MODULE

CVS module

CVS_PASSWORD

CVS password

CVS_PORT

CVS host port

CVS_REPOSITORY_PATH

CVS root directory

CVS_RSH

CVS protocol used when connection type is ext

CVS_TAG_BRANCH

CVS tag or branch

CVS_TAG_BRANCH_FILE

CVS entity filename (full path) to use for retrieving list of tag/branch labels

CVS_USERNAME

CVS username

PVCS_LABEL

PVCS revision label

PVCS_LABEL_FILE

PVCS entity filename (full path) to use for retrieving list of revision labels

PVCS_PASSWORD

PVCS password

PVCS_PROJECT_DATABASE

PVCS project database

PVCS_PROJECT_PATH

PVCS current project

PVCS_PROMO_GROUP

PVCS use label for promotional group

PVCS_REPOSITORY_PATH

PVCS entity folder

PVCS_USERNAME

PVCS username

P4_CLIENT

Perforce client/workstation

P4_DEPOT

Perforce depot path (ex. //depot)

P4_PASSWORD

Perforce password

P4_PORT

Perforce host port

P4_PROJECT_PATH

Perforce project path relative to depot (ex. //depot/project1)

P4_REVISION

Perforce revision (if left blank, latest revision is used)

P4_REVISION_USING

Perforce revision can be retrieved using revision, label, or changelist

P4_SERVER

Perforce server hostname

P4_TICKET_PATH

Perforce ticket path (ex. c:\\p4tickets.txt)

P4_USERNAME

Perforce username

SVN_ALT_CONFIG_DIR

SVN configuration directory

SVN_CONNECTION_TYPE

SVN connection type

SVN_HOST

SVN host machine

SVN_PASSWORD

SVN password

SVN_PORT

SVN host port

SVN_REPOSITORY_PATH

SVN repository directory

SVN_REVISION

SVN revision

SVN_USERNAME

SVN username

GIT_CONNECTION_TYPE

GIT repository connection type (ssh://, http://, https://)

GIT_HOST

Hostname of the repository

GIT_PORT

Port number (Optional)

GIT_REPOSITORY_PATH

Path to the remote repository

IT_PROJECT_PATH

An optional path to a directory under the main repository (Optional)

GGIT_TAG_BRANCH

Specific branch or tag. If left blank, objects are pulled from master branch. (Optional)

GIT_USERNAME

Username to connect to the repository

GIT_PASSWORD

Password

TFS_CONNECTION_TYPE

TFS connection types (http or https)

TFS_HOST

Hostname of the machine housing the repository

TFS_PORT

Port number

TFS_COLLECTION

The TFS project collection including the virtual directory, like /tfs/DefaultCollection

TFS_SERVER_PATH

The mapping server folder including $/ and project, like $/Project/folder.

TFS_USERNAME

Usually the network username that has access to the repository

TFS_PASSWORD

Network user password

TFS_HTTP_PROXY_URL

The url to the proxy server including the port, like http://server:9191

TFS_HTTP_PROXY_USERNAME

The proxy server username

TFS_HTTP_PROXY_PASSWORD

The proxy server password

TFS_VERSION_USING

Has 3 values: Label, Changeset, or LatestVersion.

If Label is used, files are retrieved from a specific Label in the repository.
If Changeset is used, files are retrieved from a specific Change Set (C11 for example)

TFS_VERSION

Used to retrieve from a specific Label or Changeset.

If TFS_VERSION_USING is set to Label, set TFS_VERSION to a specific Label from which files are retrieved.
If TFS_VERSION_USING is set to Changeset, set TFS_VERSION to a specific Change set from which files are retrieved.
IMPORTANT: When users add file objects from a VCM repository to an archive set, a VCM-specific field is displayed in the Archive Set window (Revision for SVN and P4, Tag/Branch for CVS and Git, Label for PVCS, and Version for TFS). In this field users can override the default value specified by system administrators by specifying the particular version of the objects they want to add from the VCM repository. If left blank, Stat adds the most recent version of the objects in the repository.
7
Click Apply.
8
Click Test Connect to make sure that you have entered all the information correctly.
9

Service Domain-Specific Maintenance

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating