Obiee Essbase Integration - Time Dimension Issue

Question

Hi All,

I am creating a report Source as Essbase Cubes. Every thing is gone well. when I created a report with Time hierarchy and measure i am getting below error

[nQSError: 42015] Cannot function ship the following expression: AggrExternal(GROSSCON_MEASURE by [ Pp.Gen1,Dim Time, Pp.Gen1,Dim Time - Member Key] ). (HY000).

But when i create the same report with Year column, and measures it is working fine.

Next I change the Hierarchy type from TIME to Ragged Then report is working fine but Time series Measures are not populating.

Please Suggest. Thanks in Advance

[Deleted User] · Answer

1008490 wrote:

Next I change the Hierarchy type from TIME to Ragged Then report is working fine but Time series Measures are not populating.

How can TIME be a ragged hierachy? http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/ragged-variable-depth-hierarchy/

Are you living in a space-time-continuum where some years don't exist or are missing a months?