on 09-10-2008 10:12 AM
Hi All,
I have to develop a query. Request all of u for suggestions.
My cube contains data :
Customer--
sales value
c1--
1000
c1--
3000
c1--
1000
c1--
2000
c1--
1000
c1--
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--
c1--
20080701
c1--
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
hi,
As per above mentioed can please try to develop query like this
create interval variable on bill date drag in to the free char and customer dragged in to row . u will get query as per ure requirement
regards
Sivaraju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.