Formula on IP
I've a calculation on IP sheet say variance which claculates at run time beteen 2 values. I've created query on multi provider with one basic cube and one is real time cube. I'm getting one value from basic cube and user will enter the one vlaue then I've a calculated key figure to calculate the variance.
Now I want to save the variance on real time cube. How could we achieve to get this workin.