A multitude of predefined queries are provided in the package. The following includes all queries available after installation.
All shipped queries provided in the Public folder are examples.
1. Business Drivers
Controls and policies associated with the risk
Output: Risk-related controls, user groups, policies and their user groups, as well as measures
Start object: Risk
Controls and control test definitions associated with the risk
Output: Risk-related controls, user groups, as well as control test definitions and their user groups
Start object: Risk
Elements affected by the risk
Output: Application system types, measures, controls, regulations, KPI instances, organizational units, policies, and risk categories
Start object: Risk
Groups and persons responsible for the risk
Output: Persons including their first name, last name, and e-mail address
Start object: Risk
Risk categories associated with the risk
Start object: Risk
Audits and audit steps for which the regulation is in scope
Start object: Technical term
Controls and processes associated with the regulation
Start object: Technical term
Controls, control owner, and risks associated with the regulation
Start object: Technical term
Groups and persons responsible for the control
Output: Persons including their first name, last name, and e-mail address
Start object: Function
Persons and roles associated with a user group
Start object: Role
Policies associated with the regulation
Start object: Technical term
Regulation hierarchy
Start object: Technical term
Risks and their processes associated with the regulation
Start object: Technical term
Risks, risk owner, and controls associated with the regulation
Start object: Technical term
Application systems or application system types used by the organizational unit
Start object: Organizational unit
Application systems or application system types used by the role
Start object: Role
Create end-to-end process overview spreadsheet (top level VAC)
Creates a table containing all existing subprocesses and their process steps, as well as selected attributes.
Start object: Function of a value-added chain diagram (VAC)
Data and information required by the organizational unit
Start object: Organizational unit
Data and information required by the role
Start object: Role
EPCs run by the Organizational unit
Start object: Organizational unit
EPCs run by the role
Start object: Role
Functions carried out by the organizational unit
Start object: Organizational unit
Functions carried out by the role
Start object: Role
Organizational units, or organizational unit types, or positions, or roles affected by a failure of the application system type
Start object: Application system type
Process models connected with the function
Start object: Function
Application systems or application system types used by the position
Start object: Position
Create process expert's spreadsheet including attributes for process simulation (EPC)
Creates a table containing process steps and process attributes relevant to simulation, which is intended for entry of processing times and probabilities of occurrence.
Start object: Model of the EPC type
Data or information required by the position
Start object: Position
ECPs run by the position
Start object: Position
Functions associated with the model
Start object: Model
Functions carried out by the position
Start object: Position
Objects associated with the group
Start object: Group
Objects associated with the model
Start object: Model
Evaluate application and related architecture component lifecycle
Start object: Application system type
Evaluate architecture component and related application lifecycle
Start object: Application system type
Functions associated with the application system
Start object: Application system
Functions associated with the application system type
Start object: Application system type
Find all processes related to customer journeys
All processes with their associated customer journeys are output.
Start object: Function
Find customer touchpoints clustered by associated channel
The customer touchpoints belonging to a channel are output.
Start object: Distribution channel
Find customer touchpoints clustered by associated ownership
All customer touchpoints for which the selected organizational unit is responsible are output.
Start object: Organizational unit
Find customer touchpoints clustered by associated risk
The customer touchpoints belonging to a risk are output.
Start object: Risk
Find risks and initiatives for all customer touchpoints
All customer touchpoints are output along with their associated risks and strategic initiatives.
Start object: Customer journey
Find risks and initiatives for bad customer touchpoints only
All bad customer touchpoints are output along with their associated risks and strategic initiatives.
Start object: Customer journey
Get full customer journey overview (for data maintenance)
A table is output showing a complete overview of the customer journey.
Start object: Customer journey
2. ARIS Framework & Views
Application systems or application system types used by the organizational unit
Start object: Organizational unit
Application systems or application system types used by the organizational unit type
Start object: Organizational unit type
Application systems or application system types used by the position
Start object: Position
Application systems and application system types used by the role
Start object: Role
Data or information required by the organizational unit
Start object: Organizational unit
Data and information required by the organizational unit type
Start object: Organizational unit type
Data and information required by the position
Start object: Position
Data and information required by the role
Start object: Role
EPCs run by the organizational unit
Start object: Organizational unit
EPCs run by the organizational unit type
Start object: Organizational unit type
EPCs run by the position
Start object: Position
EPCs run by the role
Start object: Role
Find customer touchpoints clustered by associated ownership
All customer touchpoints for which the selected organizational unit is responsible are output.
Start object: Organizational unit
Functions carried out by the organizational unit
Start object: Organizational unit
Functions carried out by the organizational unit type
Start object: Organizational unit type
Functions carried out by the position
Start object: Position
Functions carried out by the role
Start object: Role
SAP roles - Screen analysis
Start object: Role
Create end-to-end process overview spreadsheet (top level VAC)
Creates a table containing all existing subprocesses and their process steps, as well as selected attributes.
Start object: Function of a value-added chain diagram (VAC)
Data or information associated with the function
Start object: Function
Demo_ARISConnect_KPI
Start object: Model
Find all processes related to customer journeys
All processes with their associated customer journeys are output.
Start object: Function
Organizational units, organizational unit types, positions, or roles connected with the model
Start object: Model
Organizational units, organizational unit types, positions, or roles connected with the function
Start object: Function
Process models connected with the function
Start object: Function
Function and associated application systems or application system types
Start object: Function
Functions associated with the group
Start object: Group
Functions associated with the model
Start object: Model
Objects associated with the group
Start object: Group
Objects associated with the model
Start object: Model
Organizational units, or organizational unit types, or positions, or roles associated with the model
Start object: Model
Organizational units, or organizational unit types, or positions, or roles associated with the function
Start object: Function
Organizational units, or organizational unit types, or positions, or roles associated with the group
Start object: Group
Process models associated with the group
Start object: Group
Process models associated with the function
Start object: Function
Evaluate application and related architecture component lifecycle
Start object: Application system type
Evaluate architecture component and related application lifecycle
Start object: Application system type
Functions associated with the application system
Start object: Application system
Functions associated with the application system type
Start object: Application system type
Organizational units, or organizational unit types, or positions, or roles affected by the failure of an application system
Start object: Application system
Organizational units, or organizational unit types, or positions, or roles affected by the failure of an application system
Start object: Application system type
Functions associated with the cluster
Start object: Cluster/Data model
Functions associated with the entity type
Start object: Entity type
Functions associated with the information carrier
Start object: Information carrier
Functions associated with the technical term
Start object: Technical term