Skip to Content
0
Former Member
Jun 10, 2009 at 02:29 PM

Cascading list of values not correct

30 Views

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