Interested to Buy Any Domain ? << Click Here >> for more details...
Interval Prompt's Usage? Example for usage in Project
- 2 Answers
- 16022 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / chiru
Interval prompt is used to find the interval between two dates.......
For example u r Having two dates Order Date and return date of a product... u would like to know the duration between Order Date and return date.......
1)First Drag Product name, Order date, return Date...
2) Drag a Query Caluclation and drop to the middle of Order date and Return Date Columns......
3) Give name as Duration...
4) Now goto prompt Page and Create a New Prompt Page..
After drag and Drop Interval prompt....
5) Give Paramater name as "Interval Prompt"
6) on next step apply filter on Interval column ....
7) Click finish.......
Now run the report and u will get interval prompt... in prompt enter the duration like 3 days or 5 days like that
Now u will get the product which returned for 3 days or 5 days.....
Thanks
Chiru
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
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 is set to be Cognos configuration?
Can you explain new content durability?
What is the function of cognos dispatcher?
How to do Performence Tunning in Cognos Reports?
What is difference between page break and section report?
Explain the difference between native sql and cognos sql?
How do we convert from Numeric to be Words?
2. What functional area you worked on.
What is difference between data mart and data warehouse?
what is the difference between native sql and cognos sql?
What is a Pivot?
Can you define framework manager?
What is difference between primary key and unique key constraints?
How to create a cube in Transformer? What is the process? Please mention process thank u
