We help IT Professionals succeed at work.

MDX Recursive Critical Problem

619 Views
Last Modified: 2013-11-16
Dear Friends,
I have this calculated member that If I execute for begin of the year like 2007-01-02, takes 2 seconds, but If I executed for a date in the end of the year like 2007-12-31, it takes hours or return a bug!
The problem is the recursive calculation... how can I fix the critical problem?

Is not possible to save the values from cache?
How can I use the CALCULATION_PASS_NUMBER, CALCULATION_PASS_DEPTH and SOLVE_ORDER... could be used to improve this calculated member?

CREATE MEMBER CURRENTCUBE.[MEASURES].CMF_FPU_ActTotalAcumu
AS
CoalesceEmpty(
(
[Measures].[CMF_FPU_ActTotalAcumu],
[DimTime].[Hierarquia].PrevMember,
[DimTime].[Ano].CurrentMember),
NULL
)
+
([Measures].[CM_ValorCarteira_DataPrev]*(([Measures].[NrDiasOcorridos])-1))
+[Measures].[NC_ValorCarteira]
-[Measures].[CMF_FPU_EBTu]
+[Measures].[CMF_ContaLiquidar_MAX],
VISIBLE = 1  ;  

CHEERS!!
Comment
Watch Question

Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.