Skip to Content
0
Former Member
Aug 11, 2006 at 03:47 PM

i need a count of unique combination of 3 fields in bex report....help me .

449 Views

I have an infocube ,where the data is loaded in to it like shown below,it consissts of 100 fields apart from the 3 given below

i need to calculate the total no. of repairs in a bex report which is the

count of the unique REQUEST_ID, MODEL_ID, and SERIAL_ID_RCV.(all these 3 are defind as characteristics)

Request_id model_id serial_id_rcv.... ship date

101 760s 100124 10082005

101 760s 100124 10082005

102 750a 100127 12082005

102 750a 100127 12082005

103 770 100126 12082005

in this case the total no. of failures is 3 i.e the count shuld be = 3, for Aug 2005.

I have to prepare a report of this format. When u give the selection criteria

Ship date from :…jan 2005………… to ship date to : Aug 2005 ,

It should give a report of this type:

Month total no .of failures

Jan 100

Feb 150

…… ……

aug 300

Can any one help me how to figure out this ? what can be done at the query level .

Or shld I write any update rules . I struggling a lot on this .

I need your suggestions , whether it is feasible or not ?

Pls respond quickly. I will be than ful to u.

Message was edited by: lokesh babu bandi