BusinessObjects Board

data connection order

Did I read somewhere that xcelsius fires the connections in sequential order from the bottom up? Or was I dreaming?

I need to get the connection order right as the data brought in from one query needs to be passed out for the next.

Debbie


Debbie :uk: (BOB member since 2005-03-01)

it fires all the queries sequentially…


neetz (BOB member since 2010-11-25)

UNLESS you are using SAP BEx queries via BICS! :slight_smile: :+1:


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

Top down or bottom up? And simple Oracle, thank God. I don’t need any more complications!

Debbie


Debbie :uk: (BOB member since 2005-03-01)

All the Queries fires Parallely in QAWS from Top to bottom.


rizwan syed :us: (BOB member since 2010-07-08)

Resurrecting this one…

Dashboard working fine. Added a query that fires out the drill result of a graph to my database. I’ve got a default drill set but I suspect it’s not firing the queries in the order I think it is.

I get an connecion error, BUT the queries all go on to produce results. It’s almost like it falls over as there’ s no drilled data to pass out first time, but then it comes back and has another go - by which time the previous query has populated, there’s a default drill value now so off it goes…

Debbie

ETA: Switched “refresh-before-components-loaded” off - and it still runs. Which means the connection is firing on a trigger cell change, which means the cell is changing value as the previous query sets its drill value… :crazy_face:


Debbie :uk: (BOB member since 2005-03-01)