BCA or local / Where Variable Processing Occurs

[LearningSql]

Hello All --

I'm new to Business Objects and wanted to ask about where the processing of variables actually occurs AND how to optimize long running queries.

I am running BusObj 5.1.6 with multiple universes of data -- but only using 1 universe at a time. I've created a few reports to bring back data as well as created some variables.

Here's the question:
With the variable -- where does the variable get calculated, on your local machine where you are pulling data to OR on the BCA Server? I imagine on the local computer but I wanted to confirm that notion.

Is there documentation on how to optimize one or the other to speed up Results from the Business Objects queries?

Thanks in advance -- I'll learn this all some day.
PJ

 

[skrandel]

Variables are processed when the reports are viewed.

If you are experiencing slow performance at the report-level, you should clean up unused variables, and formulas. You should use if-then-else as little as possible.

Also, make sure your measures are aggregating in the SQL. This means they have SUM(table.column) in the select portion. Reducing the number of rows speeds things up.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[LearningSql]

Thanks Steve for the response.

I understand what you are saying about the "variables are processed when the reports are viewed". I am going to assume that the variables are processed if viewing the data withing the Business Objects platform.

If I save a job to the BCA Server and save the file as a "text file" then am I to assume that the BCA Server does the processing on the variables and then saves the results as within the outputted text file? I would assume such as if I open the text file in notepad or other text viewer that the variables have been processed.

Or am I way off base here?

Thanks again -- I'm learning.....
PJ

 

[skrandel]

You have it right.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com