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

Rolling forecast
Hi , I have a requirement for my stakeholder to have a medium term forecast (by month for the next 6 months) and a more detailed rolling 15-week sales forecast by day which will then feed into the wider Supply Chain planning processes over time. This needs to be updated by the Sales representants for consolidation by the…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…