cancel
Showing results for 
Search instead for 
Did you mean: 

New Query Requirements

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

Thanks for ur reply. But it won't work.

I have to display the min and max. dates of the transaction dates by an customer side by side.

REDDY

Edited by: Narendra Reddy C on Sep 11, 2008 7:40 AM