Question:
Hello BW Gurus,
We have the std sales cubes with std extractors filling them.
we have a requirement now to create a query for an end user who is interested in counting the number of invoices raised against the customers
I did have a look at the cube and there seems to be no field which keeps a count on the total number of invoices
Is there any means where in i can find the number of invoices raised against a particular customer.
I would really appreciate if someone can guide me in this with some work around.
Thanks ,
sandhya .
Answer:
You say you have the std sales cubes, but don't confirm the technical names, so I'll assume 0SD_C03 is one of them. You have a keyfigure in 0SD_C03 0DOCUMENTS which should give a count of invoice documents when you restrict by 0DOC_CLASS = 'I'.
Answer:
You say you have the std sales cubes, but don't confirm the technical names, so I'll assume 0SD_C03 is one of them. You have a keyfigure in 0SD_C03 0DOCUMENTS which should give a count of invoice documents when you restrict by 0DOC_CLASS = 'I'.
Fine but.. what if want to know besides how many invoices of each 0matl_group... i get zeros in each row of 0matl_group
Regards
Josh