cancel
Showing results for 
Search instead for 
Did you mean: 

Query display Net amount by soldto and aggregate some soldto together

Former Member
0 Kudos

I have master data soldto, existed in InfoCube: Sales.

And Current Query display Net amount by soldto

Requirement: Query display Net amount by soldto and aggregate some soldto together.

Example:

-Current Query

soldto NetAmount

A 100

B 200

C 300

D 400

-New Query: A+B -> B

soldto NetAmount

B 300

C 300

D 400

Do Query Designer can?

Or build new model in BW?

Please help me.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

If the event behind this is that customer A has been bought by customer B, I guess you should create a special flow on your infoprovider by reprocessing all the records, transforming A into B.

Another option could be to add a nav. attribute to your customer object, let us call it "reporting customer", and put B into this value for customers A and B, C in C ....

In the query designer you can do that with a structure, but this implies to maintain this structure by hand, and it's not very usefull if you have plenty of customers.