Data copy from new model to old model

[pranavvyas01]

Hi Team,

I have a requirement where data needs to be copied to old model for Geo Maps. We are doing this using Advanced scripts using link function. When we try to copy the data from new model to old model, i am able to map only 1 dimension with new model and when i try to add few more like account = newmodel.account.ID then it throws me error "There is violation of scope redirection in the calculation expressions". Is it that Link functionality allows only for 1 mapping. How can i copy data for other dimensions.

Thanks & Regards,

Pranav Vyas

[William_Yu]

Hi pranavvyas01,

With my experience, LINK formula definitely support mapping for multiple dimensions.

Just check below example from help page, I believe your error is not because of using more than one dimension, but due to other reasons.

MEMBERSET [d/Account] = "JetOilPrice"
MEMBERSET [d/Time] = [d/Version].[p/PlanFromDate] to [d/Version].[p/PlanToDate]
MEMBERSET [d/DataSrc] = "Input"

FOREACH [d/Time]
//first use the LINK function to calculate the indicator of each month by dividing the estimated jet oil price of Singapore Airline by the actual price, then multiple it by the actual oil price of each airport in May.
                         DATA() = RESULTLOOKUP([d/Time] = "201805", [d/Version] = "public.Actual")
                                        * LINK([Airline_Indicator_AF] ,[d/Version] = "public.Plan201806", [d/Account] = "Singapore-Jet Oil Price" )
                                         / LINK([Airline_Indicator_AF] ,[d/Version] = "public.Actual", [d/Account] = " Singapore-Jet Oil Price ", [d/Time] = "201805" )<br>

Best regards, William

[pranavvyas01]

Hi William,

In the example shared, there is no mapping of dimensions what i am looking for. Also, as soon as i add a new mapping then above error is displayed otherwise validation is successful without any errors.

Thanks & Regards,

Pranav Vyas

[Jay_Gandhi]

Hi there,

Could you share your script example?

I believe we may be using the term mapping differently.

Please advise, thanks.

Jay

[pranavvyas01]

Hi Jay,

Please find below sample of the code:

DATA( [d/material]=%materialold%,[d/comp]= [New Model].[d/comp].[p/ID],[d/Account]=%AccountOld%)=LINK([New Model],[d/Version]=%VersionNew%,[d/material]=%materialNew%, [d/Account]=%AccountNew%)

Here in the above example, i have mapped on the left side: Comp (old model) = Comp (new model). Same thing i want to do it for material and Account but unable to do so and gives error as mentioned.

Thanks & Regards,

Pranav Vyas

[9160ruby]

Hi Pranav , i hope you got an answer to your query , if so i am facing the exact same problem. Can you help me with that