on 09-24-2008 8:49 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.