I am trying to copy the dense dimension dynamic member value to dense dimension store member but it does not work as I want to be. Here is the detail. Any help is really appreciated
Account and Period are dense dimension. Rest of the dimensions are sparse
Account has few members only. Following members are set in Account dimension
Total Budget Cost (It is the dynamic member which has few child's)
Total Actual Cost (It is the dynamic member which has few child's)
Total Cost (This is the stored member and where I want to copy the Total Budget Cost and Total Actual Cost). Rest of my calculation and variances will use the Total Cost
Here is the piece of code which is working. This code is working if I hard code the Project, Cost Center and Entity dimension in fix and also set the SET CREATENONMISSINGBLK ON
SET CREATENONMISSINGBLK ON;
FIX ("Actual","Final","FY16","10978-Project", "141 cost center", "Jun", "No Asset", "No Asset Class", "01_0201001_entity")
"Total Cost" = Total Actual Cost;
ENDFIX
If I change the fix statement then code running for hours and does not finishing (Project has 2400 members, Entity has 240 members and CRC has 100 members).
SET CREATENONMISSINGBLK ON;
FIX ("Actual","Final","FY16",@RELATIVE("Project",0),@RELATIVE("Cost Recovery Center",0), "Jun", "No Asset", "No Asset Class", @RELATIVE("Company 01",0))
"Total Cost" = Total Actual Cost;
ENDFIX
I also tried the following code and that does not work. It's been running for hours and then I have to kill the process
SET CREATENONMISSINGBLK ON;
FIX ("Actual","Total Cost","FY16",@RELATIVE("Project",0),@RELATIVE("Cost Recovery Center",0), "Jun", "No Asset", "No Asset Class", @RELATIVE("Company 01",0))
"Final" = "Final"->"Total Actual Cost;
ENDFIX
Any help is really appreciated