cancel
Showing results for 
Search instead for 
Did you mean: 

How to modify copy transaction data DM package??

wasem_hassan
Participant
0 Kudos

Dear Folk,

I am using Data manager package for copy transaction data (Process chain name = /CPMB/COPY) .Here i can select base member one by one but i have to requirement when i select i.e  2017.01 Time and destination  should be come up Year 2018. Means all 21.01 data would be copy in year 2018.

But in destination i cannot see the parent level copy only can see base level (2017.01,2017.02,etc).

So, how could i modified Pls advice me .

Regards,

Wasem

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Sorry, but "Means all 21.01 data would be copy in year 2018." - not clear! What is the required source and target?

former_member186338
Active Contributor
0 Kudos

You want to copy 2017.01 data to all months of 2018? Or?

wasem_hassan
Participant
0 Kudos

Hi vadim ,

Thanks for your response,

I want to copy 2017.01 data to all month of 2018 year.

Means Source is 2017.01 and Target would be Year 2018. So can achieve this requirement.

Regards,

Wasem Hassan

wasem_hassan
Participant
0 Kudos

Hi Vadim,

whenever i have been selected multiple values in destination like,2018.01,2018.02,2018.03...etc so am getting error

How to make multiple selection and hierarchy level (Year 2018).So , it will copy all data in year 2018.

Pls advice me .

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

Sorry, but you can't copy to the parent And standard copy package will not allow to copy from one to many.

Instead of standard copy you have to use script logic with allocation like:

*RUNALLOCATION

*FACTOR =1

*DIM TIME WHAT=2017.01; WHERE=BAS(2018.TOTAL)

*ENDALLOCATION

wasem_hassan
Participant
0 Kudos

Thanks vadim,

am going to try if i will get any issue i will let you know.

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

Just test in UJKT!

wasem_hassan
Participant
0 Kudos

Thnaks vadim,

Which process chain can i use for running package means default_formula or allocation?

Pls let me know

Regards

Wasem

former_member186338
Active Contributor
0 Kudos

Default formulas or Allocation! Actually it's the same chain...

wasem_hassan
Participant
0 Kudos

Thanks Vadim.

former_member186338
Active Contributor
0 Kudos

In both cases you will have to edit DM advanced script to provide prompts to select members.

What do you want to ask user?

wasem_hassan
Participant
0 Kudos

Hello Vadim,

After written below this script.

*XDIM_MEMBERSET  CATEGORY = BUDGET

*RUNALLOCATION

*FACTOR =1

*DIM TIME WHAT=2017.01; WHERE=BAS(2018.TOTAL)

*ENDALLOCATION

*COMMIT

Now i am using pc for  default_formula. as below codes are

When i run am getting fail package

Could you please advice me where i did mistake.

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

SELECTINPUT syntax is incorrect, has to be:

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%TIME_DIM%")

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,Allocation.LGF)

Single "," between %CATEGORY_DIM% and %TIME_DIM%

Also remove useless COMMIT from script and answer my question:

"What do you want to ask user?"

wasem_hassan
Participant
0 Kudos

Hi Vadim ,

Thanks for your response,

I want to ask user give input time lets example User give Input time = 2017.01 or any time and destination Time = Year 2018 So, data will  copy in all month for year 2018. So could be i do.

Waiting for response

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

I recommend you to select the source month in:

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%TIME_DIM%")

And target in COMBOBOX like:

PROMPT(COMBOBOX,%TARGET%,"Select Target Year",1,2017.TOTAL,{2017.TOTAL,2018.TOTAL,2019.TOTAL,2020.TOTAL,2021.TOTAL})

It's a fixed list but you can add enough years!

Then the advanced script will be:

PROMPT(SELECTINPUT,%SELECTION%,,"Select Source Category and Time Period","%CATEGORY_DIM%,%TIME_DIM%")

PROMPT(COMBOBOX,%TARGET%,"Select Target Year",1,2017.TOTAL,{2017.TOTAL,2018.TOTAL,2019.TOTAL,2020.TOTAL,2021.TOTAL})

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,TARGET%EQU%%TARGET%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,Allocation.LGF)

And the script will be:

*XDIM_MEMBERSET  CATEGORY = %CATEGORY_SET%

*RUNALLOCATION

*FACTOR =1

*DIM TIME WHAT=%TIME_SET%; WHERE=BAS($TARGET$)

*ENDALLOCATION

Vadim

wasem_hassan
Participant
0 Kudos

Thanks Vadim For your swift Reply,

Am working on given input from your side.

Regards,

Wasem

wasem_hassan
Participant
0 Kudos

Hi Vadim,

Am getting failed in my data manger package.

and below syntax are:

