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)

Thanks and Regards

Akshay Sawant

Accepted answers

JaredDolich

@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.

All comments

JaredDolich

@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.

akshaysawant

HI Jared,

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

Regards

Akshay Sawant

akshaysawant

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)

JaredDolich

@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!

Misbah

@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

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

Hi Misbah,

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

Regards

Akshay Sawant

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…