My Oracle Support Banner

Books Fail Indicating Error on Grid "Grid 1" Related to a Member Referencing a Substitution Variable (Doc ID 2770949.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Oracle Enterprise Performance Reporting Cloud Service - Version 20.09.56 and later
Information in this document applies to any platform.


Error message similar to

"Column A on grid "Grid 1" has a reference to a Member "&[Sub Var Name]" in dimension "[Dimension Name]" which was not found in data source "[NR Data Source]"

when opening/running Narrative Reporting Books.  NOTE: "Grid 1" referenced in the message may not exist in any of the reports used in the book.

Issue may not affect all users.


User running the book had previously run a Management Reporting report that also uses data source [NR Data Source].  When running the report, the report POV was set to use &[Sub Var Name] for [Dimension Name].

As a result, the user's [NR Data Source] User POV was set to use "&[Sub Var Name]" for dimension "[Dimension Name]."


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.