I've created a universe based on an SAP cube. In that universe I've created a cascading list of values.
My problem is that the child data is not correctly linked to its corresponding parent but repeated all the time.
E.g. I have a LOV with two fields, Country and city with following data:
Country = USA and UK
City = New York, Los Angeles and London
When I create a prompt in a WebI-report, the LOV will repeat every city on every country.
The result is:
USA
- New York
- Los Angeles
- London ????
UK
- New York ????
- Los Angeles ????
- London
How can this be corrected that the correct city is linked to the correct country?
Lieven