You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
edited Apr 15, 2021 7:38AM in Reporting and Analytics for ERP 2 comments


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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!