Essbase Studio adding shared member with Formula
Gurus,
Trying to figure out how to avoid a false error in Essbase studio as it builds an ASO cube. The issue in a nutshell is that it is trying to insert a formula to a shared member. The cube builds successfully and the outline reflects the correct changes. But would like to avoid error message altogether. Any advice is greatly appreciated.
Error adding formula (IIF(IS(Currencies.CurrentMember,[USD]),((([XXXXX],[USD])/([YYYYY],[Units]))/12),Missing)) to member Net_Sales_RPU (3322)
"RIF_RPU_Proxy" "Net_Sales_RPU" "+" "" "IIF(IS(Currencies.CurrentMember,[USD]),((([XXXXX],[USD])/([YYYYYY],[Units]))/12),Missing)" "2" "" "" "" "" "" "" "" "" "" "" "" "" "" "
The outline looks like this