Interval Prompt's Usage? Example for usage in Project
Answers were Sorted based on User's Feedback
Answer / amar
Usage of interval prompt is,
If suppose we have difference between dates column
date diff
---------
3
5
9
15
20
In the above column we want display the
selected date in the interval prompt<10
Then go for Interval prompts.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Whrer u can save the Report net documentation in our local system?
hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur
what is Governor settings in cagnos?
wat is bus schema?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
what is the use of lock and unlock
What are the types of studio present in Cognos?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?