8.1.1 Common filters

You can use a series of Report Prompts to filter the data according to Functional Key Attributes as described below:

Figure 8-1 Canvas Prompt Filters for Time Dimension

• As of Date: The Execution Period for the output results. You can use this filter to isolate a selected timeframe for the analysis. The following screenshot displays the possible options that this filter provides against the Time Dimension.

  Figure 8-2 As of Date Selection

  
  

  

  
  
• Additional Filters for the Time Dimension as follows:
  • As of Date (Day)

  Figure 8-3 Canvas Prompt Filters for Cashflow Output Process execution data

  
  

  

  
  
• Number of Cashflow Projection in Years: You can use this filter to select a specific Cashflow Projection period to be applied to the Cashflow Output Process execution data; i.e. for next two years of Cashflow Projection you can apply the following selection

  Figure 8-4 Number of Cashflow Projection in Years

  
  

  

  
  
• Cash Flow Date: You can use this filter to select a specific Cashflow Date to be applied to the Cashflow Output Process execution data
• Cashflow Process Name: You can use this filter to select a specific Cashflow Process Name to be applied to the Cashflow Output Process execution data
• Execution Run Identifier: You can use this filter to select a specific Execution Run Identifier to be applied to the Cashflow Output Process execution data
• Scenario Name: You can use this filter to select a specific Scenario Name to be applied to the Cashflow Output Process execution data
• Currency Name: You can use this filter to select a specific Currency Name to be applied to the Cashflow Output Process execution data

  Figure 8-5 Canvas Prompt Filters for Legal Entity key processing dimension

  
  

  

  
  
• LE Hierarchy Name: N.B. this is a mandatory filter for the group filtering on Legal Entity key processing dimension.

  As the Application supports the creation of multiple hierarchies for the same Dimension of analysis, and to avoid displaying results from multiple Dimension Hierarchies at the same time, a mandatory driver to select “LE Hierarchy Name” must be selected with only a single value simultaneously.

• Legal Entity Leaf Name: You can use this filter to select the Legal Entity Leaf Name that is related to the Cashflow Output Process execution data.

  Figure 8-6 Canvas Prompt Filters for Org Unit key processing dimension

  
  

  

  
  
• Org Hierarchy Name: N.B. this is a mandatory filter for the group filtering on Org Unit key processing dimension.

  As the Application supports the creation of multiple hierarchies for the same Dimension of analysis, and to avoid displaying results from multiple Dimension Hierarchies at the same time, a mandatory driver to select “Org Hierarchy Name” must be selected with only a single value simultaneously.

• Org Unit Leaf Name: You can use this filter to select the Org Unit Leaf Name that is related to the Cashflow Output Process execution data.

  Figure 8-7 Canvas Prompt Filters for Product key processing dimension

  
  

  

  
  
• Prod Hierarchy Name: N.B. this is a mandatory filter for the group filtering on Product key processing dimension.

  As the Application supports the creation of multiple hierarchies for the same Dimension of analysis, and to avoid displaying results from multiple Dimension Hierarchies at the same time, a mandatory driver to select “Prod Hierarchy Name” must be selected with only a single value simultaneously.

• Prod Leaf Name: You can use this filter to select the Prod Leaf Name that is related to the Cashflow Output Process execution data.

  Figure 8-8 Canvas Prompt Filters for GL Account key processing dimension

  
  

  

  
  
• GL Account Hierarchy Name: N.B. this is a mandatory filter for the group filtering on GL Account key processing dimension.

  As the Application supports the creation of multiple hierarchies for the same Dimension of analysis, and to avoid displaying results from multiple Dimension Hierarchies at the same time, a mandatory driver to select “GL Account Hierarchy Name” must be selected with only a single value simultaneously.

• GL Account Leaf Name: You can use this filter to select the GL Account Leaf Name that is related to the Cashflow Output Process execution data.

  Figure 8-9 Canvas Prompt Filters for Common COA key processing dimension

  
  

  

  
  
• Common COA Hierarchy Name: N.B. this is a mandatory filter for the group filtering on Common COA key processing dimension.

  As the Application supports the creation of multiple hierarchies for the same Dimension of analysis, and to avoid displaying results from multiple Dimension Hierarchies at the same time, a mandatory driver to select “Common COA Hierarchy Name” must be selected with only a single value simultaneously.

• Common COA Leaf Name: You can use this filter to select the Common COA Leaf Name that is related to the Cashflow Output Process execution data.