To convert BSO member formula to MDX
SummaryTo convert BSO member formula to MDX
Need help in converting a BSO member formula to MDX. Here BegBalance & TotalYear both are level 0 Period dimension member. and BegBalance is taking value of previous year totalyear member value. TotalYear is not YearTotal high level member of Period dim.
"BegBalance" = @PRIOR("TotalYear"->Budget, 1, @XRANGE(&PrevYear,&BudEndYear));
I just tried but could not proceed with logic as i have no experience in it. Please provide pointers.
CASE WHEN (IS([Scenario].CurrentMember,[Budget]))