Data Action - Place Dimension = # on the valid combination from booked data

[Freddie]

Hi all,

I have a uploaded data via a csv file on FUNC_AREA = "#" and PLANT = "#" on an upload version. The rest of the dimensions is placed on the correct members.

I need to transfer these numbers to an budget version, however it should post on the valid combination of the booked values of the uploaded values on dimensions on "#"

I have already transfered last years booked values ( thus on the correct combinations of dimension members).

CONFIG.HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY = [d/FUNC_AREA],[d/COST_CENTER],[d/PROFIT],[d/Plant],[d/GL_ACCOUNT]
// Scope
MEMBERSET [d/Date] = [d/Version].[p/From_Date] TO [d/Version].[p/To_Date]
MEMBERSET [d/Measures] = ("Amount_LC")

// Copy
IF RESULTLOOKUP([d/Version] = %SourceVersion%) > 0 then 
	FOREACH.BOOKED [d/FUNC_AREA], [d/Plant]
		DATA () = RESULTLOOKUP([d/Version]= %SourceVersion%, [d/FUNC_AREA] = "#", [d/Plant] = "#")
	ENDFOR
ENDIF

It works with if I use the FOREACH statement without the IF statement, however the performance is too bad, as there are many members.

I tried with the IF statement to only loop over the uploaded members of ([d/FUNC_AREA],[d/COST_CENTER],[d/PROFIT],[d/Plant],[d/GL_ACCOUNT]) but 0 values is returned.

Anyone has any ideas?

[William_Yu1 · Accepted solution]

Maybe you can try below statement without FOR loop( I haven't tested though):

DATA () = RESULTLOOKUP([d/Version]= %SourceVersion%, [d/FUNC_AREA] = "#", [d/Plant] = "#")
          *RESULTLOOKUP()/RESULTLOOKUP()

[Freddie · Accepted solution]

Hi William_Yu! It worked by multiplying with ((RESULTLOOKUP()/RESULTLOOKUP())+1). Thanks!