Skip to Content
avatar image
Former Member

Enable History in Calculation view - how to query the historical information from view

Hi Experts,

I created a calculation view to store the daily inventory snapshots and tried "Enable History " option to get snapshot of timely information.

Followed the same link that SAP suggested

http://help.sap.com/saphelp_hanaplatform/helpdata/en/ef/9eef50b2b14fd3b4e3c8a2e6611351/content.htm

But couldn't see any data or unable to query the information.

Could you please help me in understanding this and how to get a daywise snapshot of this view's data. ?

Regards,

Prasana Ravichandran

capture.jpg (51.4 kB)
blog.jpg (46.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 09, 2016 at 10:39 PM

    Hello Prasana,

    The link says that you need HISTORY tables as datasource in the calculation view. Are you using HISTORY tables i your view?

    Benedict

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks benedict , I think I;ve not created any history table as source for calculation view. I just created some date columns for the daily inventory snapshot and tried to query the data.

      I don't think our scenario will be satisfied with the Enable history parameter. Just running some BODS job to persist each day snapshot will only work.

  • Nov 10, 2016 at 10:53 AM

    Hi Prasana,

    The data type has to be DATE (format is '2016-11-09' instead of '20161109').

    Regards

    Raj

    Add comment
    10|10000 characters needed characters exceeded