You could use IntervalMatch for linking you slowly changing dimension to a calendar, like:
(biff, embedded labels, table is Sheet1$);
Date(makedate(2010)+RecNo()-1) as Date
IntervalMatch (Date) Load [Valid from], [Valid to] resident Product;
Then just create a line chart with dimension Date and Product and as expression
See also attached.
An alternative is to create additional data records right in your product table using while statement.
comm47196.qvw 153.0 K