0 Replies Latest reply on Jan 26, 2018 5:33 PM by Arindam Saha

    Export to CSV issue after invoking EJB using ActionFrameWork

    Arindam Saha

      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 ?