ASO Member Formula SV Issue
SummaryASO Member Formula SV Issue
Dear Essbase community gurus,
We have an application where we are loading beginning balance in "BegBalance" period and then loading activity data for remaining periods for Jan through Dec. I wrote a member formula on an currency dimension member called "Functional Calculated". It appears to work just fine but in Smart View, it sometimes clears that data when performing query actions such as drilling into the child members and keeping or removing only. We know that it impacts performance if we remove the nonemptytuple statement. Any advice on rewriting the member formula to calculate ending balances?