How to use the history option of views

[Former Member]

Hi Experts,

Can you tell me how to use the history option of views?

Thanks & Regards,

Ranjith.

[pfefferf · Accepted solution]

Hello Ranjith,

the history option for information views is used in combination with column history tables. If you use a column history table as datasource you can enable that option and define an input parameter which is used to define what history data has to be shown.

More Info: Enable Information Views for Time Travel Queries - SAP HANA Modeling Guide - SAP Library

Regards,

Florian

[Former Member]

Hi,

Thanks for your reply.

How to query this?

Regards.

Ranjith.

[Former Member]

Hi Ranjith,

You can use query SELECT * FROM "_SYS_REPO"."OBJECT_TEXT_HISTORY" where object_name = '<object name>'

Best Regards,

Shireesha

[Former Member]

Hi Shireesha,

Thanks for your reply.

I'm asking about the history option under View properties tab.

Regards,

Ranjith.

[Former Member]

Hi Ranjith,

Users can enable History to enable the information views to support time travel queries which helps to keep track of hisotical or past state of data.

Date/TimeStamp Input parameter can be used as history input parameter to filter data at run time based on timestamp provided.

Please go through below link to understand more about history table and use of input parameter

&amp;raquo; SAP HANA History Table

Enable Calculation Views for Time Travel Queries - SAP HANA Modeling Guide for SAP HANA Web Workbenc...

Regards,

Shireesha

[Former Member]

Hi Ranjith,

History shows version management (lifecycle management)  of that particular view with details as Version number, Activated By, Activation Date and Last Activated By as shown below

Best Regards,

Shireesha

[Former Member]

Hi Rajnith,

History View shows us the different types of jobs we have executed and its detailed view over a period of time.

Regards,

Varaprasad