using @prompt in select clause

[Former Member]

hello,

according Designers Guide @prompt can be used in select/where clause, it works fine in 'where' but i can't force it work in 'select'.

Here's object properties:

-

---

select:

@Prompt('IMEI:','A','SIM\IMEI',Mono,Free,Persistent)

(nothing in where clause)

-

---

when I press 'test' i get Invalid definition(UNV0023) error. that's weired because this universe seems to be parsed ok on another server. my BO is XIR2.

[former_member142702]

Hi,

have you added any tables in the object you defined?

Regards,

Stratos

[Former Member]

no. should I?

[former_member142702]

If you want to get a valid statement when you check the syntax of your statement, you should. What kind of data source do you have there?

Regards

Stratos

[Former Member]

i connect to oracle throw oracle client.

>If you want to get a valid statement when you check the syntax

so you mean i don't need to check syntax in this case? and even if i get syntax error i still can use this universe and this object?

[Former Member]

i don't understand why i shoul'd add table to this object, it's just a prompt

and i use this object in other objects as subquery

[former_member142702]

Exactly. I will recommend NOT to add a table there in order to avoid getting more rows than you expect due to an unwanted join.

Regards,

Stratos

PS: Just test if the object works in your reports.

[Former Member]

well i think you're right, there's nothing bad that after universe parsing i get errors, reports work anyway.

thank you!