1. Profitability Analytics Cloud Service User Guide
  2. Reports & Analytics
  3. Management Reporting
  4. Management Ledger Based Reporting
  5. Report Common Filters

6.3.1.1 Report Common Filters

You can use a series of canvas level pinned Prompts to filter the data according to Functional Key Attributes as follows:

Figure 6-11 Canvas Prompt Filters for Time Dimension


The image displays Canvas Prompt Filters for Time Dimension

  • As of Date: 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 6-12 As of Date Selection


This image displays the As of Date Selection

  • Additional Filters for the Time Dimension as follows:
    • Year
    • Quarter of Year
    • Month of Year

Figure 6-13 Other Canvas Prompt Filters


This image displays Other Canvas Prompt Filters

  • Currency Name: You can use this filter to select a specific Currency Code for the underlying preselected reporting currency.
  • Legal Entity Hierarchy Name: This filter is 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, you must select the Leaf Name with only a single value simultaneously to see results at leaf level.
  • Legal Entity Leaf Name: You can use this filter to select the Legal Entity Leaf Name corresponding to the hierarchy.
  • Org Unit Hierarchy Name: This filter is for the group filtering on Organization 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, you must select the Leaf Name with only a single value simultaneously to see data at the leaf level.
  • Org Unit Leaf Name: You can use this filter to select the Org Unit Leaf Name corresponding to the hierarchy.
  • Product Hierarchy Name: This filter is 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, you must select the Leaf Name with only a single value simultaneously to view results at leaf level.
  • Product Leaf Name: You can use this filter to select the Product Leaf Name corresponding to the hierarchy.