What is the difference between the prompt and cascading
prompt
Answers were Sorted based on User's Feedback
Answer / shah
1.Cascading prompt can be created at Universe level by
editing the objects...whereas prompt can be created at
report level as well as universe level.
2.Cascading prompt is not built-in function in BOXI
whereas prompt is a built-in funtion which is provided at
universe level.
3.while developing report using free hand SQL we cant use
cascade prompt whereas simple prompt can be used free hand
SQL.
4.cascade is user defined funtion where prompt is built in
Lot more difference....
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / kiran
Prompts: Prompts takes the input parameters/values from the
users(from the list of values) and run the report/query
based on the user selection.
Cascading Prompts: are also prompts, but its a link of
chain based on user section values..
Eg: first prompt asks the user to select the Country from
the list of countries, then it filters at the backend and
asks the user to select the state to select( these are
states only belong to that above country)...then goes to
cities which only belong to that above state...
| Is This Answer Correct ? | 14 Yes | 0 No |
How maually can i define ? If thousends of records exists in a table?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
what are slowly changing dimensions, confirm dimensions?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?
how to improve the performance of the report
how can i add two different reports in the same document?
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
What is the test methodology for testing BO Universes?
difference between xir2 and 6.5 version
How to delete the duplicate colums in a sql table ?