Need the values of attribute group to be displayed in One-Row format in OTBI

BAS AGILE

Description

We have some EFF as attribute group. When we run OTBI analysis, it shows one record per row for attribute group. It causes the report shows few parts. For example, we have Countries field (it is attribute group style), if one part has 250 countries, the report will shows 250 rows for country value. The limitation of record of the report is 50K. The analysis will only show 200 parts. But we have 10K parts needs to be in the report. So, if Oracle can give Row-Wise format for Attribute group, we could have one report to cover all parts. 

We need a new selection in Subject Area/Item Revisions Real Time/Main/EFF attribute to shows data in one row.
Such as Part country1;country2;country3;country4;country5
The cell contains all countries with semicolon delimiter. 

Note: it should like BOM's reference designator which has two display selection.

 

Use Case and Business Need

Example of Use case :

Currently, part has 2 countries in country attribute group field. The report will display two rows for this part.
part country1
part country2
(Note: this is row-wise format and out-of-box setting)
We need the report shows one row.
Part country1;country2
The cell contains all countries with semicolon delimiter.

So in subject area, I should see two selections for this attribute.
attribute name
attribute name row-wise 

Original Idea Number: c80d14cb7e

Albert Liu

The solution: Select column and edit formula, use LISTAGG function.

Albert Liu

If we have multiple attribute groups, LISTAGG function will have duplicate values.

We still need solution for multiple attribute groups output.