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

A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385