Dayalan Punniyamoorthy Blog

Wednesday, February 27, 2019

New Row and Column Suppression Behavior for EPM Cloud!!

I am sure you will love this exciting new feature released in Smartview  11.1.2.5.720


This feature applies to these EPM Cloud services:
  • Oracle Planning and Budgeting Cloud
  • Oracle Enterprise Planning and Budgeting Cloud
  • Oracle Financial Consolidation and Close Cloud
  • Oracle Tax Reporting Cloud
In web applications, your administrator can use the Smart View Suppression Behavior option to change suppression behavior when both the Smart View No Data/Missing and Zero suppression options for rows, or columns, or both are selected.




This is my Smart View report before setting the Suppress Rows "No Data/Missing" and "Zero"


If the Smart View Suppression Behavior option in the web application is set to:
  • Legacy—Only suppresses rows or columns containing either all No Data/Missing or all Zeros. Does not suppress rows or columns containing a combination of No Data/Missing and Zeros. For example, in Smart View, if both the No Data/Missing and Zero suppression options are selected for rows, and a row contains both zeroes and Missing labels, then the row is displayed; it is not suppressed.
This is how my Smart View report look after setting it to Legacy

  • Standard—Suppresses rows or columns containing all No Data/Missing or all Zeros, or a combination of both. For example, in Smart View, if both the No Data/Missing and Zero suppression options are selected for columns, and a column contains both zeroes and Missing labels, then the column is suppressed; it is not displayed.
And for Standard


Make use if it, Happy times ahead!!!

3 comments: