How do I return the current date automatically in a CA Business Intelligence (CABI) report filter?
book
Article ID: 50428
calendar_today
Updated On:
Products
CA IT Asset ManagerCA Software Asset Manager (CA SAM)ASSET PORTFOLIO MGMT- SERVERSUPPORT AUTOMATION- SERVERCA Service Desk Manager - Unified Self ServiceKNOWLEDGE TOOLSCA Service Management - Asset Portfolio ManagementCA Service Management - Service Desk Manager
Issue/Introduction
Description:
This document outlines the steps required to create a filter in CABI to return the current date.
Solution:
A new Object using the function PdmToday() needs to be created and specified as a Query Filter in a report.
Create a new Object in the Universe Designer as per below.
<Please see attached file for image>
Type "pdmToday()" in Select field and select "Date" as Type, and click OK.
<Please see attached file for image>
Save the change and export the Universe to make the changes available for universe users. Select 'File' > 'Export' from the Universe Designer menu.
<Please see attached file for image>
From Infoview, create a new Web Intelligence Document and add "Open Date" as a Query Filter.
<Please see attached file for image>
Specify the Filter as per below.
Open Date
Between
Start Date: Prompt
<Please see attached file for image>
End Date: Object
<Please see attached file for image>
When you select "Object", the following screen appears. Select the "pdmToday()" Object created in step #1.