How to check for a particular value from one column with
the list of values present in another column in Webi
reports?

Answer Posted / bhim sahi

Define the columns in the report you want to display and
do not pick the column which you use for prompt;

Example pick YEAR, REVENUE to run report

Use prompt on STATE.

THE RESULT SET WILL BE FROM YEAR AND REVENUE WHICH YOU
WANT TO DISPLAY AND PROMPT IS ON STATE WHICH DO NOT SHOW
IN THE RESULT

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the join problems comes appart from loop,chasm & fan Traps

1556


What is thumbnail?

582


what is document design in boxi,have u participate in that

1663


Explain how we drill up week to month?

643


If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

1779






BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725


Explain when to use local filter and when to use global filter?

609


How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4326


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4193


How to schedule the report in b.o?

564


Explain is data mart?

597


When to use local filter and when to use global filter?

603


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1615


How to create Index to the table in the universe designer and how it improves the Query performence

2124


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3000