Essbase Studio Drill Through Report Is Returning Duplicate Records
(Doc ID 2638393.1)
Last updated on FEBRUARY 27, 2020
Applies to:Hyperion Essbase - Version 184.108.40.206.016 and later
Information in this document applies to any platform.
The customer is using Essbase Studio with User-defined/ Template SQL for drill-through reports and using SUM for some columns.
In the drill-through report, data are duplicated between columns although the source columns has different data.
For example, the following SQL does not include "AS" for the data columns:
select stateid, productid, scenarioid, sum(sales), sum(cogs) from ...
It shows following results:
stateid productid scenarioid
14 1 1 623 623
14 1 2 720 720
The two last columns should show different values.
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