Inactive Customer Report/ Customer who has done transaction

[Former Member]

Hi All.

I need to created report for customer who has done any transaction in last 2 years, please suggest me way to achieve this

Thanks

Prem

[Former Member]

Hi ,

which is the Idea given by our collegue it is ok,

But there you can keep all the objects data.

so you can try in this way

take the info object ( ocustomer) and take the cube ( where you are getting the transactional daat of that customers)

keep left side the 0customer object and right side info cube and create teh infoset with left outer join

here you can get the all the customer detials based on the masetr data , and which are c ustomers are done business for thenm transactional data will come.

now in query where the value <0 condtion , you can keep , it shows onle who are not done businees .

Thansk & Regarsd,

sathish

[former_member189638]

Create a Multiprovider with the Cube and Customer InfoObject. So now the when you run the report created on top of the multiprovider, you will have the key Figure blank for all the customers available in your masterdata but not in the Transaction data. You can create a condition o the query for Key Figure equal to 0. This will give you the listof Customers without any transction data.