Add row in IP

[Former Member]

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

[Former Member · Accepted solution]

Hi,

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

Regards,

[Former Member]

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

[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.

[Former Member]

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.

[gregor_dieckmann]

Hi,

another idea is to use derivation; simply implement a derivation exit that fills this field. To do that you need a characteristic that is contained in all aggregation levels as the source for derivation, In the exit you hard code 'Y' for the target. The target characteristic is contained in no aggregation level. In this model the end user simply has to know nothing about this special logic.

Regards,

Gregor

[Former Member]

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.