cancel
Showing results for 
Search instead for 
Did you mean: 

Importing Multiple Categories and Running Default Script

former_member234894
Participant
0 Kudos

Hi Experts

I’d like to modify our existing Default logic to allow for the import of multiple categories from a cube in one import.

I know there’s a limitation as noted in the note: http://service.sap.com/sap/support/notes/1498049

That limits account transformation (ABC) to one category.

Is this still the case?  We are using BPC NW 10.1 SP09 on BW7.4  This note is from 12/8/2010. 

One alternative is to run the import one category at a time.

Any other ideas?

The main part of the default script is below – green notes where we attempted to shift from the stand-alone Category to part of the OTHER statement.

Issue I’m encountering is that even when running the import for one Category the default script updates other categories e.g. import ESTIMATE data the default script runs for ACTUAL…

Thank you.

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

CURRENCY = LC,USD,EUR

TID_RA = %TIME_SET%

CALC = NETINCOMESPLIT2

//OTHER = [CATEGORY = %CATEGORY_SET%;ENTITY = %ENTITY_SET%;INTERCO = %INTERCO_SET%;BANK = %BANK_SET%;TC = %TC_SET%;COST_CENTER = %COST_CENTER_SET%;ACTIVITY = %ACTIVITY_SET%;SUBGLOBALRGN = %SUBGLOBALRGN_SET%;ACTIVE_INGREDIEN = %ACTIVE_INGREDIEN_SET%;COUNTRY = %COUNTRY_SET%]

*ENDRUN_PROGRAM

*COMMIT

//-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

// Calculating F15 - net variation as the difference between closing and the sum of other balance sheet flows

//-------------------------------------------------------------------------------------------------------------------------------------------------------------------------

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

CURRENCY = LC,USD,EUR

TID_RA = %TIME_SET%

//OTHER = [CATEGORY = %CATEGORY_SET%;ENTITY = %ENTITY_SET%;INTERCO = %INTERCO_SET%;BANK = %BANK_SET%;TC = %TC_SET%;COST_CENTER = %COST_CENTER_SET%;ACTIVITY = %ACTIVITY_SET%;SUBGLOBALRGN = %SUBGLOBALRGN_SET%;ACTIVE_INGREDIEN = %ACTIVE_INGREDIEN_SET%;COUNTRY = %COUNTRY_SET%]

// MODIFICATION DEV - FOR MULTIPLE CATEGORY IMPORT

//OTHER = [CATEGORY = %CATEGORY_SET%;ENTITY = %ENTITY_SET%;INTERCO = %INTERCO_SET%]

CALC = TBS

*ENDRUN_PROGRAM*ENDRUN_PROGRAM

Regards,

Eyal

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

You can always:

*FOR %C%=%CATEGORY_SET%

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY=%C%

...

*ENDRUN_PROGRAM

*NEXT


Don't use useless COMMIT


Vadim


Is it related to your question:

former_member186338
Active Contributor
0 Kudos

P.S. You can't put CATEGORY to OTHER...

former_member234894
Participant
0 Kudos

Hi Vadim,

Thanks for the suggestion.

I modified the script and tested- it didn't work.  So I will go with importing one category at a time.

The Script and the import failure message are below:

*FOR %CAT%=%CATEGORY_SET%

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

CURRENCY = LC,USD,EUR

TID_RA = %TIME_SET%

CALC = NETINCOMESPLIT2

*ENDRUN_PROGRAM

*NEXT

*FOR %CAT%=%CATEGORY_SET%

*RUN_PROGRAM CALC_ACCOUNT

CATEGORY = %CATEGORY_SET%

CURRENCY = LC,USD,EUR

TID_RA = %TIME_SET%

CALC = TBS

*ENDRUN_PROGRAM

*NEXT

DM Error Message

Task name LOAD:

Suppressed zero-value records: 102

Replace and Clear Submit count: 274

Replace and Clear Reject count: 0

Error running default logic ()

Value EST1,EST2 in some formulas of elimination CATEGORY is not a base level member

Aggregate count: 1

Submit count: 43

Reject count: 0

former_member234894
Participant
0 Kudos

Ok Disregard.

It's working!

I'm performing some more verification tests but looks good.

Thanks

Eyal

former_member186338
Active Contributor
0 Kudos

Your error was here:

  CATEGORY = %CATEGORY_SET%

Has to be

CATEGORY = %CAT%

Vadim

former_member234894
Participant
0 Kudos

Exactly thank you.

Eyal

former_member234894
Participant
0 Kudos

Hi Vadim,

As I noted, the default script modification above allows for all categories to be imported in one go.

I'd like to narrow down the query further and select by Entity, TIME range, and now category or category range e.g. EST1 - EST3.

