There are measures which are point in time in nature like Daily balance, Arrears, Book Value, amounts etc which are applicable for a date/month/quarter and generally calculated by aggregating granular data (transactional) coming from source system.
My questions are-
Are these calc. suitable to be done in a BV satellite? It yes, then what is the driver for the dates for which the calculation should be done? It is possible that due to data corrections in source there is a backdated changes in transactional data which affect these already calculated measures in the BV satellite for old dates. Example account balances can change due to a backdated transaction, arrears can change due to adjustment in value of payments etc.
Are these calcs more suitable to be done in a bridge table/Info Mart/BI tool for a snapshot date/Report date?