Prompt with List Of Values

[former_member222671]

Hi all,

do you know if there is a limitation concerning the usage of prompts with a LOV coming from a .unx universe?

We migrated a .unv universe to .unx and found out that the LOV won't work when using Lumira.

Also applying corrections to the SQL-statement won't fix the issue.

It is a complex statement and we always get the error message:

[Vertica][VJDBC](3436) ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in the SELECT clause

But we have all these expressions in the SQL statement.

We are currently using Lumira 1.31.

Thanks and BR

Agnetha

[former_member183750]

Hi Agnetha

Can you please elaborate on "LOV won't work"? What happens? Errors? Behavior? Symptoms?

As I am not sure of the above, perhaps this KBA will help:

2366241 - Support for Universe List of Values based on Custom Hierarchy in Lumira

- Ludek

Senior Support Engineer Product Support

Follow us on Twitter (#SAPLumira)

Got Enhancement ideas? Use the SAP Idea Place