Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Busting OTBI Myths - Reporting on future or past dated information
Content
Myth: You can't report on future dated or past dated information in OTBI
Data is generally as of the current date. You can define the report effective date to the future or past by setting the PARAM_EFFECTIVE_DATE in the Prefix in the Advanced tab like this:
SET VARIABLE PARAM_EFFECTIVE_DATE='@{P_DATE}{2018-12-31}'
P_DATE is a presentation variable that is set by a prompt, 2018-12-31 is the default if P_DATE is empty - this allows report builders to test the report without the prompt.
Examples in Report Sharing Center:
Tagged:
5