I modifed the DM script below - changes marked in yellow.  The script still imports all the categories in the cube.  I ran without using the default script so the issue is with an error below. 

I took the category INFO details from the log of the original Data Manager import filter, also below.

What is incorrect?

2) If I wanted to hard code the category, what is the syntax? in the INFO %5% just add the value range?

Thank you.

Eyal

DATA MANGER SCRIPT

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

PROMPT(TEXT,%ENT%, "Enter the Entity", ,)

PROMPT(TEXT,%YR_MO_1%, "Enter the starting year and mo format: YYYY.MM", ,)

PROMPT(TEXT,%YR_MO_2%, "Enter the Ending range year and mo format: YYYY.MM", ,)

PROMPT(TEXT,%CATEG%, "Enter the Category", ,)

INFO(%S1%,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection"><Attribute><ID>GF_ENT_S</ID><Operator>1</Operator><LowValue>)

INFO(%S2%,</LowValue><HighValue /></Attribute><Attribute><ID>GF_TIME_S</ID><Operator>3</Operator><LowValue>)

INFO(%S3%,</LowValue><HighValue>)

INFO(%S4%,</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>0CALMONTH</FieldID><FieldID>0CHNGID</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>GF_ACC_S</FieldID><FieldID>GF_ACC_S__GF_EX_C1</FieldID><FieldID>GF_ACTV_S</FieldID><FieldID>GF_AI_S</FieldID><FieldID>GF_AUDT_S</FieldID><FieldID>GF_BNK_S</FieldID><FieldID>GF_CC_S</FieldID><FieldID>GF_CNTR_S</FieldID><FieldID>GF_CTEG_S</FieldID><FieldID>GF_CUR_S</FieldID><FieldID>GF_ENT_S</FieldID><FieldID>GF_ENT_S__GF_EX_C2</FieldID><FieldID>GF_FLG01</FieldID><FieldID>GF_FLG02</FieldID><FieldID>GF_FLOW_S</FieldID><FieldID>GF_ICO_S</FieldID><FieldID>GF_LDAT</FieldID><FieldID>GF_LDUSR</FieldID><FieldID>GF_LTIM</FieldID><FieldID>GF_PRD_S</FieldID><FieldID>GF_SCOP_S</FieldID><FieldID>GF_SGR_S</FieldID><FieldID>GF_SOURCE</FieldID><FieldID>GF_TC_S</FieldID><FieldID>GF_TIME_S</FieldID></Selection></Selections>

' Add CATEGORY Filter

INFO(%S5%,</LowValue><HighValue /></Attribute><Attribute><ID>GF_CTEG_S</ID><Operator>3</Operator><LowValue>)

' Alternate - ??

'INFO(%S5%,<Attribute><ID>GF_CTEG_S</ID><Operator>1</Operator><LowValue>GF_CTEG_S</LowValue><HighValue />)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\MAI_CONSO\Consolidation\DATAMANAGER\TRANSFORMATIONFILES\EXAMPLES\MA\T_FILE_BW_IPROVIDER.XLS)

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

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,GFC_TB53)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%S1%%ENT%%S2%%YR_MO_1%%S3%%YR_MO_2%%S4%,%S5%,%CATEG%, )

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,2)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,1)

TASK(/CPMB/LOAD_IP,CHECKLCK,1)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

FROM DM EXECUTION  LOG

<Attribute><ID>GF_CTEG_S</ID><Operator>1</Operator><LowValue>ACTUAL</LowValue><HighValue />

<Attribute><ID>GF_CTEG_S</ID><Operator>1</Operator><LowValue>GF_CTEG_S</LowValue><HighValue />

former_member186338
Active Contributor
0 Kudos

"changes marked in yellow" - nothing in yellow

The rest is not clear:

Do you want to limit selection from infoprovider? Then I do not see any variables inside xml selection...

former_member186338
Active Contributor
0 Kudos

P.S. You can't pass any parameters to default.lgf from advanced DM script of infoprovider loading. The default.lgf will get a scope of uploaded data!

former_member186338
Active Contributor
0 Kudos

Ups sorry, just found everything!

For category restriction - just run the standard package and look for the syntax!

P.S. %S5% is located in the wrong place of xml...

former_member186338
Active Contributor
0 Kudos

Just performed some tests:

"now category or category range e.g. EST1 - EST3."

There is no easy way to combine single category selection and range category selection!

