Skip to Content
0

How to Populating single prompt from two different table in SAP BO 4.1?

Jul 05, 2017 at 02:01 PM

25

avatar image
Former Member

Hi Team,

Need your Help !!

I want to add @prompt in BO Report for “POLE” so Users can select the desired “POLE” data only, but this object coming from two different table like :-

“T_OWNED” AND “T_LEASED”, Now need to pull the data from both the table for single prompt - “POLE”.

Example :

(

T_OWNED.POLE IN @prompt('Contract Pole:','A','Owned Property Address\OP',Multi,Free,Not_Persistent)

or 'All' in @prompt('Pole Name in List:','A','Owned Property Address\OP',Multi,Free,Not_Persistent)

or 'ALL' in @prompt('Pole Name in List:','A','Owned Property Address\OP',Multi,Free,Not_Persistent)

or 'all' in @prompt('Pole Name in List:','A','Owned Property Address\OP',Multi,Free,Not_Persistent)

)

Or

(

T_LEASED.POLE IN @prompt('Contract Pole:','A', ‘LEASED Property Address\OP',Multi,Free,Not_Persistent)

or 'All' in @prompt('Pole Name in List:','A', ‘LEASED Property Address\OP',Multi,Free,Not_Persistent)

or 'ALL' in @prompt('Pole Name in List:','A', ‘LEASED Property Address\OP',Multi,Free,Not_Persistent)

or 'all' in @prompt('Pole Name in List:','A', ‘LEASED Property Address\OP',Multi,Free,Not_Persistent)

)

Please advise what are the option we can use but end result should be , When users run the report then only one Prompt come for both the table.

Note:- I am using SAP BO 4.1.

Thanks

Santosh Kumar

10 |10000 characters needed characters left characters exceeded

HI,

Merge the prompts with same technical name in WebI.

Thanks,

Jothi

0
Former Member
Jyothirmayee A

Hi Jothi,

Could you please help me to know how to merge "Prompts" ?

Thanks

SK

0

Hi,

In WebI, got to Document Summary and it's properties or you can also fine these properties with in Query Panel too.

Mostly they are checked by default but do verify once.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers