About AntonMineev

AntonMineev · ‎08-29-2022

Hi @Yogitha! Can you show me a blueprint of the second module? Maybe there is a month there and so either LOOKUP or a time change is needed (optionally a summary formula).

AntonMineev · ‎07-16-2022

Hi @aurellionugroho Ideally, archive or delete unused models (for example, you could temporarily archive level 1 or delete models of people who have quit). You should not reduce the lists, this may prevent you from passing the end-of-course test.

AntonMineev · ‎07-08-2022

Hi @muizzsk9890 1. It makes sense to write again to community support. 2. To get the badges, you need to make sure that your status is up to date and you have taken the recertification test. Details: https://community.anaplan.com/t5/Blog/2022-Solution-Architect-and-Certified-Model-Builder/bc-p/116816

AntonMineev · ‎06-25-2022

Hi @Leonolgun The problem may be that a summation element is chosen as the argument. This is a feature of the function. The solution is in my article: https://community.anaplan.com/t5/How-To/How-to-use-LOOKUP-with-summary-elements/ta-p/137853

AntonMineev · ‎06-18-2022

Hi @ssashish786 Here it is important to understand exactly how many dimensions you are interested in. In Anaplan, we create many modules (cubes) that can contain different dimensions. As a result, the model itself can contain many more than 30 dimensions. If you are referring to a limit on the number of dimensions in one module, I am not aware of it. Usually it's down to the size of the cloud space in terms of cells, but not in terms of dimensions.

AntonMineev · ‎06-08-2022

@pratikjaiswal Yes, you need a separate module with the list and its properties (like LI). This would be double work, since it corresponds to Anaplan practices and in most cases you would not need to duplicate these values in the properties (you could do a direct formula in a pinch). Overall, you will get (if you use module): 1. Ability to filter properties 2. Possibility to store some of the properties on subsets 3. Ability to output on UX 4. Ability to flexibly access properties via DCA At one of the events Anaplan said that in the plans of UX development there is a possibility of direct output of the list and its properties. But I wouldn't use this unless there's a good reason (e.g. you only need this data to be updated through ALM).

AntonMineev · ‎06-06-2022

Hi @IrfanMohammed By changing the summation method to a formula, you correct a logical error. Example: Margin, % on SKU 1 is 5% and on SKU 2 it is 10%. With the standard summation method, you would get Margin, % as 15%, which is incorrect. The summation method will re-divide the formula for the brand Margin by the revenue and get a recalculated Margin % value relevant to the brand. Attached is a screenshot that shows the recalculation. Without changing the Margin summation, the % on the chocolate will be 1000%, which is fundamentally wrong.

AntonMineev · ‎06-05-2022

Hi @mattb Your import worked correctly, the data is loaded. You need to "move" the loaded data one year ahead by using the formula OFFSET through the first year check. You will end up with a formula "IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0" that will move the data forward.

AntonMineev · ‎06-03-2022

Hi @elaine.novel What exactly are the wrong readings on the summing elements? If they are percentages, you can recalculate them by putting the numerator and denominator together separately. Example: % Margin Margin Numerator: Margin[LOOKUP: XXX], SUM Margin Denominator: Revenue[LOOKUP: XXX], SUM % Margin = Numerator/Denominator. Summary format: Formula

AntonMineev · ‎06-03-2022

@david.savarin This is a topic for a separate article, but I'll try to give a brief introduction. In order for each user to see his sum (select any versions, accounts, and so on) and not to recalculate the sums of other users, we need a proper measurement. Using Native Users can really bloat the model, because a particular report can be used by not all users of the model (extra sizing). Since Native Users has no subsets, we create a duplicate dimension and enable Selective Access for it, giving each user rights to "his" item. This way each user has his own version of the report.

AntonMineev · ‎06-02-2022

Hi @Akari1124 I suspect that you need to change the summation method. Most likely you added up the cities in the US element by 5% and got a value of 30%.

AntonMineev · ‎05-26-2022

If your formulas match, you need to check the data in the modules they refer to. If I remember the course correctly, there was a step to load data from CSV. You can use the Drill Down function on the cell (F8) to check.

AntonMineev · ‎05-26-2022

Hi @Markcol, You need to check the formulas in the other LIs, especially the ones where you see zero. For example, in Rent, the formula should check if the period is forecast and in that case take data from module OTH01. However, for the fact, take data from module DAT01. Maybe you missed the lesson with these formulas?

AntonMineev · ‎05-25-2022

