Improved User Interface for Explore Cell
We reverted this feature from Preview and Production tenants on 2021-9-15 due to technical issues. We reinstate it on 2021-10-14.
We continue to improve Explore Cell functionality to provide a better user experience. We now enable you to hide irrelevant rows, enhancing usability. Also, you can now set the maximum number of contributing rows to display in cell explorer, providing better visibility into your data.
Opt Out of the New Interface for Explore Cell
Release: 2021-10-14
For convenience, we now enable you to opt out of the latest Explore Cell user interface changes and functionality until the next release. This enables you to complete important business tasks in a familiar setting.
We provide a new Apply Latest User Interface Updates to Explore Cell check box on the Visual Preferences page in general settings. We automatically enable the setting so that you can use the newest updates before making your decision. When you disable the setting, we revert the user interface and functionality of Explore Cell to the state prior to the current release.
Suppress Zeros and Blanks
Release: 2021-10-14
We now automatically suppress rows with zeros or blanks every time you launch Explore Cell for data driven by contributing details. This simplifies your view, enabling you to see only details from levels, dimensions, accounts, and attributes that actually contribute to the value you're exploring.
We also provide this new check box on the bottom-left corner of the Explore Cell window: Suppress Rows when all Zeros or Blanks. This enables you to display rows with zeros and blanks.
User Interface Changes to Explore Cell
Release: 2021-10-14
To make it easier to find information, we move these details to the upper-left section in the Explore Cell window:
- Cell value.
- Links to audit trail and drill capabilities.
- Links to sheets that show the value.
Also, we move these details to the upper-right section in the Explore Cell window:
- Details about the account, level, time period.
- Arrows to click to the previous and next time period.
You can still find contributing details in the bottom of the window, such as source accounts, formulas, and sources of contributing values.
We now enable you to hover over the formula references to view the value or the value to view the formula reference.
Set the Maximum Number of Contributing Rows
Release: 2021-10-14
We deliver a new Cell Explorer Contributing Rows Limit setting on the General Setup page, enabling you to set the maximum number of rows to display in Explore Cell. We automatically set the maximum to 2,000.
If you revert the Explore Cell user interface, the Modeled Sheet First Page Size setting on the General Setup page continues to control Explore Cell maximum rows.
New Explore Cell Functionality Available for Consolidation
Release: 2021-12-10
You can now use the improved user interface and Explore Cell functionality in all tenants, including those with consolidation for values that have components like:
- Audit trail for journal entries.
- Consolidation ownership percentages.
- CTA accounts.
- Elimination rules.
- Journal entries.
- Minority interest.
You can also now suppress zeros for minority interest pages in cell explorer.