I want to make 2 predefined filters where one is dependent on the other. For example:
filter one allows to select a class from a list and filter two allows to select names from persons, but only persons from the previous selected class.
I have made a predifined filter(1) in a universe with the whereclause:
@Select(Class\Classlist) IN @Prompt('Select a class','A','Class\Classlist',multi,constrained)
The second filter so far is:
@Select(Names\LastNames) IN @Prompt('Select a name','A','Names\Lastnames',multi,constrained) @WHERE (Class\Classlist)
Unfortunately I got the message 'sql statement not properly ended. Where do I go wrong?