Hyperion Essbase (MOSC)

MOSC Banner

MDX Performance Issue

edited Sep 1, 2016 5:00AM in Hyperion Essbase (MOSC) 1 commentAnswered

Hi

I'm facing issue with ASO MDX query that is generated through BI integration.  For a period dimension, when between clause is selected MDX member is selected as

set [_Build Period4] as 'Filter([Build Period].Generations(4).members, ( NOT (([Build Period].CurrentMember.MEMBER_Name < "2012 Q4" OR [Build Period].CurrentMember.MEMBER_ALIAS < "2012 Q4"))) AND ( NOT (("2013 Q3" < [Build Period].CurrentMember.MEMBER_Name OR "2013 Q3" < [Build Period].CurrentMember.MEMBER_ALIAS))))'

member [Application].[_Build PeriodCustomGroup] as ' Aggregate(filter([_Build Period4], NOT [Build Period].currentmember.SHARED_FLAG))', SOLVE_ORDER = AGGREGATION_SOLVEORDER 

 

If I try and convert dynamic build period member like the one created by entity,  [Build Period].[_Build PeriodCustomGroup] as '[Build Period].[2012 Q4]+[Build Period].[2013 Q1]+[Build Period].[2013 Q2]+[Build Period].[2013 Q3]', SOLVE_ORDER = AGGREGATION_SOLVEORDER 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center