Skip to Content
author's profile photo Former Member
Former Member

Cascading Prompt doesn't work in BO 4.0

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jan 12, 2012 at 09:18 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.