Question

Business Analytics - Measure item - min or max values

  • 23 August 2020
  • 1 reply
  • 198 views

Badge +2
  1. When I have a measure like “Price”, i don’t want this to sum up when in a BA or BR report, the summary happens based on repeater fields. If it was “Value” or “Qty” , Sum makes sense. Is this possible?
  2. Is there any way the Min or Max value (like in Oracle Grouping) can be displayed?

1 reply

Userlevel 1
Badge +3

Business Reporter always uses SUM() when aggregating, for repeaters, currently this is the only supported operation from the server.

 

There are some options though.

  • If the data volume is not large (may be couple of thousands), it is possible to bring all the rows to the report and do the min or max operations using Excel functions.
  • Create an IAL for your requirement (exact report query) and create a Quick Information Source and fetch all values to the BR report
  • If this information is available in a light item or dimension item, BR will always return data as “MIN_VALUE-MAX_VALUE”. If both min and max the same, will return only that value.  e.g ABC-ZET, 10-25. This way may be you can extract data from EXCEL using the excel functions.
    • You could create a custom (information source) attribute from an existing information source as a light item.

Hope this helps.

 

\Sanjaya

Reply