My Oracle Support Banner

Export > Data > CSV/Excel In Analysis Results Tab, Displays The Custom Hyperlink URL code Instead Of Actual Value (Doc ID 2749184.1)

Last updated on FEBRUARY 09, 2021

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 and later
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Symptoms

After Export-->Data-->Excel or CSV, the code behind the Hyperlink column shows up,  and not the values.

The problem is common across all reports/dashboards with Hyperlinks enabled and export option Export-->Data-->Excel or CSV

This issue doesn't reproduce when export the Report to Excel, CSV or PDF using Export --> Excel or Export ->CSV.

Issue reproduces with or without "Contains HTML Markup" checkbox for the  Formula column enabled.

Steps to reproduce:

 

1. In Analytics, create a formula column:

 

2. When you run report, values show as following:

 

3. When you do  Export->Data->CSV or Excel,  see that instead of value "7 Megapixel Digital Camera" , the code behind the Hyperlink column is shown:

<a href="7 Megapixel Digital Camera" target="_blank">7 Megapixel Digital Camera</a>



Cause

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
Symptoms
Cause
Solution
References


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