Profit & Loss Report Module - Getting Error on Revenue line item

Options
akshaysawant
akshaysawant Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor

Hi Team,

 

I am getting below error when i am trying to update Revenue line item rule in Lesson 11. Kindly help me to find out proper rule here and suggestion.  To my knowledge this error is coming due to additional dimension in source which is not part of target dimension. (Product)

 

akshaysawant_0-1614172557718.png

akshaysawant_1-1614172600503.png

 

Thanks and Regards

Akshay Sawant

 

 

Tagged:

Comments

  • akshaysawant
    akshaysawant Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor

    HI Jared,

     

    Thanks for your help and additional details  ! It worked for me. 

     

    Regards

    Akshay Sawant

     

     

  • akshaysawant
    akshaysawant Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor

    Hi Jared,

     

    One quick question as you have mentioned above in 2nd point (Your TARGET module uses the same hierarchy as the SOURCE module so SUM is not necessary since Anaplan already knows how to aggregate the data.). 

     

    But in my target module i don't have P2 Product dimension. may i know how that logic worked ? Please refer screenshot from Target module. whereas source has different dimension (Product) 

     

    akshaysawant_0-1614176742260.png

     

  • akshaysawant
    akshaysawant Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor

    Hi Jared,

     

    Thanks for explanation ! This is what I was looking for, The Anaplan methodology which work in the background. 

     

    I had tried using the SELECT function including Total Products as an element. But now i am clear how it work when you have different dimension count in source and target. 

     

    Regards

    Akshay Sawant     

  • akshaysawant
    akshaysawant Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor

    Hi Misbah,

     

    Thanks for explanation ! Exactly this what I was looking. Helpful.  

     

    Regards

    Akshay Sawant