Skip to Content
0
Former Member
Jan 19, 2012 at 10:37 AM

Run Clear Data Package with specific dimension members

318 Views

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%)