It would be extremely useful to filter choices based on values contained in other fields.

Specific example is where customer desires to analyze sales by a number of geographical dimensions: Continent, Reqion, Area, etc.

We cannot find a way to limit choices of Region based on the selection of Continent. Only workaround we can come up with is to use a multi line udf validated by udt and have each user customize each ALE to create views for each Continent, then for each Region, etc.

The ability to filter the list available for each subsequent dimension would make the advanced scripting much more powerful and enhance user experience.

by: Eric L. | over a year ago | Integration