BO4 --- group by does not return data

building semantic layer
1

We’re building a new universe using BO4. A simple query:

Select
count(A.ban),
B.seg_id
from
Bill A,
Segment B
where
A.billing_account_key = B.billing_account_key group by
B.seg_id

Does not return data. Message from BO: “no data fetch” (at the right-lower corner of the screen, the “partial data” warning sign is flashing).

Meanwhile, using the query from a SQLPLUS prompt (we’re using Oracle), correct results are returned.

Does anyone know what could be the problem when we build the universe?

Any help is appreciated,

Tao Zuo
US Cellular (Chicago)

Listserv Archives (BOB member since 2002-06-25)

2

Meanwhile, using the query from a SQLPLUS prompt (we’re using Oracle), correct results are returned.

Does anyone know what could be the problem when we build the universe?

The likely cause is the control settings in the universe. Open the universe in designer, goto File|Parameters… when the dialog opens, select the Controls tab - make sure that the appropriate setting are made, i.e. an approp execution time i.e. 10 minutes and approp no. rows, i.e. 10,000.

Brian Patterson

Listserv Archives (BOB member since 2002-06-25)

3

You said :

Does not return data. Message from BO: “no data fetch” (at the right-lower corner of the screen, the “partial data” warning sign is flashing).

Meanwhile, using the query from a SQLPLUS prompt (we’re using Oracle), correct results are returned.

Your query is timing out at database meaning Resource limit has been exceeded at
either BO or at RDBMS end.
Increase the control limit for the query to run in the designer by setting up
Universe ‘CONTROLS’ parameters.

Hope it helps.

Chandra

Listserv Archives (BOB member since 2002-06-25)