cancel
Showing results for 
Search instead for 
Did you mean: 

Passing prompt from data manager to script logic

Former Member
0 Kudos

Hi all,

I am not having luck passing prompt filters from my data package to BPC. We are using BPCNW 7.5 SP07

My script logic looks like:

*XDIM_MEMBERSET CATEGORY=%CATEGORY_SET%

*DESTINATION_APP=CONSOLIDATION

*SKIP_DIM = P_ACTIVITY, COST_OBJECT, PAR_COSTOBJECT

*RENAME_DIM P_ACCT=C_ACCT, CATEGORY=C_CATEGORY, P_DATASRC=C_DATASRC

*ADD_DIM GROUPS=NO_GROUP

*WHEN FLOW

*IS F_900

*REC(EXPRESSION=%VALUE%)

*ENDWHEN

And works fine in UJKT, when entering a data region of CATEGORY=020

My package script looks like:

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

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

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

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

TASK(/CPMB/ALLOCATION_LOGIC,LOGICFILENAME,SEND_TO_CONSOL.LGF)

When I run the BPC package it gives me a fail - and the following message

RUNLOGIC: Dimension set: u201CCATEGORYDATAVALUEu201D not assigned in data manager

Can anyone shed some light?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Try the logic given below:

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

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

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

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

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

TASK(/CPMB/ALLOCATION_LOGIC,LOGICFILENAME,SEND_TO_CONSOL.LGF)

Thanks

Former Member
0 Kudos

Thanks guys.. I believe that was exactly it.

Theres a bug where the selection statement does not automatically come into the package logic for the allocation process chain (note 1581841)

Will be testing it soon

vikrant_sharma18
Explorer
0 Kudos

Hi Linda ,

I hope U have tested the DMP .

I am a fresher to BPC , RightNow I am in a Situation where I need to perform.

1 . Running the DM thro' Macro Button.

2 . Setting the DM prompts Default as the Context selected in the I/P form.

former_member186338
Active Contributor
0 Kudos

Hi Vikrant,

Strange to post in 5 years old discussion. Please open a new one and describe you requirements. Also use search: DM with VBA etc... There are a lot of documents here!

Vadim

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

You need to include the Task for selection in your Data Manager Package

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

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

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

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

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

TASK(/CPMB/ALLOCATION_LOGIC,LOGICFILENAME,SEND_TO_CONSOL.LGF)

Thanks & Regards

Swathi Roy