nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Report output in excel has merged cells making fuller analysis difficult (e.g. running Pivots)

Jerry Stevens

Organization Name

BT Plc

Description

Merged cells in report output

- ideally the attribute 1 and 2 would repeat for all applicable rows, this would support further analysis of downloaded reports.

Report example
Attribute 1	Attribute 2	Attribute 3
1 value	Value A	value 1
		value 2
		value 3
		value 4
		value 1
	Value B	value 2
		value 3
		value 4
		value 5
		value 10
2 value	Value A	value 2
		value 3
		value 4
		value 5
		value 6
	Value B	value 3
		value 5
		value 9
	Value C	value 4
		value 5
		value 6

Use Case and Business Need

This would enable further analysis of data download both for BIP and OTBI reports adding value for large reports that cannot only be consumed by eye.

More details

a lot of manipulation is required before the downloaded report can be used for further analysis

Original Idea Number: b8d7177e43

Find more posts tagged with

Submitted

OTBI

Status: Submitted

Comments

Mark Johnson

Have you used the Analysis Table View Properties "Row Styling/Repeat cell values" or the "Value Suppression > Repeat" Column Property?

These properties will have the data repeat in the Analysis table and the exported data will also included the repeated values.

Sricharan Monigari

This is actually possible for BI reports by setting a property.

Please check https://fusionhcmknowledgebase.com/2019/03/prevent-merging-columns-in-excel-output/