Hi there,
I want to make a custom clear package with specific dimension members.
When user run it, there should be no promt and all dimensions are hardcoded.
I want to set values to:
Category: Forecast
Time: FY11.M1,Fy11.M2
Entity: All
AuditID : Adjustment
......
Below is the standard clear package. How can I pass the fixed dimension member values to ,%SELECTION%?
Would appreciate if you can change the following code to show an example.
-
'DEBUG(ON)
PROMPT(SELECTINPUT,%SELECTION%,,"Select the members to CLEAR",%DIMS%)
u2018PROMPT(RADIOBUTTON,%ENABLETASK%,"Do you want to clear comments associated with data regions in BPC?",1,{"Yes","No"},{"1","0"})
'PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when deleting comments.",1,{"Yes, delete comments with work status settings","No, do no delete comments with work status settings"},{"1","0"})
INFO(%TEMPFILE%,%TEMPPATH%%RANDOMFILE%)
TASK(EXPORT_ZERO,APPSET,%APPSET%)
TASK(EXPORT_ZERO,APP,%APP%)
TASK(EXPORT_ZERO,USER,%USER%)
TASK(EXPORT_ZERO,FILE,%TEMPFILE%)
TASK(EXPORT_ZERO,SQL,%SQLDUMP%)
TASK(EXPORT_ZERO,DATATRANSFERMODE,2)
TASK(LOAD CUBE,APPSET,%APPSET%)
TASK(LOAD CUBE,APP,%APP%)
TASK(LOAD CUBE,USER,%USER%)
TASK(LOAD CUBE,FILE,%TEMPFILE%)
TASK(LOAD CUBE,DATATRANSFERMODE,4)
TASK(LOAD CUBE,DMMCOPY,0)
TASK(LOAD CUBE,PKGTYPE,0)
TASK(LOAD CUBE,CHECKLCK,1)
TASK(CLEAR COMMENTS,APPSET,%APPSET%)
TASK(CLEAR COMMENTS,APP,%APP%)
TASK(CLEAR COMMENTS,USER,%USER%)
TASK(CLEAR COMMENTS,DATATRANSFERMODE,0)
TASK(CLEAR COMMENTS,SELECTIONORFILE,%TEMPFILE%)
TASK(CLEAR COMMENTS,ENABLETASK,1
TASK(CLEAR COMMENTS,CHECKLCK,1)
BEGININFO(%SQLDUMP%)