former_member679919
Explorer
Member since ‎11-16-2017

User Statistics

  • 24 Posts
  • 0 Solutions
  • 1 Kudos given
  • 2 Kudos received

User Activity

Calculate rolling 24 months date based on sysdate in BODS.

10-13-2020
Hi All. I am working on a requirement to calculate the rolling 24 months date based on sysdate in BODS . In oracle it was implemeted as follows: TRUNC(ADD_MONTHS(SYSDATE - 730,1),'MM'). I am unable to implement the same in BODS since trunc does not...

How to find the week start day in BODS based on sysdate?

10-13-2020
Hi All. I am working on a requirement to calculate the starting day of a week based on sysdate. Here is the way it was calculated in Oracle :TRUNC(SYSDATE+1,'IW') -1. Please help me in achieving the same in BODS.

Calculation of Financial Year Week Number in HANA based on an input date in Calculation View.

10-02-2020
Hi Folks. As a part of Oracle to HANA migration, I have a requirement to calculate the fiscal year month number based on a given input date. Here is the expression in Oracle : TO_CHAR(TRUNC(TABLE1.IDATU+1,'IW')+5,'YYYYIW') . I am unable to figure...

Explain plan not giving correct details about join cardinality

09-23-2020
Hi All, I am facing an issue when running an explain plan for one of my calculation views in HANA Studio. Ideally, the Explain plan SQL,when run with cardinality HINT should give the details of the bid with join condition which is having incorrect ...

Issue when using LIKE_REGEXPR in Calculation Views

07-08-2020
Hi all, I an working on a Graphical calculation view in HANA . we need to check if the input is a numeric or character.If the input is numeric then the leading zeros should be trimmed. Since custom functions cant be used in Calculated Views, I ha...
View more
Kudos given to