Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Obiee Essbase Integration - Time Dimension Issue
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
-
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?
0