Business Objects Formula??

[mvere]

I have a report in Business Objects 5.1.2, the reporting value I currently am showing is not correct. To be correct I need to run the db value againts another parameter depending on a certain criteria. The criteria is, I have a list of 300+ sites, they are broken up into 8 different sizes, depending upon the sizes I need to mutiply the db value by a number to come up with the correct reporting (sla) value. Shuld I do this in the universe or in the report? Does it matter?
Also what is the best way to do this.
I had been exporting the BO reports to excel and have been using a formatted excel spreadsheet but I would like to eliminate that step.

 

[blom0344]

At database level you could create a measure that is build with CASE construction:

CASE WHEN SIZE = A THEN factor1*value
WHEN SIZE = B THEN factor2*value
................................ELSE ..... END

This will be quite doable with just 8 scenarios...

Ties Blom
Information analyst

 

[ADB1]

If your data is all present in your database then you should create the column as an object within your universe. If the Case statement is to be driven by other calculations/variables within a report then you should create a variable in the report itself.

Cheers.

A.

 

[blom0344]

Take note that creating a universe object is almost always preferable (if possible). It will have to be defined only once; has much sweeter syntax than the '=if ..then .. else' construction within reporter and will allow better manipulation, cause it is coming from the dataprovider directly.
In your case a universe object seems definately the best choice...

Ties Blom
Information analyst