MDX Performance Issue
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