ASO - Performance Issue

Hello

I'm trying to make sure that I am asking question with all relevant context.

Account member X use formula that goes something like NonEmptyCount( {Leaves([Product].CurrentMember)},[ABC],exclude_missing)/ [BCD]*100

ABC and BCD are stored account dimenstion members.

This formula works fine when I retrieve through smartview (2 seconds).

I've integrated the cube to OBIEE. In BI, I select period combination (using between function for time dimension) eg 2012 Q4 and 2013 Q3 . MDX runs for 350 secs before I get answer. It goes like this..

With  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