LIS INDENTION

elaine.novel · 2023-02-28T06:28:37+00:00

There was an error rendering this rich post.

Hi Team,

Is there a way to fix the LIS Indention of those identified as Parents, other than unticking the parent button in the source module, please?

Please see screenshot for the sample indention being mentioned.

Appreciate your assistance.

Thank you, Elaine

Accepted answers

elaine.novel

Hi @rob_marshall ,

Thank you for your response. That was what I was avoiding actually due to other reports' dependency.

What I did instead is to copy the module and refer the formula to the old module, and that is where I removed the Parent ticks. Afterwhich, this is what I referred in the LIS used.

Thank you again,

Elaine

All comments

BrunoRodriguez

Hello @elaine.novel ,

Unfortunately that is how it works. The parent is defined through the sum of the line items. Please find an extract from the anapedia (https://help.anaplan.com/fd6bfccc-fd3b-4d55-b838-59cdda9c572c-Line-item-subsets) below:

"Parent line items in line item subsets

If you have a parent line item in a line item subset, but not all of its children, the value of the parent is only calculated from the line items in the line item subset.

For example, the parent line item, Total Expenses, has the sum:

Salary + Bonus + Car Costs + Phone Costs + Medical Costs

However, the Expenses line item subset only contains the Total Expenses, Salary, Bonus, and Car Costs line items.

In modules where the line item subset Expenses is used as a dimension, Total Expenses is then calculated by:

Salary + Bonus + Car Costs

If none of the line items in the sum are included in the line item subset, Total Expenses appears as a leaf item in the line item subset."

Hope that helped!

rob_marshall

@elaine.novel

In the source module where the LISS is defined, uncheck the Is Summary boolean in the blueprint area. Take a look below to see if this is what you are wanting.

Source

Result:

Source Unchecked:

Result Unchecked:

Rob

elaine.novel

Hi @rob_marshall ,

Thank you for your response. That was what I was avoiding actually due to other reports' dependency.

What I did instead is to copy the module and refer the formula to the old module, and that is where I removed the Parent ticks. Afterwhich, this is what I referred in the LIS used.

Thank you again,

Elaine

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
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…