How Can I Create a Report Showing Client Churn?
To create this report/query from scratch would require you to write a query with several sub queries. You would first need to find all of the customers who made a purchase in 2014, then exclude from this list the Customers who made a purchase in 2015. You would also need to retrieve a list of customers who made a purchase in 2017, but not in 2016. You would then need to use both lists as a condition within your query.
What Else Can I Do with Sets?
Other use cases for sets might involve retrieving a list of top products and seeing how these performed month over month, or whether the list changed during this time period and how drastically. Or you could review customer segmentation and how the different demographics of a customer intersect. Since sets use a sub query to retrieve the results, it can also replace the use of an InList condition in your query where you’re retrieving the list from another query in the report. These types of queries are routinely beset with issues such as the InList being too long, over a certain number or the SQL statement being too large, occupying too much memory for the optimizer to process it. The use of sets within Business Objects can be a very powerful tool for analyzing customer churn and segmentation, as well as product placement, giving you a much better snapshot of your business. For more information on how to create these sets or other questions on this topic, please contact Michael Schwenker at Michael.Schwenker@220.127.116.11.