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

Row Count as an ID for ADO
Hi all, I am importing a flat file into ADO. However the flat file does not have a unique identifier. I would like to use the row count as the "ID" Is there a way to create this ADO? Basically how would I do row_number() in SQL?
Building a User-Filtered Export from a Module with Multiple Selectors
Good morning everyone. I need to build a module export with some specific requirements: users can select a currency type (USD/Local), Salary Type (1 or 2), Nomina Type (1 or 2), and Version (Forecast, TS, Plan). Currently, each of these filters is driven by an independent system module published in the NUX, each…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…