Skip to Content
author's profile photo Former Member
Former Member

Default logic - Clear Destintion

Hi expert,

When input is done from the BPC excel, would like to clear the appropriate regin before posting the data. I have placed this in default logic script

but this does not Clear data from WB tables, Members are all valid.

*SUB SetTheAppropriateRegionToClear

*CLEAR_DESTINATION

*XDIM_MEMBERSET CATEGORY=MAYM

*XDIM_MEMBERSET TIME=2010.MAY

*XDIM_MEMBERSET ACCOUNT=x3PSPEND

*XDIM_MEMBERSET ENTITYCOSTCENTER=CEGB1100230Q01

*XDIM_MEMBERSET YEAR=2010

*XDIM_MEMBERSET RPtCurrency=GBP

*ENDSUB

SetTheAppropriateRegionToClear()

Thanks

Gayu

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2010 at 05:19 PM

    In which version? 7.0 or 7.5 .

    Is your goal to CLEAR the region prior to the INPUT being stored? Default logic runs after the data is passed through the Send Governor, so this runs after the posting of data to the WB table. The clear rule also doesn't clear just WB; clears all data in the region across all 3 tables in MS version, and runs the clear prior to the calculation in the default region.

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 08, 2010 at 07:18 AM

    Hi Gayu,

    A script logic doesnt work specifically on the WB tables. It works on the union of the records coming from all the 3 tables for the application.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.