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

Answers were Sorted based on User's Feedback



How to check for a particular value from one column with the list of values present in another col..

Answer / 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

How to check for a particular value from one column with the list of values present in another col..

Answer / prakash

Easy one, save the webi report to PDF and search for the
value in PDF.If it is duplicate it will show otherwise not.

Is This Answer Correct ?    0 Yes 15 No

Post New Answer

More Business Objects Interview Questions

How would I achieve Traffic Lighting in Business Objects

3 Answers   Virtusa,


tell me about aggregate awareness in detail?

2 Answers   Cap Gemini,


What is meant by ZABO and FC(full-client)?

2 Answers  


HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  


Example of how the fantraps and chasm traps works?

1 Answers   IBM,






Iam having an report there four cloums and n number of rows if i click ang one cell the report want to go to another report page which gives the detail of the cell which i click pls help me with example

1 Answers   IBM,


how many micro cubes can a report can have

3 Answers  


Explain the SQL Queries activated to data base from Data provider in BO ?

1 Answers   Polaris,


if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  


What is the difference between user and versatile user?

0 Answers  


What are the different types of connections?Explain?

1 Answers   Wipro,


BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.

1 Answers   Infosys,


Categories