Skip to Content
0
Former Member
Feb 16, 2010 at 10:58 AM

Does the clear package trigger the default logic?

17 Views

Hello Experts

Do you know if the standard clear package trigger the default logic?

Or do you know how to check that? I assume it is defined in "assign initial parameters"?

Thankyou and Best regards

Jonas

{assign initial parameters:

'DEBUG(ON)

'prompt for a selection of data to clear

'----


PROMPT(RADIOBUTTON,%ENABLETASK%,"Do you want to clear comments associated with data regions in OutlookSoft?",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"})

PROMPT(SELECTINPUT,%SELECTION%,,"Select the members to CLEAR",%DIMS%)

'user defined keywords. Just for readability purposes

'----


INFO(%TEMPFILE%,%TEMPPATH%%RANDOMFILE%)

'Modify Export task

'----


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) 'Export from sql

'Modify Load Cube task

'----


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) 'import into Cube

TASK(LOAD CUBE,DMMCOPY,0) 'Accept Calc member

TASK(LOAD CUBE,PKGTYPE,0) 'Clear Package Type

TASK(LOAD CUBE,CHECKLCK,%CHECKLCK%)

TASK(CLEAR COMMENTS,APPSET,%APPSET%)

TASK(CLEAR COMMENTS,APP,%APP%)

TASK(CLEAR COMMENTS,USER,%USER%)

TASK(CLEAR COMMENTS,DATATRANSFERMODE,0) ' 0 means clear comments

TASK(CLEAR COMMENTS,SELECTIONORFILE,%TEMPFILE%)

TASK(CLEAR COMMENTS,ENABLETASK,%ENABLETASK%) '1 means execute , others will skip this task

TASK(CLEAR COMMENTS,CHECKLCK,%CHECKLCK%)

'----


< Detail> -


'Should not change below

'----


BEGININFO (%SQLDUMP%)

select %FACTDIMS%,0 as SIGNEDDATA

FROM

( SELECT %FACTDIMS%,0 as SIGNEDDATA FROM TBLFACT%APP% WHERE %SELECTION%

UNION ALL

SELECT %FACTDIMS%,0 as SIGNEDDATA FROM TBLFACTWB%APP% WHERE %SELECTION%

UNION ALL

SELECT %FACTDIMS%,0 as SIGNEDDATA FROM TBLFAC2%APP% WHERE %SELECTION%

) as ZeroTable

group by %FACTDIMS% OPTION(MAXDOP 1)

ENDINFO}

Edited by: Jonas Saltin on Feb 16, 2010 11:59 AM

Edited by: Jonas Saltin on Feb 16, 2010 12:01 PM