Invalid Table Name error while @prompt

building semantic layer
1

All,
I am using Oracle as back end database and XI R3 as front end. I was creating a @prompt condition as following definition

@Prompt('Enter or Select an Invoice Year: ',‘C’,‘ATT Long Distance Detail\Invoice Year’,Mono,Free).

I am getting Invalid Table Name error. Let me know your thoughts.

Regards,
Preddy

preddy (BOB member since 2005-12-01)

2

Preddy,

This maybe a misleading error message. I’m not aware that ‘C’ is a valid type.

Try ‘A’ instead and see if you still get the error.

Steve

steveayres :uk: (BOB member since 2006-11-23)

3

Steve,
I am still getting the same error even I changed to ‘C’ to ‘A’.

Thanks,
preddy

preddy (BOB member since 2005-12-01)

4

If what you have posted is the entire sql, then you will get the error because you’re not referencing a table. Normally a prompt is a part of a condition, like:

table.year_number = @Prompt('Enter or Select an Invoice Year: ','A','ATT Long Distance Detail\Invoice Year',Mono,Free)

If you don’t want to use it as a condition, but still want the prompt, then ignore the parse error and try using the object within a report, using at least one “real” object that does reference a table.

Dave Rathbun :us: (BOB member since 2002-06-06)

5

Thank You all.

preddy (BOB member since 2005-12-01)