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 |
---------------Can we use more than 1 Fact table ?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
What are the types of studio?
How will you migrate your reports to QA environment?
Name the types of gateway?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
what is drill down and slicing and dicing what are the difference between them?
what does my folder and public folder contains? difference between the my folder and public folder?
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
------------What is Slicer memberset?
My report output is showing data as 1 11 111 2 22 222 3 33 333 How can I sort this to 1 2 3 11 22 33 111 222 333