Which approach is better? (Related to Text, Lists and Formulas)

Hi Everyone,

I have a module which is dimensioned by one list. It has around 60k items. In this module there is one line item (Main_Text). I want to pull a string from this Main_Text line item and then use Finditem() function over that string.

Right now, the approach that I am using is to calculate them in two different line item. The second approach is to combine these two line items into one. (See the attached screenshot for better understanding)

Which one is better?

Please provide your insights based on some valid sources like Best Practices, Planual and Model Optimisation.

I would especially like to hear @Misbah , @ryan_kohn , @KirillKuznetsov , @JaredDolich , @ManjunathKN opinion on both of the approach.

Thanks!

- Shubham Chaudhary

P.S.:- There are 5 different piece of info in that Main_Text so approach 1 will have 10 line items and Approach 2 will have 5 line items.

Screenshot 2022-10-18 at 10.08.47 PM.png

Accepted answers

Misbah

@ShubhamCh

First one is better in terms of Performance of the model.

Second one is better too but in terms of space optimization but it may lead to degraded performance.

It all depends on what are you trying to achieve. If I was you I would do it in multiple line items so that I don't compromise on Performance of the model with just a trade off of some space.

Thanks,

Misbah

Miz Logix

ManjunathKN

Hi @ShubhamCh

It depends on the Size of the list to decide on which approach is better. If the number of List items are less then second approach is better.

If the number of list items are more then either of both approaches basis on certain criteria's.

I personally would go to first approach the reason is very simple although you have staged the data in different line items, your finditem calculation will not be heavy as you are referring the text line item and not calculating again. Your threads are one to one here. And Make sure to put isnotblank if your finditem has any blanks in text part.

Second approach is better here only when you already know that you used too many text line items in model and size of the model is already big.

Thanks,
Manjunath

ryan_kohn

This is covered in the Data Hubs: Purpose and peak performance best practice article, in the section on loading data vs. using formulas in SYS modules. In summary, both options are good, but splitting into multiple line items is slightly faster based on the tests made in the article.

All comments

Misbah

@ShubhamCh

First one is better in terms of Performance of the model.

Second one is better too but in terms of space optimization but it may lead to degraded performance.

It all depends on what are you trying to achieve. If I was you I would do it in multiple line items so that I don't compromise on Performance of the model with just a trade off of some space.

Thanks,

Misbah

Miz Logix

ShubhamCh

Thanks @Misbah for the reply.

Can you please also share the source, so that I can study it myself?

Misbah

@ShubhamCh

My thoughts are based on PLANS. There is no right and wrong answer here, you could prioritize any element of PLANS but to me I would always prioritize P element over any other element of PLANS.

ShubhamCh

Understood!😊

Thanks @Misbah for giving some extra details.

ManjunathKN

Hi @ShubhamCh

It depends on the Size of the list to decide on which approach is better. If the number of List items are less then second approach is better.

If the number of list items are more then either of both approaches basis on certain criteria's.

Second approach is better here only when you already know that you used too many text line items in model and size of the model is already big.

Thanks,
Manjunath

ShubhamCh

Thanks @ManjunathKN for the detailed explanation. Kudos to you 👍

ryan_kohn

ShubhamCh

Thanks @ryan_kohn for adding the article link also.😊

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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