I want to schedule the report as sysdate-1.....how to do
Answers were Sorted based on User's Feedback
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 |
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 |
-------What are the Adv of Star Schema and Snow Flake Schema?
if there are list,crosstab,chart how can you apply a single filter to all object?
what is #prompt and #promptmany, runningtotal in report studio
What is the difference between drill down and drill through?
10 Answers DELL, Deloitte, Systime,
how you create security to cubes ?????
what is the use of macros&folders&herarchies in frameworkmanger?
What is Fullouterjoin?
how can you set the image in the report
difference between drill through and master detail report?
Hi Experts, Can a single package be shared by multiple users?
How Metrics Studio is better than Report Studio?
Can you define snapshot?