Need help to create object using dual

building semantic layer
1

Hi,

Please help me with the select statement in an object.

Select (Select count(Table_name.column_name) from ready_queue) + (Select count((Table_name.column_name)) from working_queue) from dual.

Thanks & Regards,

JAASI (BOB member since 2004-06-08)

2

What are you trying to accomplish? Why are you trying to involve the DUAL table?

Andreas :de: (BOB member since 2002-06-20)

3

Thats the select statement to be used for an object in the universe. Its an existing field in a HTML report that is being converted to BO reports.

JAASI (BOB member since 2004-06-08)

4

Maybe it’s a guide as to what you should be doing in terms of your universe design – but I don’t think you should expect to use the statement as-is. What is it supposed to be doing?

Anita Craig :us: (BOB member since 2002-06-17)

5

Hi,

Thanks. I was thinking these were some advanced queuing techniques in Oracle, but found out that these are tables. I am done with this now.

Regards,

JAASI (BOB member since 2004-06-08)