Transactions in my source system have start and end dates. In other words, a transaction/fact is valid during a time period specified by start and end date. so for example, suppose there are two transactions in the source system as following:
(Tran-name:T1 , start-date: "1/1/2009" , end-date : "5/1/2009" , Tran$ : $150)
(Tran-name:T2 , start-date: "1/1/2009" , end-date :"2/25/2009", Trans$: $200)
In this case, when a reporting period of Jan 2009 to March of 2009 is selected, and Month attribute is included in the report, the report should look like the following:
Month Tran-count Tran$
Jan 1 $150
Jan 1 $200
Total 2 $350
Feb 1 $150
Feb 2 $200
Total 2 $350
March 1 $150
Total 1 $150
Grand TOTAL 2 $350
Any ideas about how to implement the Tran$ and Tran-count metrics ?
(Tran-name:T1 , start-date: "1/1/2009" , end-date : "5/1/2009" , Tran$ : $150)
(Tran-name:T2 , start-date: "1/1/2009" , end-date :"2/25/2009", Trans$: $200)
In this case, when a reporting period of Jan 2009 to March of 2009 is selected, and Month attribute is included in the report, the report should look like the following:
Month Tran-count Tran$
Jan 1 $150
Jan 1 $200
Total 2 $350
Feb 1 $150
Feb 2 $200
Total 2 $350
March 1 $150
Total 1 $150
Grand TOTAL 2 $350
Any ideas about how to implement the Tran$ and Tran-count metrics ?