Skip to Content
0
Mar 22, 2019 at 08:54 AM

Issue in creating formula based on objects from 2 datasources

76 Views Last edit Mar 27, 2019 at 09:39 AM 3 rev

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.

Attachments

cod.png (14.7 kB)
cm.png (8.3 kB)
nq.png (7.7 kB)
md.png (4.4 kB)
nod.png (25.4 kB)