LOVs in Business View Manager

[Former Member]

Hi All,

I know the implementation of dynamic cascading parameters using list of values in Crystal XI.

But i need some information regarding Business View Manager.

Country > Region > City - This is my desired cascading parameter. For creating this parameter, what should be my data foundation?

Select country,region,city from customer

Can i use this query in my data foundation? I think this will duplicate the values inside country and region...

Please help me in this issue....

Thanks,

Meena

[fritzfeltus · Accepted solution]

If you're interested in getting the best performance for your DCP, try this article:

[Crystal Reports XI R1 And R2 Dynamic Cascading Prompt Performance 1.8|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e073744a-693f-2b10-b5b8-b216437cb007]

I'd recommend the chapter "Cascading LOV Data Access Tuning", it explains how you can configure your LOV to ensure on-demand access for each level of the LOV.

[Former Member · Accepted solution]

Hi Fritz,

Thanks for your quick response.

That was a useful document. But still i have got the same doubt.

how to remove duplicates while using the below command object in data foundation for the cascading list of values:

Select country, region,city from customer

Any help is really appreciated.

Meena

[fritzfeltus · Accepted solution]

I'm not certain why you are worried about duplicating data for Country and Region? Why do you think this data will be duplicated and where can you see this?

Also note that using a command object in the data foundation will cause your all values for all levels to be retrieved in one database access, which may cause unnecessary delays.