cancel
Showing results for 
Search instead for 
Did you mean: 

Planning - input enabled query validation

former_member730190
Participant
0 Kudos
516

Hi. I have an input enabled query displayed in a crosstab in Lumira. We are able to save values back to BW thru this. Question is, can we build any custom validation in Lumira before the planning.save executes? For example, if the user leaves a field blank and hits the save button, it throws an error message saying the field is blank. We want to return this message even before the panning.save is executed. Is this possible? Thanks.

View Entire Topic
gregor_dieckmann
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

I don't understand your comment.

You say

For example, if the user leaves a field blank ...

and this seems to indicate that you wand to validate key figure values. This has nothing to do with valid master data. Characteristics values are validated by the system if the characteristic has a master data table.

Planning functions are working based on transaction data, so depending on your data model an empty cell that should be filled by an end user corresponds to not created records; your validation planning function can detect this.

As I said, the logic depends on the data model and the query design; it may happen that the key figure values to be validated are in one record or in different records; and in the latter case certain missing records the indicate an error.

Regards

Gregor

former_member730190
Participant
0 Kudos

In our case, we are using the input ready query to enter new master data values, not KFs. Yes, this is generally not the use case scenario for planning but we are trying something different. Thanks.