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 is TRAP in Framework manager?What's the use of TRAP? Where We are using this?
What is the difference between a data mart and a data warehouse?
advantages of cascade prompt ???
What is the difference between macros and prompt?
What is slowely changing dimensions?why we are used SCD?
hi friends pls forward impropmtu interview question
What is the difference between Conditional Layout and Conditional Block
hi my name is siraj i want to know cognos queriy language
Write a SQL query which should fetch the 5th maximum salary of an employee from the table?
Can you please tell me the limitation of Excel file when exporting from report to Excel? I can export to HTML and PDF but I can't export to Excel. The report is more than 13000 rows. When exporting to Excel, system can view it. After that, I save the report to an Excel file. The size of Excel file is more than 11 MB. But I can't view this file by Excel. Please help me to solve this problem. Thanks!
What is the difference between drill through, drill across?
Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?
7 Answers Blue Cross Blue Shield Association, TCS,