How do you filter dates in Cognos?

How do you filter dates in Cognos?

Create a Filter for a Date or Date Range Choose Create Custom Filter. The Filter Condition dialog displays. Define the filter’s parameters. Specific Dates: From the Values drop down, select Specific Values, then choose the specific dates from the Values list.

How do you choose a range of dates?

To select a range of dates:

  1. In the calendar, click the desired start date, then click the end date. The selected days are highlighted. OR.
  2. Enter start and end dates in the Date Range fields.

How do I add a value prompt in Cognos?

Procedure to place check box in value prompt to select multiple Values:

  1. From properties, select the property – Multi-select.
  2. From drop-down list – Select – Yes.
  3. From the page explorer.
  4. Click on Page1.
  5. Click on filters.
  6. Double click on the filter condition.
  7. Change the = operator as in the operator.
  8. Click on OK.

How do I create a prompt page in Cognos analytics?


  1. Login in to the ECM application.
  2. Select Report tab in eCm application.
  3. 3.It will open Cognos connection>>Go to Launch>>Select Report studio.
  4. Create a simple list report.
  5. Go to Page explorer and Click the Prompt Pages option.
  6. Double click Page option on left side and Double click Prompt Page1 on middle.

What is a date range?

/ˈdeɪt ˌreɪndʒ/ a number of dates that includes a particular start and finish date and all dates in between: You can specify a date range when you search.

How do you write a date range in SQL query?

SELECT * FROM PERSONAL WHERE BIRTH_DATE_TIME BETWEEN ‘2000-01-01 00:00:00’ AND ‘2002-09-18 12:00:00’;

What are Cognos parameters?

Parameters in Cognos are based on prompts whereby a prompt is created that has an associated parameter value. This parameter value can be used in the filter in a query or it can be displayed on a report page. Parameter values provide the answers to the questions.

How do I change parameters in Cognos?


  1. Right-click a query in the model and click Edit Prompts.
  2. For each prompt that you want to specify values for, in the Query Prompts dialog box, click the Value box for the prompt that you want to define.
  3. Define the variable or value for the prompt:

What is value prompt in Cognos?

After you set prompts for the first time in the IBM Cognos Viewer window and import the report into a Microsoft Office document, you can change prompt values when you refresh the reports or import additional report elements. The next time the report is refreshed, the new value is used to filter the data.

How do I set default value in value prompt in Cognos?


  1. In IBM Cognos Connection, click the set properties button.
  2. On the Report tab for Report Studio reports, the Query tab for Query Studio reports, or the Analysis tab for Analysis Studio reports, under Prompt values, click either Set or Edit.
  3. Select the default value for the prompts and click OK.

How to add the first day of the month in Cognos?

For the first day of the current month, in TSQL you would use: DATEADD (MONTH, DATEDIFF (MONTH, 0, GETDATE ()), 0) In Cognos, the syntax would be DATEADD ( {MONTH}, DATEDIFF ( {MONTH}, 0, GETDATE ()), 0) Thanks for contributing an answer to Stack Overflow!

What is [common syntax] in Cognos?

COMMON SYNTAX in COGNOS starts with or ends with Specifies the beginning/ending characters in a field[ACADEMIC_PERIOD] ends with ’40’ [SLCC_BUDGET_CODE] starts with ‘B’

What does the return value mean in Cognos Analytics?

Returns a time with time zone value, representing the current time of the computer that runs the database software if the database supports this function. Otherwise, it represents the current time of the IBM® Cognos® Analytics server.

What is the maturity date range of a report in SQL?

For Eg: If I get a report on 1st May, It should give records of data where the maturity date range is between 1st may to 31st may. I tried adding the below code to my already written SQL code: