Invalid Prompt Definition (IES 00005)

[former_member1019749]

Hi all.

I have a derived table with prompts in the where clause and is not validating due to the error Invalid prompt definition.  I was able to get that the issue is with one prompt

@Prompt('Pre-set Day Filter:', 'C', 'Time\Day Date Range', Mono, Constrained, Persistent, { 'Today' }, USER :1)

I have the object Day Date Range already defined and validates just fine.  Is there something someone can shed some light on?

Thanks in advance!

Eileen

[nscheaffer]

What version of BusinessObjects are you on? What is the 'C'? When I build a prompt in WebI on a character field it puts an 'A' in there for me. Other than that I don't see anything wrong.

Noel

[former_member1019749]

I am in the information design tool 4.1 building a universe.  The C is for Character.

[jeff_crisp]

Valid letters for Datatypes are:

'A' - String data

'N' - Numeric data

'D' - Date data

'DT' - Date_Time data

'K - Data Type Independent

[nscheaffer]

Check out another post of mine for a tip related to Prompt function syntax.

Noel