Table Of Contents
Understanding Automation Pack Objects
Accessing Automation Pack Properties
Viewing Automation Pack Content and Dependencies
Viewing Automation Pack Content
Automation for SAP BW and BWA Processes
Automation for SAP BW and BWA Target Properties
Automation for SAP BW and BWA Global Variables
Automation for SAP BW and BWA Knowledge Base Articles
Viewing Automation Pack Dependencies
Understanding Automation Pack Objects
The Automation for SAP BW and BWA automation pack includes the content used to automate best practices for monitoring SAP BW availability, operations and performance. This chapter provides information on the content included in the Automation for SAP BW and BWA automation pack. It contains the following sections:
•
Accessing Automation Pack Properties
•Viewing Automation Pack Content and Dependencies
Accessing Automation Pack Properties
You can access the automation pack properties from the Administration—Automation Packs view in the console. The automation pack properties dialog box displays general information about the content provided by the automation pack, version number, publish date, the provided objects, the dependencies of the automation pack, and the history of changes made to the automation pack.
Step 1 On the Administration workspace, click Automation Packs in the navigation pane to display the installed automation packs in the Automation Packs pane.
Information about the automation packs display in the following columns:
Column
|
Description
|
Company Name
|
Name of the company that released the automation pack.
|
Publish Date
|
Date the automation pack was created or exported to a file.
|
Version
|
Version number of the automation pack.
|
Display Name
|
Name of the automation pack.
|
ID
|
Identification number of the automation pack.
|
Import Date
|
Date the automation pack was imported into the product.
|
Licensed
|
Indicates whether the automation is a licensed product in Process Orchestrator.
|
Description
|
Text description of the automation pack.
|
Step 2 Select the automation pack in the Automation Packs pane, right-click and choose Properties.
Step 3 On the Properties dialog box, click the appropriate tab to view the automation pack properties:
Tab
|
Description
|
General
|
Displays general information about the automation pack.
|
Objects
|
Display a list of objects contained in the automation pack.
|
Dependencies
|
Display a list of automation packs and adapters referenced by the objects in the automation pack.
|
History
|
Displays when the automation pack was created or modified, and audit log entries that are relevant to the automation pack.
|
Step 4 Click Close to close the dialog box.
Viewing Automation Pack Content and Dependencies
Use the automation pack Properties dialog box to view the objects contained in the automation packs and the dependencies associated with the automation pack.
Note See
Viewing Automation Pack Content
Step 1 On the Administration—Automation Packs view, select Automation for SAP BW and BWA, right-click and choose Properties.
Step 2 On the Automation for SAP BW and BWA Properties dialog box, click the Objects tab.
Step 3 On the Objects tab, review the information about the objects provided by the Automation for SAP BW and BWA automation pack.
Columns
|
Description
|
Display Name
|
Name of the object (processes, global variables, knowledge base).
|
Type
|
Object type.
|
Action Required
|
Action required to successfully import or export the objects.
|
Description
|
Text description of the object.
|
Version
|
Object version.
|
Automation for SAP BW and BWA Processes
The following table contains the processes that are imported by the Automation for SAP BW and BWA automation pack.
Note The BWA Status Check and BWA Checklist processes execute the custom method BW- TREX Get Landscape Status Summary that shows the status based on SAP thresholds. Alert server thresholds can be changed using the standalone TREX Admin Tool run directly from Linux shell.
For instructions on using the TREX Admin Tool, refer to the SAP article.
Process Name
|
Description
|
Adhoc - BWA Create and Fill Indexes - List Input
|
Used to create and fill BWA indexes. The input variable is a list of InfoCubes (one per line).
|
Adhoc - BWA Create and Fill Indexes - Wildcard Input
|
Used to create and fill BWA indexes. The input variable can be a wildcard.
|
Adhoc - BWA Index Reorganization
|
Executes reorganization plan to distribute the indexes in a TREX system landscape to achieve a balanced memory and CPU load.
|
BW Accelerator Status - CCMS
|
Monitors BW Accelerator status based on CCMS.
|
BW Checklist
|
Automates the most important and frequent administration tasks for monitoring BW system health. This process detects and analyzes common error conditions that typically need to be addressed by system administrators.
|
BW FTP Source Availability
|
Proactively checks connectivity of selected FTP Destinations.
|
BW Infocube Dimension Ratio
|
Proactively monitors BW infocube dimension table size for performance impact and alerts when the dimension to fact table size ratio is too large.
|
BW OLAP Connectivity
|
Proactively monitors OLAP interface connectivity.
|
BW Query Response Time
|
Monitors the query execution response time. This process does not use BWA index for the query execution.
|
BW Report Performance Monitoring
|
Samples report query response time for a custom defined set of reports.
|
BW SAP Source System Extraction Error
|
Detects and analyzes the cause of aborted BW source system extraction jobs. This process examines the job log to accurately identify the cause of the aborted extraction job.
|
BW tRFC Source System Availability
|
Proactively checks connectivity of selected BW Source System RFC Destinations. This process issues an RFC connection test and identifies which RFC destinations have lost connectivity.
|
BWA Alert Monitoring
|
Proactively monitors BWA status.
|
BWA Alerts - Automate Actions
|
Automates the execution of recommended BWA actions.
|
BWA Checklist
|
Automates administration tasks for monitoring BWA system health.
|
BWA Create and Fill Indexes (InfoCubes List from Excel)
|
The Assessment for SAP BWA process creates an Excel spreadsheet in each execution and the results can be used by this process.
|
BWA Create and Fill Indexes (InfoCubes List from Global Variable)
|
Used to create and fill BWA indexes from a list of infocubes in a global variable.
|
BWA Delete Indexes
|
Used to delete BWA indexes.
|
BWA Index Reorganization
|
Executes reorganization plan to distribute the indexes in a TREX system landscape to achieve a balanced memory and CPU load. The process is triggered by a BWA Index Reorganization Required incident.
|
BWA Index Reorganization Required
|
Checks the BWA system for a reorganization recommendation.
|
BWA Query Response Time
|
Monitors the query execution response time. This process uses BWA index for the query execution.
|
BWA Services Statistics Monitoring
|
Proactively monitors BWA services statistics based on thresholds defined in the BW- BWA Service Statistics Thresholds global variable.
|
BWA Status Check
|
Proactively monitors BWA status.
|
BWA TREX Monitor Load Statistics
|
Monitors BWA TREX load statistics.
|
BWA TREX Status Check
|
Monitors BWA TREX status.
|
Create RSDDTREX_AGGREGATES_FILL Variant
|
Automates the creation of variant master data required to execute the ABAP fill program RSDDTREX_AGGREGATES_FILL.
|
HTTP BEx URL Test
|
Proactively checks connectivity of the BW BEx HTTP interface. This process issues a connection test and identifies if the interface is functioning.
|
InfoPackage Failed
|
Analyzes InfoPackage data transfer requests that have not completed processing or failed in the last hour.
|
Process Chain Errors
|
Analyzes process chains that have run since the last start of the BW system. This process detects process chain errors and retrieves log file.
|
Search BWA Trace Logs
|
Searches the BWA TREX trace logs for selected keywords.
|
Automation for SAP BW and BWA Target Properties
The following table contains the target properties that are imported by the Automation for SAP BW and BWA automation pack. The target properties that do not have a value defined must be configured by the user prior to using them in processes.
Target Property Name
|
Description
|
Value Defined?
|
BW - BEx URL Test
|
Monitors the availability of specific BW BEx HTTP URLs.
Enter a list of destinations to be monitored by Process Orchestrator. The entries are similar to SM59 for HTTP destinations.
Destination: BEx URL
Host:
Port:
Path: sap/bw/bex
Pattern: status_code200
Pattern can be a regular expression or a substring that you are looking for in the report result. Note that it will strip off all the white spaces (blank, tab, new line) and the "|" character from the report before matching it against the pattern. Pattern example: status_code200
|
No
|
BW - BWA Checklist RSRV Checks Enabled
|
Indicates if RSRV checks should be performed during BWA checklist process execution.
|
Yes
|
BW - BWA Delay to Check Jobs Filling Indexes
|
Contains the delay in minutes to check the background job that is filling indexes.
|
Yes
|
BW - BWA InfoCube List for Index (variable list)
|
Contains a list of InfoCubes to index and fill.
|
No
|
BW - BWA Service Statistics Threshold
|
Contains the threshold values to be used for monitoring BWA Services.
|
No
|
BW - BWA Top InfoCubes to Monitor Status
|
Contains a list of InfoCubes to be used in the BWA Checklist process to monitor InfoCube status.
|
No
|
BW- BWA Top Queries to Monitor Response Time
|
Contains a list of the most important queries for detail analysis (RSRT). This global variable is used in the BWA Checklist and BWA Query Response Time processes to monitor query response time. The query response time will also be published as Process Orchestrator metrics.
|
No
|
BW - BWA TREX Destination
|
Contains the BWA TREX Destination.
|
No
|
BW - BWA Unix Target
|
Contains a reference to the BWA Unix target.
|
No
|
BW - Infocube Dimension Ratio
|
Recommended BW Infocube dimension to fact table size ratios.
Wildcard is accepted (for example, if you want to match all infocubes starting with 0D_SD, enter 0D_SD*).
Note The BW Infocube Dimension Ratio process is supported to run in the BW operating client only.
|
No
|
BW - Report Threshold
|
Enter the list of BW Reports and average response time thresholds (seconds).
Wildcards are accepted (for example, if you want to match all reports starting with 0D_SD, enter 0D_SD*).
|
No
|
BW - Source Systems
|
SAP Systems that are sources for BW data extraction.
|
No
|
BW - Top Queries to Monitor Response Time
|
Contains a list of the most important queries for detail analysis (RSRT). It is used in the BW Query Response Time processes to monitor query response time. The query response time will also be published as Process Orchestrator metrics.
|
No
|
BW FTP Source Availability
|
Monitors the availability of a BW FTP sources.
Enter the FTP sources to be monitored by Process Orchestrator for availability.
The source is the IP address of the FTP server.
|
No
|
BW tRFC Source Availability
|
Monitors the availability of specific BW source system RFC destinations.
Enter a list of destinations to be monitored by Process Orchestrator for availability.
|
No
|
BWA Alert Monitoring Actions
|
Used for BWA alert monitoring problem resolution.
|
Yes
|
Automation for SAP BW and BWA Global Variables
The following table contains the global variable imported by the Automation for SAP BW and BWA automation pack.
Global Variable Name
|
Description
|
Value Defined?
|
BW - BWA InfoCube List for Index (lock selection)
|
Select if the index fill should be done with lock or no lock. Enter true or false.
|
Yes
|
BW - RSRT List of Events
|
Contains a list of RSRT events. It is updated by Cisco with all the available events.
|
Yes
|
Automation for SAP BW and BWA Knowledge Base Articles
The knowledge base articles provide information to help understand the results of an activity or process, including a summary of what has occurred, the possible cause of the results, and suggested actions to take to resolve issues with an activity. The Automation for SAP BW and BWA automation pack contains the Knowledge Base articles that are included in the SAP activities.
Knowledge Base Article
|
Summary
|
BEx HTTP Interface Unavailable
|
Process Orchestrator could not connect to the BEx HTTP interface.
|
BW Accelerator Status
|
Process Orchestrator detected a BW Accelerator status alert in CCMS.
|
BW Checklist
|
The BW Checklist process automates the most important and frequent administration tasks for monitoring BW system health.
|
BW FTP Source Unavailable
|
FTP Source could not be reached.
|
BW InfoCube Dimension Ratio is Low
|
Process Orchestrator has detected BW infocubes whose dimension to fact table size ratio is below threshold.
|
BW OLAP Unavailable
|
Connection to the OLAP interface in the BW system failed.
|
BW Process Chain Logs
|
Process Orchestrator has detected a process chain error or termination.
A process chain is a sequence of processes that wait in the background for an event. Some of these processes trigger a separate event that can start other processes.
|
BW Query Over Threshold
|
Process Orchestrator detected BW queries over the response time threshold.
|
BW Report Performance
|
Process Orchestrator detected BW reports response time is above the average and/or maximum threshold.
|
BW Source System Extraction Error
|
Process Orchestrator has detected an error in the processing of the BW source system extraction job.
|
BW Source System RFC Destination Unavailable
|
RFC Destination could not connect.
|
BW System Check
|
Confirms that system has Business Warehouse components installed.
|
BWA Checklist
|
The BWA Checklist process checks BWA system health.
|
BWA Index Created and Filled
|
The selected infocube indexes were successfully created and filled.
|
BWA Index Creation or Fill Error
|
An error occurred when indexing the selected infocube.
|
BWA Index Status
|
The BWA Index Status activity provides the current BWA index status and version.
|
BWA Query Over Threshold
|
Process Orchestrator detected BWA queries over the response time threshold.
|
BWA Status
|
Process Orchestrator detected BWA status different than green.
|
BWA TREX Alerts
|
Process Orchestrator detected BWA TREX alerts.
|
BWA TREX Service Statistics Over Threshold
|
Process Orchestrator detected TREX service statistics over threshold.
|
HTTP BExURL Test Failed
|
BEx URL Failed HTTP destination test executed by Process Orchestrator.
|
InfoPackage Request Failures
|
Process Orchestrator has detected BW InfoPackage requests in failed status.
|
InfoPackage Request Failures w/Error Messages
|
Process Orchestrator has detected BW InfoPackage requests in failed status.
|
Process Chain Error
|
Process Orchestrator has detected a process chain error.
|
RSMO - InfoPackage Request Failures
|
Process Orchestrator monitors BW InfoPackage requests table RSREQDONE for requests that failed or are in incompleted status.
An infopackage request is generated at the runtime of the data transfer process. The request is processed in the steps that have been defined for the data transfer process (extraction, transformation, filter). The monitor for the data transfer process request shows the header information, request status, and the status and messages for the individual processing steps.
|
RSRT - Execute Query with BWA Index
|
This activity runs a BW query with BWA index and returns debugging and performance information.
|
RSRT - Execute Query
|
This activity runs a BW query and returns debugging and performance information.
|
Top Response Time Components Over Threshold
|
The longest running components of the queries over runtime threshold are sorted and listed.
|
TREX Index List
|
The TREX List Indexes activity displays technical information on BWA indexes, such as the number of searchable documents, and the memory and disk space used per index.
|
TREX Landscape Summary
|
The TREX Landscape Summary activity provides an overview of the TREX status with information on the TREX version, operating system, and current error messages.
|
TREX Service Statistics
|
The TREX Services Statistics activity displays the system load on the TREX servers listed by each service type.
|
Viewing Automation Pack Dependencies
Step 1 On the Administration—Automation Packs view, select Automation for SAP BW and BWA, right-click and choose Properties.
Step 2 On the Automation for SAP BW and BWA Properties dialog box, click the Dependencies tab.
Step 3 Review the list of automation packs and adapters referenced by the Automation for SAP BW and BWA automation pack:
Object Type
|
Dependency
|
Automation Packs
|
•Core Automation for SAP
•Core
•Assessment for SAP BWA
•Core Automation for SAP BW, BOBJ and In-Memory Computing
•Common Activities
|
Adapters
|
•Core Functions Adapter
•SAP ABAP Adapter
•Generic (Microsoft OLEDB) Database Adapter
•Microsoft Windows Adapter
•Oracle Database Adapter
•IBM DB2 Database Adapter
•Microsoft SQL Server Database Adapter
|
Step 4 Click Close to close the dialog box.
Note
Feedback