Cascading Prompt Issue in BO XI 3.0

building semantic layer
1

Hi All,
I have created a cascading LOV "Billing Month"in the Universe.It works fine for the LOV when I put the object “Billing Month” in the Query Filter panel as a Prompt and Refresh the report.

But the query it generates has only the filter condition for the “Billing Month” say “April” as given in the prompt value and not the “Billing Year” is considered in the query filter.So what is happening is that the query fetches April month data for all the Billing Years available in the db.

Is it a BUG or I am not doing it in the proper way or is their any alternative way to implement it?

Many Thanks & Regards,
Sandeep

sandeepxyz (BOB member since 2009-03-06)

2

BO Gurus,
Can anyone please let me know with the solution.

Regards,
Sandeep

sandeepxyz (BOB member since 2009-03-06)

3

That’s the way it works. Only the final value gets input into the query SQL. The entire point of a cascading LOV is to manage the selection process; it does not include the intermediate selections as a part of the where clause.

Dave Rathbun :us: (BOB member since 2002-06-06)

4

Which in IMHO is a pitty, and I wonder if/when SAP will offer more useful cascading prompt fetaures for WebIntelligence.

Andreas :de: (BOB member since 2002-06-20)