Adding a common line item associated with a single list item

harshitha.narayan

Hello all,

Can you please advice how to add "line item associated with a single list items"?

In the attached screen shot,

•MU approved/agreed and

•GS approved

are list items and I have created a nested dimension in module, such that the line item is common for these list items.

Now I need to add, the columns highlighted in yellow but I am unable to get it.

Can you please guide on it.

Thank you,

harshitha N.

add_line_items_-_nested_dimension_149237.PNG

Accepted answers

harshitha.narayan

Thank you for the reply @Misbah!

To achieve the desired results, I created another module and in that module pulled out line items "TTL GC (curr month)" for list items "MU approved/agreed" and "GS approved" by using SELECT functionality and this sorted my issue. I have attached the screenshot of what action I have taken.

add_line_items_-_nested_dimension_-_answer_149685.PNG

All comments

Misbah

harshitha.narayan@sony.com

You can not have a line item associated with list items. Line items are applied to the entire list (or in other words dimension). There will be some empty cells that we call Sparsity in Anaplan language, that is fair but there is no slice and dice in such cases.

If it is for reporting purpose then I would say consider using SHOW or HIDE options.

Thanks,

Misbah

Miz Logix

harshitha.narayan

Thank you for the reply @Misbah!

add_line_items_-_nested_dimension_-_answer_149685.PNG

Misbah

harshitha.narayan@sony.com

Glad that you figured it out but I would advise not to use SELECT. Instead you can use LOOKUP to avoid getting into scalability issues.

Thanks,

Misbah

Miz Logix

harshitha.narayan

I did try using Lookup but it did not give me the results. For any similar issues in future shall use the lookup functionality.

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…