In the following article, I would like to discuss a common case of model building: the LOOKUP function doesn’t work with summary elements of hierarchical lists. Among other things, this forces model builders to use SELECT and not configure Production Data for some lists. I want to present to you an alternative approach. What is the problem? For example, we have a simple module with P&L. We would like to show the user amount by account mapping: Usually, model builders use the LOOKUP function: Since these are aggregated values (e.g., Gross Profit) in a ragged list, lookups will not produce the proper values . The system will not generate an error but show 0. What is the solution? I would like to offer alternative method to help solve this problem: Use the function IsAncetor() and a Line Item Subset (LIS) Make LIS with LI “Amount” (for further demonstration in the screenshots this is “Amount LIS SUM”) Make a new module for technical mapping We need to check, which list elements are the descendants of our mapping? Use ISANCESTOR formula. Create a new LI and turn the Boolean into the ITEM of our LI with Amount Blueprint of the module after adding the mapping formula: Here we use formula SUM instead of LOOKUP, where the argument will be our LI in LIS format: Anaplan will understand the connection between the original LI and the LIS mapping. Thus, we summarize all the basic elements that are part of our mapping. This approach works well with hierarchical directories and does not require much space. All you need is to create a technical LIS and write additional notes to it and the technical mappings. Conclusions and considerations I hope this approach will help you use “LOOKUP” with summary elements, and help you avoid using a SELECT formula for summation values and use ALM with the Production list assignment. You can use this approach to avoid a SELECT formula when calculating various KPIs; for example, where you have to divide Gross Profit by Revenue. If you want to use the reporting approach (as in the example, with user selection) don't forget to use the Users dimension (I prefer Fake Users) so that everyone has the flexibility to build a report. If you use this, let me know. It will give you more motivation to share your experiences.

AntonMineev · ‎05-22-2022

Hi @Markcol! The formula is correct, but you need to double-check the time calendar and current period settings (your screenshot shows 2021, the example shows 2019):

AntonMineev · ‎05-12-2022

Great article! I will share it with my aspiring Model Builders, thanks!

AntonMineev · ‎04-27-2022

Can you attach a small diagram or blueprint? It's just my understanding that if you calculate correctly on the parts, you can then pull to a less detailed LI (you may also need to check the summation method). Of alternative ideas, use the SUM formula and technical mapping to shift 1 to the right analytics.

AntonMineev · ‎04-27-2022

Hi @Akshay07! Your formula is correct. If you want it not to sum to ALL PERIODS, change the Summary method of LI to "Formula" (for time). Then the calculation should be correct.

AntonMineev · ‎04-26-2022

Hi @amruthasai7979! Hi! You need to understand where you were trained and where the model is located. If it was put in the archive, it will be possible to put it back online. If your colleagues still have access to it, they will be able to give you back access (check with them). If the model was deleted more than 90 days ago, it is unlikely that it can be restored. As a last resort, you can contact the training center support. Often there are technical failures, when the course is not counted. Support will always help!

AntonMineev · ‎03-02-2022

Всем привет! В связи с последними событиями партнерам и Anaplan поступает много вопросов от клиентов. Предлагаем обсудить эти вопросы с командой Anaplan на вебинаре, который состоится в эту пятницу (4 марта) в 17:30. Чтобы мы лучше к ней подготовились, просьба отправлять Ваши вопросы @AntonMineev или @zimin-oleg в личные сообщения здесь, на Community. Ссылка на мероприятие. До встречи!

AntonMineev · ‎02-17-2022

