DLR rule takes 45min vs1min after member formula was added. Filter doesn't include member w/formula
Summary:
DLR rule takes 45min to run vs 1min after member formula was added to the Accounts dimension. DLR Source filter selection doesn't include the member with the formula. We do not see the impact on smart view retrieval time. We also created an export that took about a min to run. However DLR has an issue. Does anyone encounter this problem and what was the workaround?
Content (required):
We added member formula to the member of Accounts dimension in Planning ASO (Hybrid) application. The member formula is:
Case
When (IsLevel ([Entities].[Total Geography].CurrentMember,0)) theN
([7000000016]+[EMPCOMPSAL]+[COMMISSION]+[TOTSEVRNCE])*(Emptaxrate,inputentity)