BI Publisher: Relative Dates In BRM Base Reports

(Doc ID 1572784.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.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 ***

Goal

This article is to answer the below queries related to Oracle Communications Billing and Revenue Management(BRM) base reports in BI Publisher.

Qn1:

BRM base reports (BRM 7.5.0.0.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?
 
Qn2:
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?

Solution

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