Hi @Aenenmoh! I was involved in such an implementation on the partner side. The client had a ready model in another system and it required changes. There were also specialists from the business side who were ready to deal with the implementation. I (from the partner's side as an architect & PM) gave the customer a two-day training on modeling and building their solution architecture. Further colleagues were trained by Anaplan and we met with them for 1 day a week to discuss issues/architecture/progress/form the backlog for the week. So in about three months they reworked their budget model. The labor for consulting was about 120 hours (training and support). But this case is the exception rather than the rule. A good implementation would require an experienced architect to tackle the most complex issues and lay the right foundations for the model. You can build it without him, but after a while you will have to redo it 🙂

AntonMineev · ‎02-14-2022

Всем привет! Пока идет подготовка к следующему мероприятию (которое мы анонсируем до конца месяца) хочется спросить само сообщество: а что вы хотите услышать? Что обсудить? Может вам хочется чем-то поделиться? Вместе с @KirillKuznetsov мы подготовили список потенциальных тем для будущих мероприятий. Нам очень поможет ваш комментарий относительно интереса сообщества к конкретным темам, а так ваше предложение тем. Просьба не оставаться в стороне и высказать свое мнение по темам ниже. Темы, получившие максимальный отклик будут приоритетными для подготовки следующих мероприятий: Практики и мастер-класс по использованию Management Reporting. Polaris - обзор и ответы на вопросы по новому движку Anaplan, который сейчас находится в разработке. Meetup – более открытый формат, где CoE и партнеры могут обменятся опытом на конкретную тему. Например, Native Version VS Custom Versions . Советы конечным пользователям. Чему научить, чтобы повысить удобство системы и снизить нагрузку на CoE ? Практики построения Центра Экспертизы ( CoE ). Какие типы есть? Что в себя включает? SUM , LOOKUP , SELECT и прочие формулы – как работают, как использовать и какие проблемы возникают [Начальный уровень для обучения для тех, кто только начал свой путь с Anaplan и испытывает сложности] Transaction API – что такое и как использовать? Управление доступом: комбинирование ролей, SA , DCA – лучшие практики. Весенняя уборка: как поддерживать модель в чистом состоянии и что нужно удалять. Оптимизация моделей – основные проблемы с производительностью и что можно сделать. Карьерный путь Model Builder (какие навыки нужно иметь и как прокачивать себя). Клиентские истории (рассказ клиента и партнера о завершенном проекте). Персональные данные в Anaplan и 152-ФЗ [Тема сложная, но обязательно найдем чем порадовать ;)] Ideas Exchange: обсуждение ценных опубликованных идей и совместные планы по их продвижению. Ошибки при внедрении Anaplan: истории из жизни, реальные кейсы. Ошибки в коммуникации при разработке. Очень ждем ваши идеи и комментарии!

AntonMineev · ‎01-27-2022

I fully support this idea! Many of my clients are waiting for this, and at the presale stage many potential clients get upset because we don't have this feature.

AntonMineev · ‎01-27-2022

Ok, let's move on! 1. By point 3, I meant Drill-Down in the UX on the user side. It may help to clarify if he sees the data for calculation and how this cell is different from the neighboring ones. 2. ok, then it remains to check the DCA. Is it installed on this LI? If so, if you remove it, does the problem remain?

AntonMineev · ‎01-27-2022

1. The "Referenced by" column is not filled for filters. It displays only the relationship of modules if they are linked by formulas. 2. As I see it, you want to make a filter only by year. Then in your module the time scale should be defined as "Year" (see screenshot). And also LI in Boolean format and TRUE formula. 3. In order to filter the source module, it must also have a time scale (e.g. months or quarters).

AntonMineev · ‎01-27-2022

Hi @Jsdeloria21! Interesting problem! I suggest that you check and test the following: 1. Make sure that you and the user are looking at the same slice of data (time, version and other analytics). 2. Reconcile the settings in the DCA part. It is the one that can change the display of a particular cell. Ideally set yourself the same role and remove WS Admin for the time of testing. 3. Ask the user to use Drill-Down on that cell and send him the results. 4. Pro-Tip: give the user Page Builder (or use My Page) and under your control try to reassemble the view. At what point will the number not be visible?

AntonMineev · ‎01-26-2022

Hi @Michael.downer! Unfortunately, there is no standard functionality to solve your problem. Anaplan will not allow you to add two related directory hierarchies to the module. Besides, two directories in columns will take more space and look redundant (especially in UX). If you need to filter by selected countries, you can think of a better solution. Can you describe what the business problem is?

AntonMineev · ‎01-26-2022

Hi @MaithriK! What problems did you encounter? Can't create a module or select the measurements you want? What should be in this module and what tasks should it solve? Please give more information (text, screenshots).

AntonMineev · ‎01-24-2022

Hi @neg177! You need to describe the task in more detail: 1. Can these percentages be anything or is it a rigidly limited list of options? 2. Are they assigned to one list only, or can they depend on time/percentages and other lists? The default will really most often be a SYS module (properties module) where other list properties are set.

AntonMineev · ‎01-22-2022

Hi @lloydramatshaba! Yes, they should. The final test for the course will include a numbers check. To make sure everything is ok - check the original data (sometimes when loading data fractions can be loaded as integers and so on), as well as the presence and correctness of the correct formulas/mappings. You need screenshots of the model/data to get a more accurate answer.