Search This Blog

Wednesday 7 March 2012

Using Timestamp

Recently I have come through an business requirement that I have to calculate the number of days from the column 'Document Date' by comparing with current date to find out the ageing period of a customer.
I'm sharing the solution which I have find out using timestamp function in OBIEE BMM Layer.
I hope this may be helpful.
I have created the column called 'DayDiff' in BMM layer with the function timestampiff shown in the below picture:




I have used the same column when we were created the saved request which exactly giving the total number days by comparing two date columns.


Happy blogging!!
Bose

No comments:

Post a Comment

OBIEE 12c to OAS Migration

 Hi All, I have migrated successfully few projects from BI 12c to OAS 6.4. If  anyone wants help then please reach Me! Cheers! Bose

Recent Posts