Cascading Prompt doesn't work in BO 4.0

[Former Member]

Hi,

I want to create a cascading LOV in Information Design Tool with 2 dimensions, i.e:

Region --> City (LOV of City is subordinated to Region User Selection).

In List of Values tab of IDT I've created one LOV based on query panel with one dimesion "City" and on query filter one prompt on Region.

this is the code:

SELECT DISTINCT
  "City"
FROM
  "business Layer"
WHERE
  (
   "Region"  =  @prompt('Region','A','Region',Mono,Constrained,Persistent,,User:-1)
   AND
   "Business Layer"."REFERENCE_DATE"  =  @prompt(Key Date)
  )

I've linked LOV to dimension City.

I've created one report with one prompt on City but when I launch the report an error occurs:

"Circular references : check your @select and @where calls (QTJ 00511) (WIS 00000)"

part of details:

"...Caused by: com.businessobjects.sdk.core.server.ServerException: Circular references : check your @select and @where calls (QTJ 00511)..."

Can you help me to solve this issue?

Thanks

Marco

-

---

System Info: SAP BO 4.0 SP 2 patch level 7

SAP BW 7.01 SP9

Edited by: marchino on Nov 18, 2011 4:32 PM

Edited by: marchino on Nov 18, 2011 4:36 PM

[former_member1310099]

Hi,

Here are the steps to create cascading LOV's for the desired objects.

Tools menu > LOV > Create Cascading LOV > Then select your required object and move to the right side pane > Then GENERATE LOV.

Hope it helps.

[Former Member]

That is for Universe designer.

The original poster is requesting a solution in Information Design Tool

[Former Member]

Suggest you to open a new thread with a clear elaboration of the requirement rather that posting in a old and closed thread..