cancel
Showing results for 
Search instead for 
Did you mean: 

How to consider multiple months in logic script

0 Kudos

Hello,

i have requirement to transfer data from two source accounts to one target account. this transfer has to be done based on multiple months from time dimension. i am able to transfer from one month(AM*, not from PM*) to target. how to select multiple months at time and transfer data from one account to another account. Please guide me how to achieve this requirement using logic script. i collected AM1 and PM1 into variable but it is not working for PM1.

Ex. Account 1 (Target) = Src Acc 1 (Based on AM1) + Src Acc 1 (Based on AM2) + Src Acc 1 (Based on AM3)

+ Tgt Acc 1 (Based on AM1) + Tgt Acc 1 (Based on AM2) + Tgt Acc 1 (Based on AM3)

Account 1 (Target) = Src Acc 1 (Based on PM1) + Src Acc 1 (Based on PM2) + Src Acc 1 (Based on PM3)

+ Tgt Acc 1 (Based on PM1) + Tgt Acc 1 (Based on PM2) + Tgt Acc 1 (Based on PM3)

*SELECT(%ACT_MONTHS%,"[ID]","TIME","[MONTH]=AM01,PM01)

Here AM1,AM2 and AM3 are members of the month property in the time dimension.

former_member186338
Active Contributor
0 Kudos

Sorry, but absolutely not clear!

Post Excel screenshot what - to be saved!

Accepted Solutions (0)

Answers (0)