cancel
Showing results for 
Search instead for 
Did you mean: 

Create Logic to match values

Former Member
0 Kudos
69

Hi all,

I need help with this scenario.

I have a requirement to create a logic or formula but not on the report side it should be in the backend.

we have an input schedule setup for users where users enter data.

we have a data load every day from sap->BI

problem:

for period end the totals from the daily loads does not match with totals with inputschedules. it doubles the numbers

any ideas ? how to work around this problem ?

Thanks in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

So, do want to create a logic to check whether the data is matching or not? You can make use of the validation business rule for this purpose.

However, I would suggest you to analyze this problem, as in why the data is doubled. May be you have some default logic which is causing this. Are you storing the BI data and input schedule data in 2 separate data regions? Which dimension is separating this region?

Former Member
0 Kudos

Datasource is the dimension we use to input data as well as import data from bi

Former Member
0 Kudos

Hi,

So, both of them are going to the same datasource or different?

Former Member
0 Kudos

Yes datasource dimension is same but members are different

manual input and GL etc.

Former Member
0 Kudos

Hi Nilanjan,

If I eliminate the values only for the fields which are being updated thru input schedule in my data package will it resolve the problem ?