Interval Prompt's Usage? Example for usage in Project
- 2 Answers
- 15395 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
What is a dimension?
What are the different kinds of panes included in cognos?
Can you define set to be cardinality?
What is a Query Subject?
What is the difference between low affinity and high affinity connections?
1. Explain your project.
how to create cubes in transformer ?
What is the size of the cube?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
faq's on cognos
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What is cognos powerhouse?
what is requery in cognos?
--------------Diff b/w ODS and OLAP?
