OBIEE 12c: Cells Get Merged In SmartView When You Set "Repeat In Each Row" In The "Table View Properties"
Last updated on JULY 10, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms