Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Export to CSV issue after invoking EJB using ActionFrameWork

Question
1
Views
0
Comments
Arindam Saha
Arindam Saha Rank 2 - Community Beginner
edited Aug 13, 2024 7:13PM in Oracle Analytics Cloud and Server

I have followed a similar documentation as outlined below, in OBIEE 12.2.1.2.0

Everything seems to be working fine, except for the csv files. While I'm trying to save the analysis in CSV format via EJB using ActionFramework, the csv file exports but it contains HTML tags in it. It has the data in it, but the format is HTML, something like below:

<!DOCTYPE HTML>^M

<html dir="ltr" lang="en"><head><meta http-equiv="Content-Type" content="text/plain; charset=utf-8"><meta http-equiv="Content-Language" content="en"><title>Business Name</title><link href="res/v-DBoTHFvj6ls/s_Alta/b_mozilla_4/common.css" type="text/css" rel="stylesheet"><link href="res/v-DBoTHFvj6ls/s_Alta/master/custom.css" type="text/css" rel="stylesheet"><link href="res/v-DBoTHFvj6ls/s_Alta/master/master.css" type="text/css" rel="stylesheet"><link href="res/v-DBoTHFvj6ls/s_Alta/b_mozilla_4/views.css" type="text/css" rel="stylesheet"><link href="res/v-DBoTHFvj6ls/s_blafp/b_mozilla_4/custom.css" type="text/css" rel="stylesheet">

^M

^M

</head><body class="masterOBIEE GoBody"><table class="ViewTable" cellspacing=0>^M

<tr>^M

<td class="ViewCell" vid="o:go~r:report" sid="eu4p1kvtppjusd435sme6d4t1m" pid=""><div class="ViewContent" id="o:go~r:reportResult" result="finished" options="bs" viewType="compoundView" viewName="compoundView!1"><Div class="ViewContainer" id="o:go~r:report~v:compoundView!1ViewContainer" vid="o:go~r:report~v:compoundView!1" viewType="compoundView">^M

<table class="CVTable" cellspacing=0>^M

<tr>^M

<td class="CVView" align=center valign=top style="vertical-align:top;" vid="o:go~r:report~v:compoundView!1~v:titleView!1" sid="eu4p1kvtppjusd435sme6d4t1m" pid=""><table class="CVFormatTable" style="width:100%;" cellspacing=0>^M

<tr>^M

<td class="CVFormatCell" id="o:go~r:report~v:compoundView!1~v:titleView!1ViewContainer" align=center valign=top style="vertical-align:top;" viewType="titleView">

<table class="TitleTable" cellspacing="0" cellpadding="0" style="" width="100%">

<tr><td tabindex="0" id="titleView!1TitleName" class="TitleNameCell" style="" title=""><label for="titleView!1TitleName">Business Name</label></td></tr></table></td>^M

........

If anybody has implemented the same with OBIEE 12c, have you been able to export csv file in correct format ?