Skip to Content
avatar image
Former Member

Inactive Customer Report/ Customer who has done transaction

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 21, 2010 at 02:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2010 at 06:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded