Smart View Retrieval Time on LTM Members in FCCS

Content

Hi folks,

Hoping someone may be able to assist with what I feel should be a simple calculation (I'm very new to coding member formulas in FCCS).

I have created LTM members (Jan_LTM-Dec_LTM) in our Period dimension for reporting and I find it takes me over a minute to refresh the values in Smart View for the whole year and some users are experiencing even longer times or timing out entirely but the members are yielding the correct results. I've attached my code for the Jan_LTM member (same for other members with periods shifting).

I hard-coded values per a tip from an online article for performance.