Prompts are restricting the query result in a report ?

[Former Member]

Hi All,

I'm a newbie to business objects. I'm working on a report in which business layer objects were derived from columns of two tables (Say A and B). Table B is left outer joined with the Table A. I have created a prompt on one of the columns of Table B. Now, When I run the query in Web intelligence rich client, the prompt is getting added to the where condition of the query and suppressing the records which are available in Table A but not in Table B. PFB sample query that was available in the query script.

select

A.column1,

B.column2

sum(b.measure)

from TABLE_A LEFT OUTER JOIN TABLE_B ON TABLE_A.ID=TABLE_B.ID

where B.column2=@Prompt()

I want to present all the records from Table A irrespective of data from Table B. Is there any way to achieve it. I'm using Business objects 4.0 , IDT and web intelligence rich client for report generation.

[jyothirmayee_s]

Hi,

Make sure you have same prompt on Table A too and merge common objects from Table A and Table B within WebI report.

Look at the Merge option with in Analysis Tab.

Thanks,

Jothi

[Former Member]

Hi Jothi,

Thanks for your reply.

That column is not available in Table A. So, I can't create a prompt on it. Is there any other way to solve this issue.

Regards,

Venkat

[Former Member]

Hi Jyothi,

we can give @prompt at universe level and we can merge the objects at the report level. Venkat applied prompt at universe level on table B but the prompt is suppressing records which are available in table A. I have found that once you use a left outer Table A <-- table B, then all tables linked below table B ( like from table B to Table C and table B to table D and table D to table E) must also be left outer.

[jyothirmayee_s]

Hi,

How is the join with in Universe?.

Can you post a screen shot of the cardinality?. Run a query at Universe level and verify the results.

Thanks,

Jothi