For single selection the string will be like (look on <HighValue />😞

<Attribute><ID>/CPMB/QDD88BR</ID><Operator>1</Operator><LowValue>Actual</LowValue><HighValue /></Attribute>

For range:

<Attribute><ID>/CPMB/QDD88BR</ID><Operator>3</Operator><LowValue>Actual</LowValue><HighValue>Budget</HighValue></Attribute>

If you have 2 variables: %CATLO% and %CATHI%

"><Attribute><ID>/CPMB/QDD88BR</ID><Operator>3</Operator><LowValue>%CATLO%</LowValue><HighValue>%CATHI%</HighValue></Attribute>

Then to have single selection you have to select the same member for both:

%CATLO%=Actual

%CATHI%=Actual

Empty %CATHI% will result in zero records.

Vadim

P.S. And xml string has to be constructed the same way as for unmodified package!

former_member186338
Active Contributor
0 Kudos

Sample:

PROMPT(TEXT,%CATLO%, "Enter the Category From", ,)

PROMPT(TEXT,%CATHI%, "Enter the Category To", ,)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%KEYDATE%,)

INFO(%S1%,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection"><Attribute><ID>/CPMB/QDD88BR</ID><Operator>3</Operator><LowValue>)

INFO(%S2%,</LowValue><HighValue>)

INFO(%S3%,</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>/CPMB/QDD0NNQ</FieldID><FieldID>/CPMB/QDD6KG0</FieldID><FieldID>/CPMB/QDD88BR</FieldID><FieldID>/CPMB/QDD9MSV</FieldID><FieldID>/CPMB/QDDIKR1</FieldID><FieldID>/CPMB/QDDO7RJ</FieldID><FieldID>/CPMB/QDDXC6C</FieldID></Selection></Selections>)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\ENV2\PERIODPLAN\DATAMANAGER\TRANSFORMATIONFILES\trEnv12.xls)

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

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,/CPMB/QDIFH0D)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%S1%%CATLO%%S2%%CATHI%%S3%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,1)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,0)

TASK(/CPMB/LOAD_IP,CHECKLCK,0)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

former_member234894
Participant
0 Kudos

Hi Vadim,

Let's focus on the category range selection:

A) I modified the script as below.  Still not selecting the category.

Added the ranges CATLO and CATHI.  In my example, already have the TIME range, so now adding CATEGORY range.

B) The original import syntax for category is as:

<Selection Type="Selection"><Attribute><ID>GF_CTEG_S</ID><Operator>1</Operator><LowValue>EACTUAL</LowValue><HighValue />

Where should this be inserted in the script below?  S2 and S3 are for TIME??

C)* "S5%  in located in the wrong place of xml".  What do you mean?  Added a new S5 for the Category.  If we have a range I would think we need S6 too?

Can you correct the Data Manager script below?

Thanks

Eyal

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

PROMPT(TEXT,%ENT%, "Enter the Entity", ,)

PROMPT(TEXT,%YR_MO_1%, "Enter the starting year and mo format: YYYY.MM", ,)

PROMPT(TEXT,%YR_MO_2%, "Enter the Ending range year and mo format: YYYY.MM", ,)

PROMPT(TEXT,%CATLO%, "Enter the Category From", ,)

PROMPT(TEXT,%CATHI%, "Enter the Category To", ,)

INFO(%S1%,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection"><Attribute><ID>GF_ENT_S</ID><Operator>1</Operator><LowValue>)

INFO(%S2%,</LowValue><HighValue /></Attribute><Attribute><ID>GF_TIME_S</ID><Operator>3</Operator><LowValue>)

INFO(%S3%,</LowValue><HighValue>)

INFO(%S4%,</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>0CALMONTH</FieldID><FieldID>0CHNGID</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>GF_ACC_S</FieldID><FieldID>GF_ACC_S__GF_EX_C1</FieldID><FieldID>GF_ACTV_S</FieldID><FieldID>GF_AI_S</FieldID><FieldID>GF_AUDT_S</FieldID><FieldID>GF_BNK_S</FieldID><FieldID>GF_CC_S</FieldID><FieldID>GF_CNTR_S</FieldID><FieldID>GF_CTEG_S</FieldID><FieldID>GF_CUR_S</FieldID><FieldID>GF_ENT_S</FieldID><FieldID>GF_ENT_S__GF_EX_C2</FieldID><FieldID>GF_FLG01</FieldID><FieldID>GF_FLG02</FieldID><FieldID>GF_FLOW_S</FieldID><FieldID>GF_ICO_S</FieldID><FieldID>GF_LDAT</FieldID><FieldID>GF_LDUSR</FieldID><FieldID>GF_LTIM</FieldID><FieldID>GF_PRD_S</FieldID><FieldID>GF_SCOP_S</FieldID><FieldID>GF_SGR_S</FieldID><FieldID>GF_SOURCE</FieldID><FieldID>GF_TC_S</FieldID><FieldID>GF_TIME_S</FieldID></Selection></Selections>

' Add CATEGORY range filter

INFO(%S5%,<Attribute><ID>GF_CTEG_S</ID><Operator>4</Operator><LowValue>GF_CTEG_S</LowValue><HighValue />)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\MAI_CONSO\Consolidation\DATAMANAGER\TRANSFORMATIONFILES\EXAMPLES\MA\T_FILE_BW_IPROVIDER.XLS)

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

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,GFC_TB53)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%S1%%ENT%%S2%%YR_MO_1%%S3%%YR_MO_2%%S4%,%S5%%CATLO%%S6%%CATHI% )

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,2)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,1)

