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 JULY 10, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.0 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."
Steps to replicate the scenario (using SampleAppLite):
1. Login to OBIEE and create a new analysis with the below columns selected.
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!