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

Default Logic Question/ Issue

Can any experts out there tell me if there us a way to differentiate when data is sent from the default logic being manually run verses data being sent from an input template?

I have a situation where my users want a piece of logic to run only when sent from a particular input template. But if the default logic is run manually they want the logic to be skipped.

Here is my situation. I have a dimension called service. The users have two input template that populate values to service. The first template is to enter one service at a time and the second template is to enter values to a "default_service" member then the logic below spreads it across all services base on a property. And it is setup to be called from the default logic. The problem is there is another procedure that needs to run the default logic manually and when this happens The values in default_service get spread over all services even though the users didn't want that to happen at that time, only when they go into the template and update "Default_Service". I have attached the code below:

*XDIM_MEMBERSET CATEGORY=%CATEGORY_SET%

*XDIM_MEMBERSET ENTITY=%ENTITY_SET%

*XDIM_FILTER SERVICE=[Service].[H1].MEMBER_KEY = "DEFAULT_SERVICE"

*XDIM_MEMBERSET ACCOUNT = ALLOC_PCT

*XDIM_MEMBERSET DATASRC = INPUT

*XDIM_MEMBERSET TIME = %TIME_SET%

*SELECT (%SERVICE_PDAC%, "[ID]", "SERVICE", "[ALLOC_METHOD] = 'PDA-C'")

*IGNORE_STATUS

*IGNORE_SECURITY

*RUNALLOCATION

*FACTOR=1

*DIM SERVICE WHAT=DEFAULT_SERVICE; WHERE=%SERVICE_PDAC%; USING=<<<; TOTAL=<<<

*DIM ACCOUNT WHAT=ALLOC_PCT; WHERE=<<<; USING=<<<; TOTAL=<<<

*DIM DATASRC WHAT=INPUT; WHERE=<<<; USING=<<<; TOTAL=<<<

*ENDALLOCATION

*COMMIT

Any ideas you could give would be greatly appreciated.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2011 at 06:26 PM

    Hi Kevin,

    I don't think there is a way to differentiate the source of data using some specific functionality. What you could do is to have some kind of flag account and have it post a value to it from specific template.

    Later in the default logic you can chech the value of the account and if flag is set, execute some calculations. In the end you can clear the flag so that any other data send methods do not trigger the calculations.

    However, it may not be feasible to trigger allocation using this method.

    Best

    Madis

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 27, 2011 at 01:40 PM

    Sorry it took me a while to resond back, I got locked out of my account. I appreciate your solution but think I will just take the logic out of default and have them execute it seperately, just to keep it clean. Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 19, 2011 at 07:25 PM

    I figured it out

    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.