Skip to Content
0

Drill Up Hourly data to daily data in HANA calculation view

Aug 22, 2017 at 10:08 AM

19

avatar image
Former Member

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Share
10 |10000 characters needed characters left characters exceeded