topic Creating historic data table in App Development

Creating historic data table

Daryn — Thu, 14 Oct 2021 08:30:10 GMT

Hello community 😊,

Thank you all in advance for taking the time to view and or help with my query.

I have read several posts on storing to QVD/historic data/incremental load but think just ended up confusing myself!

I have a chart –

Based on

Dimension –

=WBSTK

Measures –

Count ({<LFDAT={">=$(=weekStart(today()))<=$(=weekEnd(today()))"}>} distinct VBELN)

Fields are -

WBST = goods movement status and can be A, B, C or blank.

LFDAT = entry created on date

VBELN = delivery document number

The above could of course just as easily be a table.

I am happy with this, but would like to store the value it returns each week day into a new table or chart giving me a history/timeline.

I wouldn’t necessarily want separate QVDs per day, just one that’s appended with the latest results, with a date stamp.

Also approx. 28 days/4 weeks data as history would be enough (if that is possible)?

Currently all data loaded from a database.

Thanks again, hope I have explained this correctly (any further info required)? An example would really be appreciated.

Regards

Daryn

Re: Creating historic data table

rbartley — Thu, 14 Oct 2021 09:31:29 GMT

Hi,

Is there any reason why you don't store the historic data in the database? It would seem to be the most logical choice (assuming you have access to the database or to someone who does).

Re: Creating historic data table

Daryn — Thu, 14 Oct 2021 09:49:34 GMT

Hi and thanks for responding,

Lack of knowledge on my behalf, would be the answer!

Any pointers would be appreciated.

Regards

Daryn

Re: Creating historic data table

rbartley — Thu, 14 Oct 2021 09:59:12 GMT

If you're note used to writing database procedures or using an ETL application, is there someone you work with who is? It's a fairly simple task, but not really the purpose of this forum. If not, a QVD solution would be the next option.