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

Cell Exploreability On Matrix Reports

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.

Question

I have a Matrix report with the "Make Report Explorable (HTML Reports only)" option enabled. Why can I drill into some numbers on the report, but not others?

Answer

Report numbers cannot be explored in HTML if: 

  1. Numbers are aggregates of more than one coordinate (Version/Account/Plan/Time) in the system (except Account/Plan/Time rollups). 
  2. Coordinates which are filtered with more than one dimension value for a single dimension where the dimension values that have been used in the filter do not map to a single rollup value for that dimension. This includes standard (Version/Account/Plan/Time) as well as custom dimensions. The one exclusion to this rule is for a (Version/Account/Plan/Time) coordinate that has multiple splits associated with it. In such a case, you would be able to explore the number if a set of custom dimension filters (one or more) are provided with single dimension values as qualifiers. 
  3. (Only) and (Any) values will not be explorable. 
  4. The number is of "% of Account" type. 
  5. The number is report calculation number (Subtotal or Difference element/Custom Calculation). 
  6. YTD or QTD elements.
 
  • Was this article helpful?