Creating historic data table

[Daryn]

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

[rbartley]

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).

[Daryn]

Hi and thanks for responding,

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

Any pointers would be appreciated.

Regards

Daryn

[rbartley · Accepted solution]

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.