Can we have a formula on an upper level member on ASO cube?
SummaryCan I place a formula on "YerTotal" on an ASO cube
I have a problem when we move data from Essbase to an ASO cube. The FTE data is not supposed to aggregate on YearTotal. I need to calculate the Total based on some conditions. Can I apply a formula to a rollup member in ASO??
If not possible, I will create another level 0 member where I will place the formula and I will use it for the reports as Year Total but I wanted to see if I could just place a formula on an upper level member on an ASO cube.