Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

New Query Requirements

Hi All,

I have to develop a query. Request all of u for suggestions.

My cube contains data :

Customer--


Salesman
Bill date
--


sales value

c1--


s1
20080101
--


1000

c1--


s1
20080108
--


3000

c1--


s1
20080701
--


1000

c1--


s2
20080421
--


2000

c1--


s2
20080301
--


1000

c1--


s2
20080801
--


1000

ie all the transactions done by a customer with salesman and Bill date.

My requirement is to create a report with following format.

Customer--


Salesman
sales value

First date of transaction with salesman
--
last date of transaction with salesman

c1--


s1
5000

20080101
--


20080701

c1--


s2
4000

20080421
--


20080801

ie summary of transactions done by a customer with both first and last transaction dates with the salesman.

And one more thing like this there will be thousands of customers so i have to display the report for all the customers.

Ur suggestions will be highly appreciated.

REDDY

Edited by: Narendra Reddy C on Sep 10, 2008 11:54 AM

Edited by: Narendra Reddy C on Sep 10, 2008 12:22 PM

Not what you were looking for? View more on this topic or Ask a question