Skip to Content
avatar image
Former Member

Prompts are restricting the query result in a report ?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 09, 2017 at 07:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded