Cascading Prompts in Webi 4.1 SP3

system · August 4, 2014, 11:22pm

Hi,

I am woking on a webi report on top of a universe in SAP BO 4.1 SP3. Hierarchical Display of LOV are not working in the web intelligence.

My requirement is to create the cascading prompts for COMPANY->LOB->Department->Employee

Please let me know how to achieve cascading prompts

Thanks,
Gopi.

GCB343 (BOB member since 2008-09-19)

system · January 9, 2015, 6:08pm

The LOV has to be set up in the universe itself.

Tools=>Lists of Values=>Create Cascading List of Values

mcliffordgoo (BOB member since 2003-02-13)

system · June 8, 2015, 4:58am

How to achieve in IDT?

Thanks,
Venkat

venkat21 (BOB member since 2015-05-28)

system · June 8, 2015, 5:29am

you could have explored the options yourself in business layer

anyway go to BLX > parameters and list of values, select the LOV and edit query to add cascading prompts

haider (BOB member since 2005-07-18)

system · June 9, 2015, 5:02pm

But, it is not working for me. I want cascading prompt on country–> state–>city

I have created 3 LOV’s at IDT by using parameters and List of Values option like:

In select statement i have dragged country and apply filter on country as prompt.
In select statement i have dragged state,country and apply filter on country as prompt.
In select statement i have dragged city,state and apply filter on state as prompt.

In Business Layer, for city object i associated a 3) city LOV. i am trying to create a query by selecting some objects in results object pane and city in filter pan. when i create prompt for city object it is asking prompt for city and state only not asking prompt for country.

Please help me on this.

Thanks,
Venkat

venkat21 (BOB member since 2015-05-28)

system · June 10, 2015, 5:01am

Note that it has to be done in the LOV object from Parameters and list of values option of BLX and not in the where clause of object

haider (BOB member since 2005-07-18)

system · June 10, 2015, 3:57pm

I did that at parameters and list of values pane only. please share me the document if any related to this topic.

venkat21 (BOB member since 2015-05-28)

system · June 11, 2015, 5:21am

an eg from efashion unv

State > city > store name

create city prompt in store name lov, and create state prompt in city lov
Then create a query with store name in result pane and in condition pane

you will be prompted for state prompt > city prompt which after selection gives store name values

haider (BOB member since 2005-07-18)

system · June 26, 2015, 1:24pm

For country–>State, I have created like:

In List of Values option, I have created ‘StateLOV’ by taking State in select object pane and Country = @prompt in filter pane.

In Business Layer, for ‘Cascading State’ object properties I have associated above ‘StateLOV’.

Here the problem is, when I create report by taking some objects in select object pane and “Cascading State” in filter object pane. at the time of running the report it is asking prompt for Country, State I am giving values, but in query(script) country related filter is not showing in WHERE clause and data is not filtering accordingly.

data is not filtering accordingly(if i give county as A state as B,C,D… report fetching data for A country as well as other counties which are having states B,C,D)

Please help me on this.

Thanks in advance

venkat21 (BOB member since 2015-05-28)

system · June 29, 2015, 4:04am

Please help me for getting solution on above problem.

Thanks,
Venkat

venkat21 (BOB member since 2015-05-28)