Hyperion Essbase (MOSC)

MOSC Banner

Cannot assign [DOUBLE] objects of different length

Below is my script which will assign Depreciation Values from one year to another


FIX ("OEP_Plan",{Version}, @RELATIVE("All Cost Center", 0), @RELATIVE("All Operating Unit", 0), @RELATIVE("All Product", 0),"BegBalance",

@Relative("YearTotal",0 ),"Ent_301","ComputersNone","OfficeEquipmentNone","FurnitureNone","LeaseholdNone","ComputerSoftwareNone",/*@like("AS\_","Asset Detail")*//*@match("Asset Detail","AS_")*/@RELATIVE("OCX_Total Major Assets",0)/*"ComputersNone","AS_1000039"*/,"USD")

FIX("No Year","BegBalance")

"TP_ServiceDate" = @INT(("No Year"->"BegBalance"->"In Service Date" / 100) * 100)/10000;

ENDFIX

  "OCX_Depreciation"(

  @MEMBER( @CONCATENATE("FY", @SUBSTRING ( @CalcMgrIntegerToString ("TP_ServiceDate"->"No Year"->"BegBalance"),2)))->"OCX_Depreciation" = "FY22"->"OCX_Depreciation";

  @MEMBER(@NEXTSIBLING (@MEMBER( @CONCATENATE("FY", @SUBSTRING ( @CalcMgrIntegerToString ("TP_ServiceDate"->"No Year"->"BegBalance"),2 )))))->"OCX_Depreciation" = "FY23"->"OCX_Depreciation";

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center