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

    Figure 1

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

    <Please see attached file for image>

    Figure 2

  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>

    Figure 3

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

    <Please see attached file for image>

    Figure 4

  5. Specify the Filter as per below.

  6. Open Date

  7. Between

  8. Start Date: Prompt

    <Please see attached file for image>

    Figure 5

  9. End Date: Object

    <Please see attached file for image>

    Figure 6

    When you select "Object", the following screen appears. Select the "pdmToday()" Object created in step #1.

    <Please see attached file for image>

    Figure 7

    The filter for "Open Date" would look like:

    <Please see attached file for image>

    Figure 8

Environment

Release:
Component: ARGIS

Attachments

1558698163810000050428_sktwi1f5rjvs16o5w.gif get_app
1558698161917000050428_sktwi1f5rjvs16o5v.gif get_app
1558698160027000050428_sktwi1f5rjvs16o5u.gif get_app
1558698158244000050428_sktwi1f5rjvs16o5t.gif get_app
1558698156395000050428_sktwi1f5rjvs16o5s.gif get_app
1558698154309000050428_sktwi1f5rjvs16o5r.gif get_app
1558698152513000050428_sktwi1f5rjvs16o5q.gif get_app
1558698150633000050428_sktwi1f5rjvs16o5p.gif get_app