OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject Ar

Content

Hello There,

I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time".

The analysis has a column "Time"."Accounting Period Name" OR "Time"."Fiscal Period", which display period name (Format: Mon-YYYY)

I would like to add a custom column 'Last_Day_of_Month' (in the format DD/MM/YYYY) that is based on the above column. I understood this can be achieved using the timestampadd function. Performed the following steps to check the working of the timestampadd function:

The row displays: .... Mar-2021 ......

1. Added a column

2. Edit Formula (Below example based on period Mar-2021). The idea is, to get the 1st day of the period name, cast it to a date data type and using timestampadd get the last day of the month