Questions tagged [hana-graphical-calculation-view]
2 questions
2
votes
1 answer
Fill in gap with prior record value having a populated quantity LIMIT: no analytics can be used
Assume data with structure like this: Demo
WITH CAL AS(
SELECT 2022 YR, '01' PERIOD UNION ALL
SELECT 2022 YR, '02' PERIOD UNION ALL
SELECT 2022 YR, '03' PERIOD UNION ALL
SELECT 2022 YR, '04' PERIOD UNION ALL
SELECT 2022 YR, '05' PERIOD UNION…
xQbert
- 34,733
- 2
- 41
- 62
0
votes
1 answer
How to convert a date to string in SAP HANA calculated column?
I want to add months to a date (YYYYMMDD), which is a string currently '20190101'.
to add months i use:
addmonths(date('20190101'),12)
which would give me "2020-01-01" as a date
But I only want "202001" as my final output. I tried doing the below…
X0123
- 1
- 3