This is a feature request to allow the building of a datamart fact table on the most current records of a Type 2 entity for fact attributes. The current generated SQL retrieve the version of records valid at the transaction date but this is not necessarily logical, some use cases would require to include the latest version of the records in the fact table.
This type of option is available for dimensions and should also be available for fact tables
The suggested solution would look like this, per star schema you choose whether you want the latest record for a fact or the historic based on transaction date:
The sql part is:
WHERE "E1"."ID" <> 0
AND "TXND"."TD" = CAST('9999-12-31' AS TIMESTAMP)
AND "TXND"."S_CREATED" >= "E3"."FD"
AND "TXND"."S_CREATED" < "E3"."TD"
Currently for attributes in the facts by default a where statement is create where From date FD and To date TD are filtered, for facts where you have the latest version it should say e.g. :
"E3"."TD"="TXND"."TD"