I need some help on the following problem:
I have got a customer status, let's say N for New, A for Active, I for Inaktive.
When a customer buys the first time his status will be N.
When he buys a second time his status changes to A.
After some time without an order his status is set to I.
This status changes are recorderd in a history table.
How many customers with status "N" at date(t1) and how many of those customers have status "N", "A" and "I" at date(t2).
e.g. on 01. Jan. 2010 i have 500 customers with status "N".
On 01. Jul. 2010 i want to know how many of those 500 customers from the 01. Jan. have status "A".
Let' say 200 have status A.
Output should be t1_U = 500 and t2_A = 200.
Would it be posible to do answer this question in a cube?
I have tried out some things but didn't get an plausible result.
With 2 messures (one for point1 in time, a second for point2 in time) it will not give me 200 in the second messure, but 220. I think a there is missing a relationship between the two messures on customer base.
So at point 2 there are 20 more customers with status "A" on point2 in time thats right, but they didn't exist on poi
View Complete Post