LOVs in Business View Manager

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