nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ALM and SELECT clause on a Line Item Subset

LouiseBourgonjon

Hi Anaplan community,

I am wondering if I will be able to setup ALM if I have a SELECT clause selecting one list item of my line item subset.

Kind regards,

Louise

Accepted answers

Misbah

@LouiseBourgonjon

You shouldn't have any issues. But you can still go ahead and replace SELECT with LOOKUP.

Create a dimensionless module and insert one line item. Format that line item on LIS that you have and pick one of items from the LIS that you want to hardcode.

rob_marshall

@LouiseBourgonjon

As @Misbah you shouldn't have any issues as those line item subsets are not production lists, but it is still best to use Lookups. To do this, create a SYS LISS properties module with the LISS as the Applies To. Now you can use it like any other properties module.

Rob

All comments

Misbah

@LouiseBourgonjon

You shouldn't have any issues. But you can still go ahead and replace SELECT with LOOKUP.

Create a dimensionless module and insert one line item. Format that line item on LIS that you have and pick one of items from the LIS that you want to hardcode.

rob_marshall

@LouiseBourgonjon

Rob

tomgilbert

Hi @rob_marshall - quick question on this old post.

I tried using a lookup on a parent item in a LISS and it was not working. I set the default value to look up on in SYS module as described in Misbah's comment, but I think the issue is that the lookup doesn't work for parent items in a LISS.

Is this expected behavior? If so, can I use Select on the parent LISS item without causing any ALM issues?

And just for a little more context- I need the LISS item to be flagged as "Is Summary?" in order to achieve the desired indentation and formatting for my output table. Otherwise I could lookup on the item without any issues.

Thanks in advance!

callkredivo24jm

Kamu bisa Pembatalan Pesanan Kredivo, kamu untuk bisa dibatalkan dengan wa+62812841117. mengirimkan permintaan pembatalan kredivo, Untuk melakukannya.

callkredivo24jm

Kamu bisa Pembatalan Pesanan Kredivo, kamu untuk bisa dibatalkan dengan wa+62812841117. mengirimkan permintaan pembatalan kredivo, Untuk melakukannya.

Quick Links

Can you help?

Unanswered questions

An Update on Anaplan Audit Log Reporting: A No-Code Approach
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…