How to merge rows if their 2 columns are the same in OTBI Analysis?

Question

Hello,

I have an analysis where I'd like to merge multiple rows if they share the same value for "Item Description" and "Unit Price".

Example:

| Item Description | Unit Price | Accounted Amount |

| Pencil                    | 35               | 70                                |

| Bucket                  | 15                | 15                                 |

If my current analysis shows these rows, 2 rows of Pencil should be merged into one.

I was trying to do it with SQL GROUP BY but couldn't find any way to use an SQL query directly on current analysis.

What I've tried so far is:

* Using Advanced SQL Clause form in Advanced tab, but failed.
* Aggregation on columns in Criteria tab, but I couldn't since these rule depends on 2 columns not one.
* Group feature in Results tab, but it relies on existing values in a column, which is still not a solution for both columns

Rojhat Sinan Balka · Answer

Thanks for the response. Tried and this doesn't effect the result, even visually. One of them shouldn't be visible. There are still two rows with the same Item Description and Unit Price

Rajasekhar Bandaru-Oracle · Answer

Hi Rojhat Sinan Balka

Can you please try the below

Login into BI application with BI Admin user—>Navigate to catalog shared folder of the OTBI analysis report—>Click on Edit—>Click on Criteria—>Navigate to catalog column(Item Description)—>Click on Properties—>Click on column format tab—>select Suppress option and click ok and save the report and validate the results.