Skip to Content

Drill Up Hourly data to daily data in HANA calculation view

I am new to HANA and I want to convert hourly data (that is containing timestamp) to daily data in SAP HANA and I am not getting any hint on that. Please help me with the solution.

query.png (42.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 07, 2017 at 06:32 AM

    Hi Sunny,

    Create a calculated column and extract only day into it from timestamp column. Make sales aggregation type as MAX.

    Hide\unselect timestamp column in next level node.

    Hope this helps you!

    Regards,

    Sunil TATA

    Add comment
    10|10000 characters needed characters exceeded