Question:
Hallo everybody.
Supose the question: How many customers bought material 01 AND material 02 last month.
In BW, the only solution I can think of is by using two queries:
One to provide the list of customers that bought material 02 last month.
One to count the number of coustomers that bought material 01 last month, with characteristic variable on customer filled by the results of the first query (replacement path).
I have two problems when using the above procedure:
Major Problem--> Performance. If the list of custromers returned by the first query is small (about 100 customers), the responding time of the second query is quite good. In my case, it is hugde (100000 customers) and the second query never ends...
Minor Problem--> Disc Space. Each time the second query is executed, the customer SIDs for the list of first query are stored automatically in a transparent database table (/BI0/600000+++). Even when the second query normaly ends, these tables are not automatically deleted.
So, I need your help to find a workaround for such questions. Are there any other ways to make this logical AND operator work?
Thanx in advance.
Answer:
if i understand your problem there is an easy solution:
have you list of customers and create 2 RKF structure componets. m1 is the quantity of material 1 purchased last month and m2 is the quantity of material 2; now create a CKF component (buy2) that adds the "non-zero count" of m1 to the "non-zero count" of m2. you can then use buy2 for whatever you need to do with you last months purchase info. create a boolean (buy2 = 2 means both were purchased), or put the boolean calculation into buy2; either way you will have the list of customers that bought both materials.
you wil probably have to set up a condition to get rid on the unwanted customers.
_________________
when in danger or in doubt, run in circles, scream and shout.
Answer:
Thanx for the reply, but there is still a problem:
I don't wont to display the customer list in the report. I just want to know their total number. The company I'm working for is a telecommunication company with billion customers. A drilled down report (by customer) not only is useless, but also Bex cannot display all of them in a single sheet.
Thanx again for the reply.