Creating Daily Totals from an external data set

[kevinstanfield]

I have a dataset that's refreshed daily and I want to "database" the total value each day so I can track/trend and perform a comparison e.g. today v yesterday.

Can "Total Value" be calculated and stored each time the data is refreshed (daily) or would the data have to changed to accommodate this (there is a good reason for not doing this)

Thanks  in anticipation

Kevin

[marcus_sommer]

I think this would be helpful for you:

Slowly Changing Dimensions

Slowly Changing Dimensions

- Marcus

[swuehl · Accepted solution]

I read this request more like a need for keeping a history file in QV for several snapshots of fact data, for example storing the current exchange rate on a day each day, so you get a history of rates.

- Create a QVW that queries your data source and read all current data.

- Aggregate the data to an appropriate level as needed

- append the data to a QVD that stores all snapshots with an additionally created 'snapshotdate' field

This QVD can then be used in any other application.

Do you have something like this in mind?