Issue in creating formula based on objects from 2 datasources

[former_member354226]

Hello All,

Hope you all are doing well.

I am facing an issue related to SAP WEB INTELLIGENCE report.

We are using SAP BO 4.2 SP2 P6 and Source is BW BEx Query.

We have one report which we are using for years. Which is based on Query Say "A". Report Structure is as follows,

The functional team detected some issue with Payment terms - key dimension (Payment terms were not coming correct) , accordingly source/backend team created new Bex query with same objects as above with updated logic for Payment Terms- Key and gave it to me (Due to some reasons they are not able to make changes in the same query that we are using in this report, The new query only contains Dimensions and No Measures).

So, in BO I have added new BEx query say "B" and merged objects with Old query "A" as below.

Objects of A:

Objects of B:

Merged Objects:

Now I have added Payment Terms object from the new query in Above table as follows,

Now records in this table are coming correct.

Now, I want to create one formula for summarized value.

There are several material types suppose P, Q, R etc.

I want to calculate Receipt values for Material type "P" with respect to New Payment terms object.

So I have written formula as below,

= Sum(

[Current Month].[Receipt Value]

Where(

[Material Type M] InList("P") And [Plant M] InList ("brazil") And [Trading Partner M] InList ("#")

)

ForEach([New Query for Payment Terms].[Payment terms - Key])

)

But, this formula is showing Receipt value according to Old Payment terms object rather than New Payment terms object.

Please help me in resolving this issue.

Also, let me know if you need any more information on it.

Thanks.

[former_member198519]

Its a little confusing what you trying to say. Would it be possible to give us a sample data or screenshot of the issue? Also in you formula are you referring to individual object from data provider or referring to merged dimension object?

[former_member198519]

in the formula are you using the merged dimensions or individual query objects?

[former_member354226]

= Sum(

[Current Month].[Receipt Value]

Where(

[Material Type M](Merged) InList("P") And [Plant M](Merged)InList ("brazil") And [Trading Partner M](Merged) InList ("#")

)

ForEach([New Query for Payment Terms].[Payment terms - Key](Non Merged))

)