BI Publisher: Relative Dates In BRM Base Reports
Last updated on JUNE 19, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 7.5.0]
Information in this document applies to any platform.
***Checked for Relevance on 03-April-2015***
*** Checked for relevance on 09-28-2016 ***
This article is to answer the below queries related to Oracle Communications Billing and Revenue Management(BRM) base reports in BI Publisher.
BRM base reports (BRM 18.104.22.168.0 version) in BI Publisher need to be scheduled and run on the 1st of every month for the last full month. Most BRM reports take the start and end date as a parameter.
How to schedule these reports to use a relative start/end date for the last month?
Is there an expression to get the last full month? In other words, if it runs on the 1st it would use the previous first day of month and the previous last day of month?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms