Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can we have a formula on an upper level member on ASO cube?

Received Response
21
Views
1
Comments
Mcaballero98
Mcaballero98 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

Summary

Can I place a formula on "YerTotal" on an ASO cube

Content

Hi,

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.

 

Thanks very much 

 

Manuel Caballero

Answers

  • GlennS_3
    GlennS_3 Rank 4 - Community Specialist

    Yes, you could could have Formulas on upper level members  if the dimension is tagged as dynamic. It could mess up other things like time balance accounts.

    But ever better you could tag the FTE measure as Time balance First,Last, or average. Assume you tag it as time balance last, then if Jan, Feb, Mar rol up to Q1. Q1 would equal the Mar value. YearTotal would equal Dec.  With First, it would be Jan in all cases. Average would average the months.

    Time balance can skip missing and zero values as options if you want to turn that on.