Explore Cell is Unavailable
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:
- Numbers are aggregates of more than one coordinate (version/account/level/time) in the system except account/level/time rollups.
- 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/level/time) as well as custom dimensions. The one exclusion to this rule is for a version/account/level/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.
- (Only) and (Any) values will not be explorable.
- The number is of "% of Account" type.
- The number is a report calculation number (e.g. custom calculation, subtotal, or difference element).
- YTD or QTD elements.