Merging Transaction Lines

Ben Jones

I am running transaction reports from Oracle Transactional Business Intelligence.

The produced report includes various lines which net to £0 as well as minor adjustments for tax, delivery, roundings etc.

I was wondering if it is possible to create a transaction list report which merges these transaction lines?

For example:

Would become:

(The above example is using the transaction no. as an indicator to merge lines which I think is the best way.).

Can this be done through Oracle?

[Deleted User]

Can it be done? Yes. Can it be done in OTBI? Hmm yes kind of, but you won't like it.

Oracle Analytics - the actual behind OTBI - is not query-driven, but model-driven and OTBI is a set of predefined models (done for you by Oracle) which can't be modified by you.

Now what does that have to do with your question? Well the model defines WHAT aggregates HOW. Since your first screenshot shows a row-by-row, non-aggregating list, that means that implicitly there is something which defines the granularity of the "row" as being somewhere below the transaction number. What that is, I can't tell you from what you've shown here.

If you want to force an aggregation (queue the "kind of, but you won't like it"), is to tell your measures like transaction amount how to aggregate itself.

Basic example that you will need to refine:

SUM("SomeFactTable"."Transaction Amount" BY "SomeDimensionTable"."Transaction Numer")