Unable To Create HFM Application In Essbase With Error" ERROR: HR#07080: Trying to add a dynamic formula to a non dynamic member"

(Doc ID 2411564.1)

Last updated on JUNE 25, 2018

Applies to:

Oracle Essbase Analytics Link for HFM - Version 11.1.2.2.400 and later
Information in this document applies to any platform.

Symptoms

Unable to build HFM application in Essbase using EAL. The following error can be seen in eal.log, 

ERROR
-----------------------
 ERROR: HR#07080: Trying to add a dynamic formula to a non dynamic member (xxxx = 775)
[18 May 2018 11:16:12] [dbmgr] ERROR: HR#07398: Error occur in line #7 in expression "HS.Dynamic "A#XXXXXX.C1 = A#XXXXXXX.C1#Allcustom1.C2#AllCustom2.C3#Allcustom3.C4#AllCustom4/A#xxxxxxx.C1#Allcustom1.C2#AllCustom2.C3#Allcustom3.C4#AllCustom4""
[18 May 2018 11:16:12] [dbmgr] ERROR: HR#07232: Cannot build expression

Changes

 New Setup. 

Cause

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