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

Add row in IP

Hello all,

I use the option to get a new row in an IP application.

One of the fields of the row is Flag.

This field gets N when loading the planning cube -> every row has value N in Flag field.

When the user adds a new line, I want to force him to enter Y value for field Flag

(this I want to do in order to be able to later delete via a button just the records with Y value).

How can I force the user to put value Y when he adds the new line, for field Flag?

Please let me know.

Thank you in advance,

AD

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 Dec 06, 2012 at 08:38 AM

    Hi,

    You can write FOX formula checking whether Flag is initial and if so giving error message.

    Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2012 at 08:46 AM

    Hi AD,

    You can automatically populate the Flag of newly crated lines with ' Y' using Fox formula.

    As we can not change charateristics in report, we can populate it using Fox.

    If you are using any planning sequence to create new lines, add a newly created fox formula planning function as a next step to existing planning function. So whenever user execute this sequence, new lines will be created along with Flag value as = Y.

    Hope this will solve your issue.

    Thanks,

    Reshma M.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Gregor Dieckmann

      Hi,

      But we have already some records loaded with flag as ' N' . I think this records will be overwritten with derivation . And also using derivation, user can not see flag field in report output as it is not included in aggregation level. But the requirement is to show Falg field in report output.

      Thanks,

      Reshma M.

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2012 at 11:21 AM

    Hello all,

    Are you sure I can use planning functions?

    I can just put those on Save button.

    But please look at the screenshot :

    I also want to save deletion or reposting and these actions should not be affected , it means the record should keep N in case of a repost , not to get an Y when saving every action.

    I just want to force Y value in case of new lines filled and saved.

    Any other ideas? I am without options.

    Thanks,

    AD


    Image.jpg (80.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi AD,

      Your screenshot is not clear. As per my understanding, you want to have Flag = 'Y' only for the records that are newly created and for all other existing records it should be ' N'. Correct me if am wrong.

      If this is the case, you can have condition in Fox like

      If Flag = "N'.

      Flag = Flag.

      Else.

      Flag = 'Y'.

      Endif.

      OR

      If Flag = Null.

      Flag = 'Y'.

      Endif.

      So before populating flag value, it will check with existing value.If flag has null value (obvious with newly created records) Fox will fill it with value ' Y'. It won't affect your repost/deletion.

      Thanks,

      Reshma M.

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.