How do I return the current date automatically in a CA Business Intelligence (CABI) report filter?

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA 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.

1. Create a new Object in the Universe Designer as per below.
   
   

   <Please see attached file for image>

   
   
   
2. Type "pdmToday()" in Select field and select "Date" as Type, and click OK.
   
   

   <Please see attached file for image>

   
   
   
3. 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>

   
   
   
4. From Infoview, create a new Web Intelligence Document and add "Open Date" as a Query Filter.
   
   

   <Please see attached file for image>

   
   
   
5. Specify the Filter as per below.
   
   
6. Open Date
   
   
7. Between
   
   
8. Start Date: Prompt
   
   

   <Please see attached file for image>

   
   
   
9. 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.
   
   

   <Please see attached file for image>

   
   
   The filter for "Open Date" would look like:
   
   

   <Please see attached file for image>

   

Environment

Release:
Component: ARGIS