cancel
Showing results for 
Search instead for 
Did you mean: 

Prompt with List of Values Error BI 4.1 SP3

christian_key2
Participant
0 Kudos

Hi,

I have a report that uses a .UNX universe. When I add a new prompt to the report and select 'Prompt with list of values' in the prompt properties window and run the query then I get an error. The error message is:


Invalid Prompt definition. (IES 00005) (Error: INF)

If I edit the prompt and deselect 'Prompt with list of values' the report runs fine and I can add my prompt value. However I require the list of values to be shown for the prompt.

Has anyone else seen this and can anyone offer an explanation and/or a solution?

Thanks,

Chris

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Chris,

I got also the same issue in BI4.1 SP3 for a particular universe.

After my investigation, I have found that it was due to some object names in the universe which contain the  character '@'.I have removed it. Then, all was working fine.

Best regards,

Ben Nacef Wafa

christian_key2
Participant
0 Kudos

Hi Ben,

Thanks for your post. I am pleased that you were able to find the issue with the universe and feed it back to myself and Laura at Kallidus.

Best regards,

Chris

Answers (1)

Answers (1)

former_member4998
Active Contributor
0 Kudos

Hi

Can you please provide the error prompt definition... i think you have not defined correctly list of values syntax at prompt level. please check the below links.

http://www.bidwbooks.com/using-functions-with-universe-objects/

http://eblab.sysu.edu.cn/uploadfile/200864183321539.pdf