I want to schedule the report as sysdate-1.....how to do

Answers were Sorted based on User's Feedback



I want to schedule the report as sysdate-1.....how to do..

Answer / naresh

For Previous dates we cannot schedule the reports on today in Cognos.

We can schedule reports for required day,week,month,Year like Monday,Tuesday .. and time also we can mention.

To schedule reports we need to use schedule option in properties.

We can schedule reports in Public Folders only not in My folders reports.

Is This Answer Correct ?    4 Yes 3 No

I want to schedule the report as sysdate-1.....how to do..

Answer / udhaya

We can use the below expression in filter and schedule the report to run daily.

Date Field > _add_days(Current_date,-1)

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Cognos Interview Questions

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

0 Answers   IBM,


What is the use of Excel files in Cognos8?

1 Answers  


what is the difference between count and running-count functions?

1 Answers  


what is prompt variable

2 Answers   HCL,


What is set to be cardinality?

0 Answers  






What is meant by Reportstudio shortcut?

0 Answers  


Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?

1 Answers  


what are slowly changing dimensions? Why we are used scd?

0 Answers   IBM,


What is difference between drill through and drill down?

3 Answers  


What is meant by junk dimension?

0 Answers  


I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?

1 Answers   Cap Gemini, HSBC,


Name the types of gateway?

0 Answers  


Categories