Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 26 Oracle Analytics and AI Lounge
- 311 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.7K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 117 Oracle Analytics and AI Trainings
- 24 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Merging Transaction Lines
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?
Answers
-
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")
0