Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Bi Publisher SYSDATE - 1 calculation

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
-
calculate sysdate-1 in your data source it self...get it as a column in datamodel and use it the way you want it.
0 -
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
0 -
Please use
<?xdoxslt:sysdate()-1?>
0 -
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.
0