Skip to Content
0
Former Member
Aug 22, 2005 at 07:54 AM

Why no history data track in the query

11 Views

Hi, All,

I created 2 IOs, 'customer' and 'customer manager', and assigned 'customer manager' as the attribute of 'customer', with the 'time-dependant' property.

And I created 2 test record for the customer master as following:

Customer|To Date|Valid from Date|Customer Manager

00000001|20031231|20030101|1010

00000001|99991231|20040101|1020

Then in InfoCube, I inserted 2 record as following

Customer|Cal Month|Amount

00000001|200311 |10

00000001|200501 |20

However in the query, the result is as following

Customer Manager | Customer | Cal Month | Amount

1010 | 00000001 | 200311 | 10

1010 | 00000001 | 200501 | 20

But my expectation is:

Customer Manager | Customer | Cal Month | Amount

1010 | 00000001 | 200311 | 10

1020 | 00000001 | 200501 | 20

And even set the key date for this query, the result is still wrong, so please help on this question.

Thanks a lot.

Best Regards