IES 10901 Error

building reports webintelligence
1

Hi,

When i edit custom SQL and provided prompts instead of static values and validated. I get an error message.

“Must declare the Scalar variable @prompt… (IES 10901)”.

Please find screenshot below and assist me.
IES 10901.JPG

achaithanya (BOB member since 2007-04-11)

2

How does the customer SQL look like? Can you post it?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Hi Marek,

I’m posting here just the modified part of the SQL genereated by BO.

dbo.fn_adjusted_date(HELP_DESK. Resolved_Date) BETWEEN

@prompt(‘Resolved Date Time(Start)’,‘D’,‘HELP_DESK.Resolved_Date’,Mono,Free,Persistent,User:0) AND @prompt(‘Resolved Date Time (End)’,‘D’,‘HELP_DESK. Resolved_Date’,Mono,Free,Persistent,User:1)

From @prompt i have included this in the existing query and tried to validate. We had constant values earlier.

achaithanya (BOB member since 2007-04-11)

4

Hi,

The 3rd parameter of the @prompt() function must be a reference to a universe objects (class\object). You can’t use a column of a table (‘HELP_DESK.Resolved_Date’).

Marek Chladny :slovakia: (BOB member since 2003-11-27)

5

ok. Let me Give a Try.

Thanks for the Quick reply :smiley: .

achaithanya (BOB member since 2007-04-11)

6

Perfect Thanks a Ton it worked.

achaithanya (BOB member since 2007-04-11)

7

You’re welcome 8)

Marek Chladny :slovakia: (BOB member since 2003-11-27)