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