FDMEE: Import Fails With An Error "Cannot perform cube view operation. Essbase Error(1260046): Unknown Member [Period].[Feb] used in query" When Members Are Shared Multiple Times in Alternate Hierarchy
Last updated on MARCH 29, 2018
Applies to:Hyperion Financial Data Quality Management, Enterprise Edition - Version 184.108.40.206.210 to 220.127.116.11.210 [Release 11.1]
Information in this document applies to any platform.
When users are trying to Extract Data from Period Dimension(i.e Feb) through Import Process, it errors out:
"Cannot perform cube view operation. Essbase Error(1260046): Unknown Member [Period].[Feb] used in query" Hyperion Financial Data Quality Management, Enterprise Edition(FDMEE).
In this case, Customer has Source as Essbase ASO application, Period dimension has Jan - Dec members in base (YearTotal) hierarchy. And member "Feb" is also shared 11 times in YTD hierarchy (Feb_Ytd - Dec_YTD). When user tries to run the Import Process, it errors out as mentioned above.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms