advantages of cascade prompt ???
Answers were Sorted based on User's Feedback
Answer / subhash
when ever u want other prompt display values based on the
selected one then we will go to the cascading prompt.
by using this actually we no need to create a filter for
this second query manually for the selected one in the
previous prompt.
it is the best feature provided by cognos.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / crn.siva
Create Prompts on Product line and Product type.
while creating product type we give the cascading souce as
a product line for product type
we have options are there in the properties pane i.e
AUTOSUBMIT set as YES & MULTISELECT set as NO.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sambamalla
EX: product range
product category
product
there is a three levels
if u select product range after Automatically next prompt
appear that u have to select product category next
product like one by one u select.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gopal
It uses previous prompt value to filter the values in the current prompt.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nasa
Cascading means a Prompt getting the filter values from another prompt..
advantages:
-Time will be save...
-Possible to send filtered values to another prompt
-we can give source to another prompt
-AutoSubmit property for Single Select
-Reprompt button for multi select
-No need to select all value possible to select only particular values at runtime
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venkat m
casecade promt take values from another promt
it is nothing but condition.
using this we can filter the data
| Is This Answer Correct ? | 1 Yes | 2 No |
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
wt is tupple , Embed function ? wt is regular dimension ?
How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?
What are the ways to import data into catalog?
What is the difference between List and Cross tab? Could some on explain with an example..
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
what is textsource variable
What is the difference between low affinity and high affinity connections?
What is Index?
difference between join and union in reportstudio?
Explain what is the difference between microstrategy and cognos reporting tool?
what is the difference between aggregation and role up aggregation ?