Skip to Content
0

BPC input form display blank if value is deleted & also save zero

Oct 24, 2016 at 05:55 AM

324

avatar image
Former Member

Hi,

We have an input form (for targets):

  1. For some parameters user wants to enter target as 0.
  2. If user enters some wrong value & deletes it, he wants it to be displayed as a blank cell for entering value later. So he can identify the cell (blank) where value needs to be entered. (which by default is shown as 0 when deleted)

Combining the above 2 is a problem as the user wants to differentiate between target=0 & the value he deleted.

Please suggest a solution

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Oct 24, 2016 at 06:37 AM
0

Hi Mihir,

Answers as per points...

1. User can enter 0 as target(blank cell) by keeping the setting from options -->Formatting ---> Report Format---> Set default value in empty cell. But note that this value wont be saved to the database! It would just show "0". For this refer to no. 2 in the screenshot Changed report.

2. For this requirement, I am thinking you can use "Changed member format" in this case. If the user deleted existing data then the color of the cell will change and it will highlighted. But after hitting the Save data button this highlighted cell would come back to the normal format given!. So user would only come to know about the deleted data before saving! refer to no. 1 in the screenshot.changed-member.pngchanged-report.png

Let me know if this works for you...

Regards,
JP


Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Oct 24, 2016 at 08:55 AM
0

"For some parameters user wants to enter target as 0" - incorrect idea in general. In bpc empty and zero record are assumed identical in many cases. Also after light optimize with zero elimination zero records will be deleted.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 25, 2016 at 06:50 AM
0

Thanks JP & Vadim.

This is what I have done:

I used the EPM save comment formula [=IF(SEARCH("0",F10)=1,EPMSaveComment(F10,,EPMMemberID($B10),EPMMemberID($C10),EPMMemberID(F$9)),"")].

If the cell contains 0 then it will save it as a comment else keep it blank.

This way even if a value is deleted a blank is shown & when the user enters a 0 it is saved as a comment.

Also I ran Light optimization before this to eliminate all 0 records.

This is working for my requirement.

Please let me know if there is any issue with the above solution.

Regards,

Mihir

Show 10 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Mihir,

But what is the need to save zero in BPC??? If the user sees the 0 entered by him in the input form, that should be Ok! Saving zero as comment is not an issue if you are using this for 1 template only. If this is used all over then I would not recommend unnecessarily increasing the database with comments! Check report performance too! And light optimization doesn't work on comments table to eliminate 0!

Personally I don't think its a good idea to save zero as a comment!

Regards,

JP

0
Former Member
Former Member

And as I understand correctly...your requirement was to differentiate the user with 0 being entered as a value and after deleting the original value, 0 showed! I dont see how saving zero as a comment helps in differentaiating it!

0
Former Member
Former Member

The only need to save zero is for the user's satisfaction. The user wants to see a zero for certain parameters. And a blank if he deletes a value instead of zero. These blanks are for him to know which parameter values he has to enter when he opens the input form later.

0

Sorry, but it's a wrong way!

0
Former Member
Vadim Kalinin

Yes I know it's not proper. Also there will be performance issue while saving comments.

I'll just stick with Light optimization.

Will there be any impact if I schedule Light optimization to run many times in a day?

0

I have already told you that you are doing logically wrong things (and I will not help with it). Please talk with the customer to redefine requirements.

0
Former Member
Vadim Kalinin

I will not be providing that solution. It was just a manipulation of sorts.

I will speak with the customer about it.

Thanks.

0
Former Member
Former Member

User's always demand so many things....not all can be implemented! You need to properly explain and manage them!

How is this condition resolved by saving zero???

And a blank if he deletes a value instead of zero. These blanks are for him to know which parameter values he has to enter when he opens the input form later.
0
Former Member
Former Member

Saving zero & displaying blank instead of zero are 2 different things that are achieved by the formula I have used. After implementing the formula when you delete a value a blank is displayed instead of zero. Also the comment is saved only when a 0 is typed in.

Anyways I'm not going to use it as it is impacting performance.

0

Sorry, but it's absolutely strange and useless idea to save zero in comment.

0