Skip to Content
Former Member
Aug 01, 2007 at 07:45 PM

Dynamic Cascading Prompts in XIR2


Post Author: crystalappu

CA Forum: WebIntelligence Reporting

Hi All,

We are having a problem while using Dynamic Cascading Prompts (DCP) in BO XIR2. While using DCPs and after drilling-down on a value, when we look at the SQL generated, we only see the value drilled-down on and not the higher level values. This is causing incorrect data retrieval. Ex - Lets assume we have a DCP that includes Country, Region and City. If we drill down and choose "C1" for Country, "R1" for Region and "CT1" for City, only "CT1" appears in the WHERE clause of the SQL. If this component "CT1" is used in another Country, the report would reflect wrong results. Is there any workaround by which we can include the higher level values as well in the SQL? Thanks.