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

Default logic

Hallo experts.

I have confused my self a bit over the last week regarding the default script logic, and how it actually works.

The question is quite simply, how much data does the default script run for? Will the script only run for the data that is being sent to the database, or will it everthing that is XDIMed in the script?

I am asking because I am doing a default that will be runing different calculations based on the category, but the users will only be sending data to one category. Will the default script then only calculate for the category being sent to, or will it recalculate for all categories?

This will have a quite a bit influence on the performance. 😊

Best regards

Mikkel Kristensen

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Feb 28, 2013 at 01:53 PM

    Hi Mikkel,

    the Deafult logic would always is triggerred when you are submitting the data via input schedule.

    So if you send only data with one category this will be the scope in the default logic, but if you want to be sure that some instructions in the default logic will be executed only for one category you should use *XDIM_FILTER

    Kind regards

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • In BPC NW 10 scoping in default.lgf works the same way as in BPC NW 7.5. Tested.

      Test script:

      *WHEN ACCOUNT

      *IS *

      *REC(EXPRESSION=%VALUE%+1)

      *ENDWHEN

      Original data:

      DUMMY BEACTUALPeriodic2005.JAN2005.FEB2005.MARMEDINSEMP111MEDINSEMPADM111MEDINSCHILD111

      The default.lgf script added and the data was changed in some cells (before send data):

      DUMMY BEACTUALPeriodic2005.JAN2005.FEB2005.MARMEDINSEMP211MEDINSEMPADM112MEDINSCHILD111

      After data send (2 values):

      DUMMY BEACTUALPeriodic2005.JAN2005.FEB2005.MARMEDINSEMP312MEDINSEMPADM213MEDINSCHILD111

      MEDINSEMP, MEDINSEMPADM and MEDINSCHILD are the members of the ACCOUNT dimension.

      B.R. Vadim

  • Posted on Feb 28, 2013 at 04:45 PM

    Hi Mikkel,

    You can test the scope with a simple DEFAULT.LGF script like:

    *WHEN ACCOUNT

    *IS * //no restrictions!

    *REC(EXPRESSION=%VALUE%+1)

    *ENDWHEN

    Create some input schedule, fill number of members with 1, send data and after put this script as default.lgf

    Change number of values at once and send data. See results.

    B.R. Vadim

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 01, 2013 at 06:30 AM

    Hi,

    Its very simple.If users will only be sending data to one category.Then the default script will only calculate for the category being sent.

    Regards,

    Bishwajit.

    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.