Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
"Your data request references a member that is unknown to Planning or Essbase" error in SmartView — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

"Your data request references a member that is unknown to Planning or Essbase" error in SmartView

Received Response
1
Views
2
Comments

Summary:

When using a HsGetValue formula, unable to retrieve data for one member in the Account dimension. The issue is only with this one member. This member has been recently moved within the dimension.

Content (required):

When using a HsGetValue formula, unable to retrieve data for one member in the Account dimension. The issue is only with this one member. I use the same formula with any other member in the same rollup and am able to retrieve the correct balances.

This member is also part of a alternate hierarchy and when I use the member name for the shared member eg. [AltHier].[123456] , the correct balance comes through. When i reference the account directly eg. 123456, that is when I get the 'Your data request references a member that is unknown to Planning or Essbase. Make sure all members are defined in Planning and Essbase" message.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!