Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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?