My Oracle Support Banner

OBIEE 12c: Cells Get Merged In SmartView When You Set "Repeat In Each Row" In The "Table View Properties" (Doc ID 2415505.1)

Last updated on JANUARY 04, 2021

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


Using SmartView, the Excel cells may get merged when inserting the following table view.

The style of OBIEE table view is set to "Duplicate values: Repeat in each row " in "Table View Properties."

You can see this issue on SmartView version, and


Steps to replicate the scenario (using SampleAppLite):

1. Login to OBIEE and create a new analysis with the below columns selected.

Base Facts.Revenue
Base Facts"."Billed Quantity

2. Click "Result" Tab, and select "Table" , Click "Edit View"
3. Click "Table View Properties", Check "Repeat in each row" in "Duplicate values" section, and Click "OK"

4. Save the Analytics.
5. In Excel, connect to OBIEE via SmartView, and insert the table view that was created in the step4.

You can see the cells in the Products.LOB column are merged in SmartView.



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.