Update the dimension member in a transactional record in model

[saikhancs35]

Hello,

I have a requirement to update the dimension member of a particular row in the transactional data of a model.

For example, i have below transactional data in a model:

Dim A	Dim B	Dim C	Amount
#	BT01	DI111	12345
#	BT02	DI111	34567

And i want update record like this:

Dim A	Dim B	Dim C	Amount
MD01	BT01	DI111	12345
MD01	BT02	DI111	34567

Is it possible to achieve this?

Thanks

[ThomasK]

Hi @saikhancs35 ,

using advanced formulas it could look like this.

Regards,

Thomas

PS: Cloud also be solve with a data action copy step and a delete statment in a following visual advanced formula step.

VARIABLEMEMBER #T1 OF [d/Version]

DATA([d/Version] = #T1, [d/DimA] = "MD01") = RESULTLOOKUP()
DELETE()
DATA() = RESULTLOOKUP([d/Version] = #T1)

[Ivan_Camac]

This is the best solution and it is what we use for the exact same situation.

Data actions do not currently have a native ‘Update’ or ‘Overwrite’ functionality.

The other benefit of using the Version Variable member approach is that when debugging/tracing the advanced formula step, you can easily preview exactly what data is being created.

Cheers, Ivan.

[N1kh1l]

@saikhancs35 

Not sure but I think you have over simplified your example. From your example it just looks like a copy from # to MD01 for Dim A. You could just use a copy data action to do so and specify in the rule. You can delete the # data after copy if required.

Nikhil