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 184.108.40.206.0 to 220.127.116.11.0 [Release 12g]
Information in this document applies to any platform.
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")
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 18.104.22.168.x to OBIEE 22.214.171.124.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
With "Change type of value" = Request Column: The output file contains a header comprising only commas; the column names are missing. For example:
In OBIEE 126.96.36.199.x, in both cases, the output file contains a header comprising column names separated by commas.
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