TASK(/CPMB/LOAD_IP,CHECKLCK,1)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

FROM DM EXECUTION  LOG

xml selection

<Selection Type="Selection"><Attribute><ID>GF_CTEG_S</ID><Operator>1</Operator><LowValue>EACTUAL</LowValue><HighValue />

<Attribute><ID>GF_CTEG_S</ID><Operator>1</Operator><LowValue>ACTUAL</LowValue><HighValue />

<Attribute><ID>GF_CTEG_S</ID><Operator>1</Operator><LowValue>GF_CTEG_S</LowValue><HighValue />

<FieldID>GF_CTEG_S</FieldID>

<FieldID>GF_CTEG_S</FieldID>

former_member186338
Active Contributor
0 Kudos

Sorry, can you read my previous answer once again?

The resulting xml format of:

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%S1%%ENT%%S2%%YR_MO_1%%S3%%YR_MO_2%%S4%,%S5%%CATLO%%S6%%CATHI% )

is ABSOLUTELY incorrect!

Start from standard DM package, select infoprovider, set selection for time an category (both from to) and you will get a full correct string (in view status).

Then split this string like I have done in prev answer.

Vadim

former_member186338
Active Contributor
0 Kudos

Something like this will be correct in your case:

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

PROMPT(TEXT,%ENT%, "Enter the Entity", ,)

PROMPT(TEXT,%YR_MO_1%, "Enter the starting year and mo format: YYYY.MM", ,)

PROMPT(TEXT,%YR_MO_2%, "Enter the Ending range year and mo format: YYYY.MM", ,)

PROMPT(TEXT,%CATLO%, "Enter the Category From", ,)

PROMPT(TEXT,%CATHI%, "Enter the Category To", ,)

INFO(%S1%,<?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection"><Attribute><ID>GF_ENT_S</ID><Operator>1</Operator><LowValue>)

INFO(%S2%,</LowValue><HighValue /></Attribute><Attribute><ID>GF_TIME_S</ID><Operator>3</Operator><LowValue>)

INFO(%S3%,</LowValue><HighValue>)

INFO(%S4%,</HighValue></Attribute><Attribute><ID>GF_CTEG_S</ID><Operator>3</Operator><LowValue>)

INFO(%S5%,</LowValue><HighValue>)

INFO(%S6%,</HighValue></Attribute></Selection><Selection Type="FieldList"><FieldID>0CALMONTH</FieldID><FieldID>0CHNGID</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>GF_ACC_S</FieldID><FieldID>GF_ACC_S__GF_EX_C1</FieldID><FieldID>GF_ACTV_S</FieldID><FieldID>GF_AI_S</FieldID><FieldID>GF_AUDT_S</FieldID><FieldID>GF_BNK_S</FieldID><FieldID>GF_CC_S</FieldID><FieldID>GF_CNTR_S</FieldID><FieldID>GF_CTEG_S</FieldID><FieldID>GF_CUR_S</FieldID><FieldID>GF_ENT_S</FieldID><FieldID>GF_ENT_S__GF_EX_C2</FieldID><FieldID>GF_FLG01</FieldID><FieldID>GF_FLG02</FieldID><FieldID>GF_FLOW_S</FieldID><FieldID>GF_ICO_S</FieldID><FieldID>GF_LDAT</FieldID><FieldID>GF_LDUSR</FieldID><FieldID>GF_LTIM</FieldID><FieldID>GF_PRD_S</FieldID><FieldID>GF_SCOP_S</FieldID><FieldID>GF_SGR_S</FieldID><FieldID>GF_SOURCE</FieldID><FieldID>GF_TC_S</FieldID><FieldID>GF_TIME_S</FieldID></Selection></Selections>)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,\ROOT\WEBFOLDERS\MAI_CONSO\Consolidation\DATAMANAGER\TRANSFORMATIONFILES\EXAMPLES\MA\T_FILE_BW_IPROVIDER.XLS)

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

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,GFC_TB53)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%S1%%ENT%%S2%%YR_MO_1%%S3%%YR_MO_2%%S4%%CATLO%%S5%%CATHI%%S6%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,2)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,1)

TASK(/CPMB/LOAD_IP,CHECKLCK,1)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

Vadim

Answers (0)