PROMPT(SELECTINPUT,%SELECTION%,,"Select Source Category and Time Period","%CATEGORY_DIM%,%TIME_DIM%")

PROMPT(COMBOBOX,%TARGET%,"Select Target Year",1,

{2012.TOTAL,2013.TOTAL,2014.TOTAL,2015.TOTAL,2016.TOTAL,2017.TOAL,2018.TOTAL,2019.TOTAL})

INFO(%EQU%,=)

INFO(%TAB%,;)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,EQU,%EQU%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,TAB,%TAB%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SUSER,%USER%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPPSET,%APPSET%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SAPP,%APP%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,ALLOCATION.LGF)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,TARGET%EQU%%TARGET%)

and my script are :

Could you  pls  advice me where i did mistake .

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

What chain you used? Has to be for this script:

And show the screenshot of the advanced script!

former_member186338
Active Contributor
0 Kudos

And by the way, the syntax of COMBOBOX line is incorrect! in my sample the default value was included:

PROMPT(COMBOBOX,%TARGET%,"Select Target Year",1,2017.TOTAL,{2017.TOTAL,2018.TOTAL,2019.TOTAL,2020.TOTAL,2021.TOTAL})

In your - nothing:

PROMPT(COMBOBOX,%TARGET%,"Select Target Year",1,{2012.TOTAL,2013.TOTAL,2014.TOTAL,2015.TOTAL,2016.TOTAL,2017.TOAL,2018.TOTAL,2019.TOTAL})

Has to be at least:

PROMPT(COMBOBOX,%TARGET%,"Select Target Year",1,,{2012.TOTAL,2013.TOTAL,2014.TOTAL,2015.TOTAL,2016.TOTAL,2017.TOAL,2018.TOTAL,2019.TOTAL})

wasem_hassan
Participant
0 Kudos

Thanks Vadim,

i am using same pc default_formula, Lets again i am trying ig i got any issue let you know.

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

You have to be accurate with syntax! Please also read

wasem_hassan
Participant
0 Kudos

Hi Vadim,

Thanks for your good information.

This time am not getting failed data manger but it not store in back end.

So, could be store this values in Backend.

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

It means that you don't have data for the selected region. Please show the report with all dimension members visible for 2017.01!

P.S. Looks like none of my answers are helpful...

former_member186338
Active Contributor
0 Kudos

And add the line at the beginning of the script:

*XDIM_MEMBERSET RPT_CURRENCY=<ALL>

P.S. Read: http://service.sap.com/sap/support/notes/1971188

wasem_hassan
Participant
0 Kudos

Hi Vadim,

2017.01 data is there but its not copy to all data in 2019 year. Even i check in backend (BW system)

am not getting data for 2019 year. pls let me know how could i store data in backend (Model/Infocube).

Pls advice me

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

Read my post about currency!

wasem_hassan
Participant
0 Kudos

Thanks Vadim,

Now am going to try given ur logic.

Regards,

Wasem

former_member186338
Active Contributor
0 Kudos

It will result in something like:

LOG BEGIN TIME:2016-06-20 12:45:42

FILE:\ROOT\WEBFOLDERS\ENV2\ADMINAPP\PERIODPLAN\Allocation.LGF

USER:V.KALININ

APPSET:ENV2

APPLICATION:PERIODPLAN

FACTOR:1

ALLOCATION DATA REGION:

TIME:2016.01,

CATEGORY:Actual,

RPTCURRENCY:EUR,LC,USD,

TIME:WHAT:2016.01,WHERE:BAS(2017.TOTAL),USING:,TOTAL:

-----------------------------------------

--Read WHAT region

[TIME] =2016.01

[CATEGORY] =Actual

[RPTCURRENCY] =EUR,LC,USD

--Time to load WHAT :0.221469 second(s).

WHAT data:1  records.

-----------------------------------------

--Apply factor

WHERE=WHAT *1

--Time to apply factor :0.000599 second(s).

-----------------------------------------

--Read destination and calculate difference

[TIME] =2017.01,2017.02,2017.03,2017.04,2017.05,2017.06,2017.07,2017.08,2017.09,2017.10

--Time to read destination and calculate difference :0.145207 second(s).

-----------------------------------------

--Records succeeded to write back :12

--Records failed to write back

-----------------------------------------

--Time to run Allocation :0.664262 second(s).

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

LOG END TIME:2016-06-20 12:45:43

File path: \ROOT\WEBFOLDERS\ENV2\PERIODPLAN\PRIVATEPUBLICATIONS\V.KALININ\tempfiles\20160620124542\Allocation.LOG

wasem_hassan
Participant
0 Kudos

Thnaks Vadim,

Finaly i got the data. again Thank you very much

Regards,

Wasem

Answers (0)