Obiee Essbase Integration - Time Dimension Issue — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Obiee Essbase Integration - Time Dimension Issue

Received Response
1
Views
1
Comments
1008490
1008490 Rank 3 - Community Apprentice

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

Answers