My Oracle Support Banner

OBIEE 12c: Output File Contains No Column Names When Created By An Agent With A Conditional Analysis and EJB (Doc ID 2659925.1)

Last updated on APRIL 15, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 to 12.2.1.4.0 [Release 12g]
Information in this document applies to any platform.

Symptoms

An Agent is configured with a Conditional Analysis, and invokes a Java Method (EJB) via the Action Framework so that the content delivered by the Agent is written to an output file on disk (instead of being sent to email, for example).  For reference, see:

     OBIEE 11g: How To Create and Invoke Enterprise Java Beans (EJB) Using The Action Framework (Doc ID 1610118.1)

The Java Method has an outputFilename parameter that can be set so that the output file will be created with a specific name, or the output file will be created with a name that is derived from a column in the Conditional Analysis.   For example:

     Edit the Agent > Go to the Actions tab > Click on "Invoke a Java Method" and "Edit Parameters" > Click on the outputFilename parameter

     Select "Change type of value" = Value, and enter a filename (for example: "MyOutputFile.txt")
     or
     Select "Change type of value" = Request Column, and select a column from the Conditional Analysis (for example: the "Products"."P4 Brand" column)

After migrating from OBIEE 11.1.1.7.x to OBIEE 12.2.1.4.x, the following behavior was observed:

With "Change type of value" = Value: The output file contains a header comprising column names separated by commas. For example:

     P4 Brand,T05 Per Name Year,C50 Region,1- Revenue
     HomeView,2013,AMERICAS,3073842.26
     HomeView,2013,APAC,1975422.53
     ...

With "Change type of value" = Request Column: The output file contains a header comprising only commas; the column names are missing. For example:

     ,,,
     HomeView,2013,AMERICAS,3073842.26
     HomeView,2013,APAC,1975422.53
     ...

In OBIEE 11.1.1.7.x, in both cases, the output file contains a header comprising column names separated by commas.

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.