how to delete unused list items

sakand

Hi,

I need to reduce the size of my model, and need to delete some unused lists. how to do that? Sorry, I am not expert.

thanks,

Shaj

Accepted answers

prabhu

Hi @sakand - To Identify unused List.

Step 1: Click General List Setting.

Step 2: Scroll to the right, you can see 3 columns

(Referenced in Applies to, Referenced as Format, Referenced in Formula)

Referenced in Applies to - List is used as a dimension in a module.

Referenced as Format - List is used as a format in line item.

Referenced in Formula - List is used in formula.

With the help of those, you can identify the lists which are not in use.

Hope it helps

SandeepB

Hi @sakand,

I believe you are looking for deleting the unused list items to reduce the module size. In that case, you are talking about sparsity in your model (Empty cells in the module). There are so many ways you could reduce the sparsity.

I would suggest you use the list subset in your list and use this subset list as part of your module dimension.

When I say subset you would be selecting only list item that is required for your module (carries data) and also easy to maintain. You can also maintain this subset through simple boolean import as well.

Let me know if you need further help with this.

Thanks,

Sandeep

All comments

naushad786

Hi @sakand ,

you can delete lists if List are not referenced in any of the modules.

Thanks,

Naushad

sakand

Thank you.

prabhu

Hi @sakand - To Identify unused List.

Step 1: Click General List Setting.

Step 2: Scroll to the right, you can see 3 columns

(Referenced in Applies to, Referenced as Format, Referenced in Formula)

Referenced in Applies to - List is used as a dimension in a module.

Referenced as Format - List is used as a format in line item.

Referenced in Formula - List is used in formula.

With the help of those, you can identify the lists which are not in use.

Hope it helps

SandeepB

Hi @sakand,

I would suggest you use the list subset in your list and use this subset list as part of your module dimension.

Let me know if you need further help with this.

Thanks,

Sandeep

sakand

Thank you Sorna.

sakand

Thanks a lot Sandeep.

sakand

Thank you Naushad.

sakand

It was helpful. Thank you.

-S

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…
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…
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.…