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 |
what are the applications of the tabular model ????
Why are meta service important then other services?
I need your kind support. I have more than 6yrs of exp in s/w industry. I have worked on some DW technologies which are out dated. For almost 1 year I was on bench.During this bench period I learnt cognos on my own using online docs. Hence I am alligned to a project few months ago to work on cognos. Unfortunately after joining this project I did not get opportunity to work on cognos. I am working on different things apart from cognos. I should get job in another company. Otherwise I am gone. I am confident enough to get job on Cognos in another company. Please let me know is it possible to work on Cognos at lead position (as my current position is at lead level) without having real time experience. Your response is highly appreciated and I will be grateful to you. Thanks in advance Ganesh
Where in report Studio's property pane can I find NoDataHandler?
Explain the difference between native sql and cognos sql?
difference between join and union in reportstudio?
cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer
Which one is better among Value and select & search prompts,in terms of performance?
What are slice and dice?
what is exact catalog size?
What is RenderVariable?
How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)