Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Why Is My Account Hidden On The Sheet For A Single Level?

Question

Why is my account hidden on the sheet for one level?

Answer

There are a couple of different scenarios that would cause an account to be hidden for a single level on a sheet.

If the account is a GL Account or Custom Account:

  1. Is it possible that the account does not have any data entered on that level and that the "Suppress rows if all zeros" setting is turned on in the Show and Hide settings? To check this, click on the show and hide icon (the funnel) and make sure the "Suppress rows if all zeros" setting is not checked to see if this allows the account to display.

  2. Is it possible that the account is hidden for that specific level in the Customization for Sublevels on the sheet? To check this setting, take the following path: Modeling > Level Assigned Sheets > Click on the Sheet Name > Edit Customization for Sublevels > Drill down to the level the account is hidden on by clicking on the parent level links to make sure the account is marked as editable.

If the account is a Cube Account:

  1. Check to see if the account is being suppressed due to zero values if the "Suppress rows if all zeros" setting is turned on in the Show and Hide settings.

  2. Is it possible that there is a Level - Account restriction set up on the Cube Sheet? To check this, take the following path: Modeling > Level Assigned Sheets > Click on the Sheet Name > Edit Restrictions.

  • Was this article helpful?