cancel
Showing results for 
Search instead for 
Did you mean: 

How to verify data from function or data from input

former_member920516
Participant
0 Kudos
100

Dear Experts,

I have a question for SEM-BPS for Excel input.

Our SEM version is v3.5

Now for SEM data in our project, it contains two parts.

One is from user key in, another is from sem function (formula, copy function, etc)

Now we want to only check the data from user key in. (we check record master data)

But for function data, we do not want to check it.

Could you kindly provide some idea to solve this requirement

Thanks and best regards

Alex yang

View Entire Topic
Former Member
0 Kudos

Hi.

I'm not sure that I have understood your issue ...

What do you mean by "we check record master data" ?

When you enter new data do you perform any validations ?

Could you plz ellaborate ...

Regards.

former_member920516
Participant
0 Kudos

Dear Andrew,

I mean that we have master data consolidation check for BPS.

It will check the master data.

Now we want this function only check user key in data but for function data, we want to ingore it.

If you have any problem, please inform us.

Thanks and best regards

Alex yang

former_member920516
Participant
0 Kudos

Dear Experts,

Did you have some idea on this change?

For master data check for SEM record, we use character relationship in Planning area.

But we only want to check the user key in data not function data.

Thanks and best regards

Alex yang