Hi,
I am creating the Cascading List of Values in the Universe.
1) I have 'Last Name' and 'Home country' fields in the universe.
2) I have created the objects for the Last Name and Home country from the tables.
3) I have created another object called 'LOV Last Name' with
selection - Last Name from the table
where condition - @Select(Package\Homecountry) In @Prompt('Select Last Name','A','Package\Homecountry',multi,constrained)
4) I also have created the condition filter with below code
where condition - @Select(Employee\Last Name) InList @Prompt('Select Last Name','A','LoVs\Lov Last Name',multi,constrained)
But while click on the parse for the above condition, it is giving 'this object is already available' error.
My requirement is, in the webi query prompts first i have to select the Last name after when i selecting the Home country in the second prompt
i should get only the country corresponding to Last name.
Thanks for help