I want to schedule the report as sysdate-1.....how to do
Answer Posted / 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 View All Answers
what do u mean by bridge group? where we r using this one?
Define metrics studio?
how to create measures and dimensions?
What is the difference between ‘macro’ and ‘prompt?
What do you mean by drill through report?
What is a Datastore in Cognos?
What are the steps to import the two data sources in framework manager?
what are the dimensions that you have in your current project?list them?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Name the types of report?
What is defined as catalog and types of catalogs in Cognos?
Why cognos decision stream is used?
-----------------What is Determination Model?
What do you understand by the cognos?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?