on 2017 Jan 10 6:50 PM
Hi,
Is there any possibility to default to one dimension member in "Clear" DMP?
Eg:We have 3 dimension members for one dimension i.e., Unconverted,CDE,USE.
Users should be able to clear only Unconverted.
I want to default this dimension member to "Unconverted" in clear DMP.
Thanks,
Manohar
N.B:We are on SAPKW73015,SAPK-80021INCPMBPC and EPM is SP25.
Request clarification before answering.
Easy, just edit the advanced script of CLEAR DM package!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Like here:
PROMPT(SELECTINPUT,%SELECTION%,,"Select the members to CLEAR","List here dimension names not including the dimension with Unconverted CDE USE",0)
PROMPT(RADIOBUTTON,%ENABLETASK%,"Do you want to clear comments associated with the data region?",1,{"Yes","No"},{"1","0"})
PROMPT(RADIOBUTTON,%CHECKLCK%,"Do you want to check Work Status when clearing?",1,{"Yes, delete comments with work status settings","No, do not delete comments with work status settings"},{"1","0"})
PROMPT(RADIOBUTTON,%CHECKJOUR%,"Exit the package if journal data encountered (no change will be committed)?",0,{"Yes","No"},{"1","0"})
INFO(%SELECTION_KEYDATE%,)
TASK(/CPMB/CLEAR_CUBE,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/CLEAR_CUBE,SELECTION,%SELECTION%|DIMENSION:DIMNAME|Unconverted|)
TASK(/CPMB/CLEAR_CUBE,DUMPLOADMODE,3)
TASK(/CPMB/CLEAR_CUBE,KEYDATE,%SELECTION_KEYDATE%)
TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,SELECTION,%SELECTION%|DIMENSION:DIMNAME|Unconverted|)
TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,ENABLETASK,%ENABLETASK%)
TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,CHECKLCK,%CHECKLCK%)
TASK(/CPMB/CLEAR_COMMENTS_FOR_CLEAR,CHECKJOUR,%CHECKJOUR%)
Do we need to give the value in "SELECTINPUT" prompt?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
12 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.