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

akshaysawant
Occasional Contributor

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

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

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

@akshaysawant 

Great call out. This happens if your structured hierarchy doesn't have a top level. Make sure your lists are arranged as shown below.

Breakdown of the error:

  • This is one exception where you don't have to use SUM 
  • 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.
  • You just need to make sure there's a top level so Anaplan can sum it to the top if PRODUCT is not used.

 

Hierarchy006.png


Jared Dolich

View solution in original post

7 REPLIES 7
JaredDolich
Moderator

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

@akshaysawant 

Great call out. This happens if your structured hierarchy doesn't have a top level. Make sure your lists are arranged as shown below.

Breakdown of the error:

  • This is one exception where you don't have to use SUM 
  • 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.
  • You just need to make sure there's a top level so Anaplan can sum it to the top if PRODUCT is not used.

 

Hierarchy006.png


Jared Dolich

View solution in original post

akshaysawant
Occasional Contributor

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

HI Jared,

 

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

 

Regards

Akshay Sawant

 

 

akshaysawant
Occasional Contributor

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

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

 

JaredDolich
Moderator

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

@akshaysawant 

Right! Because your TARGET doesn't use Product you need to have a top level so Anaplan can "SUM" the product hierarchy for you all the way to the top. It can't SUM product to the first level because you may have multiple P1's.

Thank you for this very great question. Very advanced thinking!


Jared Dolich
akshaysawant
Occasional Contributor

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

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     

Misbah
Moderator

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

@akshaysawant 

 

Hijacking Mr. Dolich's thread:)

 

Let's say:

 

If your source module has 3 dimensions: Products, Customers and Countries

and your target module has 2 dimensions only : Products , Customers

 If you try to refer the data from source module to target module then there are two possibilities

1. Anaplan automatically takes the data from the top level of Countries dimension and bring it to Target module provided you have the "Top Level" Set for Countries dimension

2. Anaplan will throw you an error saying that Formula is invalid as Countries doesn't have an Inbuilt Top Level.

 

In your case you must have already Top Level Set for the dimension which was not matching between the source and target modules

 

Hope that helps

Misbah

akshaysawant
Occasional Contributor

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

Hi Misbah,

 

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

 

Regards

Akshay Sawant