My Oracle Support Banner

After Upgrade to 11.2.15, Getting Error "Cannot query members by name. Essbase Error(1007090): Unknown member name [$SubVarName] in Outline Query" Runnig FR Reports Using Substitution Variables (Doc ID 3063181.1)

Last updated on DECEMBER 12, 2024

Applies to:

Hyperion Planning - Version 11.2.15.0.000 and later
Hyperion BI+ - Version 11.2.15.0.000 and later
Information in this document applies to any platform.

Symptoms

Non Admin users getting error

Cannot query members by name. Essbase Error(1007090): Unknown member name [$SubVarName] in Outline Query

message when they try to run a report that uses Essbase Global Substitution Variables.

Issue started after upgrade to 11.2.15/migration to EPM 21C.  Issue was not seen prior to the upgrade.

Users have the Financial Reporting Preferences for "User Point of View" set to ON. Admins are NOT getting this error when the same report is run.

Changes

 Migration to Essbase 21C

Cause

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
Symptoms
Changes
Cause
Solution
References


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