Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nicklarge
Starting Member
40 Posts |
 Posted - 2011-10-12 : 17:12:20
|
| Hello.I am developing a BI solution for a rewards program. Customers can be enrolled on one or more programs. With regards enrollment date analysis, the company wants to be able to see customers where the enrollment start date is before or at the specified start date, and the enrollment end date is at or after the specified date (i.e. no data for records where the customers enrollment start date is during the specified period or after the specified period, and no data for when the customers enrollment end date is during or before the specified period end date.)The actual analysis that they want is sales data based on a sales fact table that I have already developed, so I have the fact and adjoining dimensions for the sales fact table, and a fact table called customer enrollments that share customer and program dimensions, plus enrollment start and end date dimensions.My question is, is it possible using this design method to be able to report on sales data for customers enrolled on specific programs for the enrollment start and end dates (taking into account the logic above), or will the users not be able to exclude enrollments that "partially" intersect the selected enrollment period?Thanks,Nick. |
|
|
|
|
|
SSAS Customer Enrollment Date question