Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bi Publisher SYSDATE - 1 calculation

Received Response
81
Views
4
Comments
Jpyles
Jpyles Rank 2 - Community Beginner
in Oracle Analytics Forum

Summary

Bi Publisher SYSDATE - 1 calculation

Content

I am trying to display today's date minus one on my BI Publisher report.  In the advanced BI Publisher Properties tab I have the following command; <?xdofx:(sysdate()-1)?>.  What is displayed on my PDF output is 'NaN'.

Answers

  • Yogen
    Yogen Rank 5 - Community Champion

    calculate sysdate-1 in your data source it self...get it as a column in datamodel and use it the way you want it.

  • Jpyles
    Jpyles Rank 2 - Community Beginner

    This will work only if my query returns data.  If no data is returned the report still needs to be generated with a 'No data to report' message and the generation date (which is my sysdate - 1) still needs to be displayed

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics & AI Coach

    Please use

    <?xdoxslt:sysdate()-1?>

  • Vani-R
    Vani-R Rank 4 - Community Specialist

    Iam sure it should be possible using xml tags in bi publisher. But, why dont you try using formula field in RDF and get the value using SQL query. This is not linked to original query and will return value irrespective of query returning rows.