Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  Rules, Element and Dimension

    Posted 11/27/20 03:12 PM
    Hello, we have this rule where the element "Month" is referred to but the dimension that exists in the "Resultados" cube is "Day"
    Month is a dimension that is not included in the "Resultados" cube, this rule works... and we notice that in the "Day" dimension the name of the consolidation level 1 are called exactly the same as the members of the "Month" dimension.
    Day Dimension:

    Month Dimension:

    The question is.. why does this works?
    Thank you, have a good day =)

    ------------------------------
    Edith Aquino
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Rules, Element and Dimension

    Posted 11/28/20 07:48 AM
    That's a feeder, not a rule. The rule will be in the Resultados cube. 
    IMO the feeder will fail, since feeders only apply at N level (days in this case) and '1 Octubre 2020' won't appear in the Month dimension. That may not matter, since Tarifa is probably a rate of some sort, which would be applied to another, fed value such as quantity. Check with Trace Feeders and Check Feeders in the rule trace in Architect/Perspectives.
    You can build feeders from detail to total but you have to put in place a link. ELPAR could work but is not advised since there may be multiple parents and you won't be able to control the sequence. Better to create an attribute where (eg) '1 Octubre 2020' links to 'Octubre 2020' in Month. This is a common requirement for budgets held at a summary level, linking back to detailed actuals.

    ------------------------------
    David Usherwood
    ------------------------------



  • 3.  RE: Rules, Element and Dimension
    Best Answer

    Posted 11/28/20 03:58 PM
    Hi Edith,

    Assuming there are no other feeders going into "Revenue" it is absolutely feasible that this feeder you have shown here works perfectly well.
    The reason for that is that "Month" does exist in the source cube where Tarifa is and "Day" exists in your Target Cube.
    As you have pointed out the element names are identical for your N-Level elements in "Month" and C-Level elements in "Day".

    As David highlighted; feeders work FROM and TO N-Level cells only. But you can use Consolidated elements on the Left or Right hand side of the Feeder statement as a shortcut for referencing all of the N-level elements that exist under that Consolidation.

    So essentially by including the !Month notation you are saying you want to Feed FROM "Octubre 2020" in the Source Cube - this makes perfect sense it is N-Level.
    And it wants to feed to the C-Level element "Octubure 2020" in your Target cube... in the background the system actually generates feeders for every N-Level element UNDER the consolidation you have targeted.

    So when your statement says that you want to feed Octubure 2020, it actually reads it as if you had typed 31 different lines of feeders and feeds every element from the 1st to the 31st.
    Note that you can feed an ancestor as opposed to just a parent element, so you could replace !Month with a hardcoded '2020' and you would see that all of the days in 2020 get fed and all other years are missed.

    ------------------------------
    Declan Rodger
    ------------------------------



  • 4.  RE: Rules, Element and Dimension

    Posted 11/30/20 07:50 AM
    Thank you all for your answers, it's all clear now!

    ------------------------------
    Edith Aquino
    ------------------------------