About M.Kierepka

M.Kierepka

Hi @dfernandes, Is account used by integration the same as used for manual download? What I assume could happen is that in dimension in rows has Selective Access enabled (or DCA and "Omit Empty Rows" is set in export definition), and your account has access to this hierarchy, but integration account doesn't have access to this hierarchy. The best way to check it is either copy your access to integration account in Anaplan (using bulk copy or just Ctrl+C->Ctrl+V in Users tab) or change integration credentials to yours (might not be possible if you are using Certificate Authentication). Hope it helps, but if not, can you provide screenshot of the export's settings?

M.Kierepka

Hi @KevinMcQuillen, I checked, and you can do it in the same line item (both with normal and grouped rank). So in your RANK line item, just add "+ Reference Line Item" at the end and it should work: =RANK(Source values [, Direction] [, Equal value behavior] [, Include value] [, Ranking groups]) + 'Reference Line Item'

M.Kierepka

Hi @Katya, Nice idea! I'd also need it in few places. In the meantime, there is a workaround to only show lowest level (using Dependent dropdown functionality): 1. On the lowest level (for you L6), add property to the list and set format as some non-production list (preferably some dummy, I usually use Organization). 2. Then, put there formula to only select one item from it: 3. Then you do the same in the module where your selector is placed: 4. And the final step is to go into dropdown's settings, and select Dependent selection (it should automap settings, but if not, top and left options should be set to Single Item, and right one to "*name of your list* (ITEM)"). Hope it helps.

M.Kierepka

Hi @AmruthaB, For me it looks like path to the file you want to upload as part of this import (argument FilePath) is incorrect - it doesn't have file extension at the end (probably ".csv"). To always ensure that you provide right path to the filename, I advise you to find your file in File Explorer, hold Shift and mouse right click - it will open context menu and one of the options will be "Copy as path". Choose it and then paste it in your script. Also, validate if FileName argument is the same as in Anaplan - I see that you use CSV, and if you haven't renamed your source file, it should also have extension, like "test import.csv".

M.Kierepka

Hi @PhilippErkinger, This feature is not available - yet. However, according to latest Release Notes, they plan to release it this month (https://community.anaplan.com/t5/Releases/September-2021-Releases-and-October-Sneak-Peek/ba-p/121127 search for Favorite apps on Home). It looks like Anaplan is still working on this and it is taking them longer than expected.

M.Kierepka

Hi @ZansM, I understand that not being able to use Saved Views can be frustrating, but you can still use Custom Views for your purpose - on the screenshot below I highlighted icons that open menus for Filtering and Selecting. However, I don't understand your second paragraph - do you mean that you want to apply selection to nested dimensions (so more than one dimension in rows/columns)? If so, you are right - it cannot be done in New UX Custom Views, but I believe It's also something that Anaplan don't want to allow on Management Reports - grids here shouldn't be big or complicated.

M.Kierepka

In Anaplan, if you reference some line item, and source & target modules have common dimension(s), it's like automatically applying lookup. About "Quick/Regular" filter, they can only apply based on some line item. It's doable, but I think it's not intuitive for end users. Maybe, what you would prefer more, is something like applying territory dimension to this grid - only to whole module, but not to single line items. This will produce subsidiary views, but will save space. And what it allows for is applying filter dependent on page selector - so it's really easy for users to use it. If you want to do this, then in B you need to change dimension from Users to Territory and formula to "ITEM(Territory)", and in C replace Users with Territory dimension

M.Kierepka

Hi @jtkerlin, If I understand you correctly: 1. Create line item (A) that has dimension of L3 Product, Format = Territory, Summary = None, Formula = pull values from Dep level using loop by parent (probably you have this already) 2. Create line item (B) that has dimension of Users, Format = Territory, Summary = None - this will be input, users will pick which territory they want to see 2. Create line item (C) that has dimension of L3 Product AND Users, Format = Boolean, Summary = Any, Formula = "A=B". Now apply C as filter for your view, it should show item at any level that has at least one descendant of selected territory. Hope it works for you, let me know if you have any questions.

M.Kierepka · ‎09-12-2021

Hi @alexpavel, I like your solution if you want to exclude NaNs OR infinities. However, if you want to zero both NaNs AND infinities, I prefer less complicated (just one simple IF, no SYS modules) solution: IF Value * 0 = 0 THEN Value ELSE 0 Here I utilize properties of multiplication by 0. "Normal" numbers give 0, but NaN and infinities times 0 are NaN.

M.Kierepka · ‎09-12-2021

Hi @dhinayadav, Welcome to Anaplan community - glad to hear you want to learn more about Anaplan. I think what you are looking for is Anaplan Elevate - please check this page for more details: https://community.anaplan.com/t5/Anaplan-Elevate/ct-p/Elevate I see that registration is open, and next cohort will be starting in few weeks. Good luck!

M.Kierepka · ‎08-25-2021

Hi, Yes, it's possible in Anaplan - please use CUMULATE function (https://help.anaplan.com/1173a903-81bb-4838-a4d0-1c9f9c739aa3-CUMULATE). If you have multi-year calendar, then you need to reset the cumulate at the end of each year, use Boolean from system module where you hace start of year calculated.

M.Kierepka · ‎08-11-2021

Hi @chanaveer_k, Thank you for quick and exhaustive reply. Knowing the chunk size is enough for me for now (however, I think that setting up max chunk size for exports through API could be a nice enhancement). Is there possibility to update API documentation with this info? I can imagine some other developers might need this detail in the future. Thanks & Regards, Miłosz Kierepka

M.Kierepka · ‎08-06-2021

Hello everyone, Our integration developers want to connect to Anaplan via API 2.0. However, they need to know what is the upper limit of single chunk size. I know that Anaplan recommends dividing uploaded files into chunks not bigger than 50 MBs (source), so I assume it is a safe limit. However, you cannot set up chunk size when downloading file from Anaplan - server does it automatically, independently. Do you know what is the logic behind chunking files on Anaplan side (upper limit), preferably with link to official source (which I was unable to find)? If you know it from previous experience/experiments (I remember it was 10 MBs, but I am unable to test it now), please share your thoughts. Thank you in advance!

M.Kierepka · ‎06-25-2021

As a Workspace Administrator, I want to be able to assign or reassign model to Business Function/App/Environment/Geography/Planning Cycle category in Manage Models window. Every Workspace Administrator should be allowed to edit this mapping for models they have access to. Currently, they need to be Tenant Administrators and navigate to Administration area, which does not make sense, is a long and painful process, and does not allow for proper segregation of duties. Our Workspace Administrators want to start using this mapping to categories as users (normal and admins) will be then able to easily filter models on the Models page. Proposed layout:

M.Kierepka · ‎06-25-2021

Great idea, but it's duplicate of already existing post (with higher count of Kudos, that is Under Investigation). Please consider Kudoing the old post as well: https://community.anaplan.com/t5/Idea-Exchange/Referenced-by-feature-for-DCA-Driver-Line-items/idi-p/47938

M.Kierepka · ‎06-15-2021

There are multiple improvements that would help end users to operate with grids in Anaplan. There are multiple solutions in different systems that people already used to, and which are great for narrowing/expanding field of analysis. Let me include few of them, I think both Model Builders (who now need to replace these each time with some custom filters) and End Users (who have hard time with getting used to how it works in Anaplan) would benefit from changes below: Set Time as normal hierarchy - currently, Time Periods don't have some features of another hierarchies. You cannot select levels which needs to be shown, and hierarchy filter for All Periods is also not behaving correctly (it's showing just "All Periods", instead of (as most people expect) whole timeline). It has been huge pain in multiple use cases already. Add "Select Levels of show..." to New UX, as in classic modules and dashboards. This would allow to use one grid for easy analysis at different levels. Implement +(Expand)/-(Collapse) for hierarchies, so users can click on it just like in Excel for grouped rows/columns.

M.Kierepka · ‎11-18-2020

Hi, Current workaround for users not being able to run the process which populates Users list using module editable by normal users is to use some integration tool (Anaplan Connect, custom connector using Anaplan API or 3rd party integration), which will be launching such process on behalf of some Workspace Admin. If you set it up to run the process with high frequency (even having this process run once every hour, all day, would still be generally quicker than asking some WS Admin or person with the role you described to run such process), this should be enough. One thing you probably still will have to manage is deleting dormant users from workspace. But I agree, it would be good to divide current WS Admin role into Model Builder (who can build and manage models) and Users Admin (which should be cheaper, and would allow only for access management). This would be more functional, allow for higher security and better segregation of duties.

M.Kierepka · ‎10-21-2020

Hi, I agree with your arguments and I support your idea. For the time we are waiting for this to be implemented, I think I know easy workaround for you. I know that this information is not available in GUI, but it's available in API. And you can reach some API endpoints from your browser - few of them are the links below, where you will see the IDs of actions next to their names (and even more). So it should speed up the development, and runtime, if you were searching for ID by name each time you were running API session. Links (put relevant WS and model ID): https://us1a.app.anaplan.com/2/0/workspaces/{WORKSPACE_ID}/models/{MODELS_ID}/exports https://us1a.app.anaplan.com/2/0/workspaces/{WORKSPACE_ID}/models/{MODELS_ID}/files https://us1a.app.anaplan.com/2/0/workspaces/{WORKSPACE_ID}/models/{MODELS_ID}/imports https://us1a.app.anaplan.com/2/0/workspaces/{WORKSPACE_ID}/models/{MODELS_ID}/processes https://us1a.app.anaplan.com/2/0/workspaces/{WORKSPACE_ID}/models/{MODELS_ID}/actions Example: "https://us1a.app.anaplan.com/2/0/workspaces/ABCD/models/1234/actions"

M.Kierepka · ‎10-19-2020

Hi All, As most of you, I use mainly A+ for Anaplan, Notepad++ and Excel (however, OneNote isn't my thing). Notepad++ is really useful when you add Anaplan language (apart from that, I use it for JSON from Anaplan API and simple text operations, like sorting, removing duplicates etc.), and Excel is must-have not only for Imports/Exports, but also for things like model analysis using exports from Models→Line items or Lists, or quick JSON→CSV translation.

M.Kierepka · ‎10-15-2020

Well, it's not so easy, as Anaplan's backend/engine structure is not so straightforward. I think you can buy model analysis from Anaplan (they will check your model and give you lots of data like performance of the modules, actons and how to improve it, which generally helps you to optimize both size and performance of the model). But generally, model is complicated if you are using many dimensions in different sets, line item subsets and so on.

M.Kierepka · ‎10-15-2020

Hi I propose one of two options: 1. The report would be input view, but filtered based on Boolean ticked as selection - you can hide unused columns in the report. 2. If you want to have it in the different module, without dimesnion of returns, in the input make line item (lets call it "Picked"), which will have format of Returns, formula "IF Boolean THEN (Item(Returns)) ELSE BLANK" and summary as either First or Last Non-Blank. Then you can just use it as a source for first column (lets call it "Selected Return", again format of Returns) in your report (which, basing on selection, displays "Return A","Return B" or whatever has been selected, and you now have source for your LOOKUP. So line item in output will be just "Input.Source Line Item[LOOKUP:Selected Return]. Side note: Remember to add DCA to not allow for multiseletion of Booleans - to be honest, instead of Booleans, it would be better to just use list selector to choose from Returns for each product - this way you should choose option 2. as you can just LOOKUP basing on this selector, and you don't have to use DCA to force user to select only one (in Anaplan you don't have something like radio buttons, which allow you to select only one Boolean).

M.Kierepka · ‎10-15-2020

Hi, The time to create and compare Revision Tags shouldn't be dependent on the data - only on the structure. So even if your change was small, but your model is complicated/big in the terms of structure, these times will be significantly longer. Side note: syncing and rolling back time grows also with the size of the data, as after these actions model have to be reopened.

M.Kierepka · ‎10-14-2020

Hi, An Anaplan App can have pages that are based on multiple models, but they have to be in the same Tenant - so even if your workspaces are physically based in different parts of the world, as far as they are in the same Tenant, it isn't a blocker for them to be included in your app (however, I think performance could be impacted for pages based on workspaces far from your physical location, as your workspaces should be based as close to you as it is possible, for better Internet connection).

M.Kierepka · ‎10-12-2020

As a model developer, I want to have option to set Breakback for Boolean input line items. This would be great especially for filters, using multi-level filters based on one Boolean line item can become easier. It should work if summary is set as "Any" or "All", and Breakback is ON for the line item, then clicking on top-level item value: if it's TRUE, it becomes FALSE and all its children too (so it's like clearing selection); if it's FALSE, it becomes TRUE and all its children too (it's selecting whole branch).

M.Kierepka · ‎10-12-2020

Hi, these are very good ideas in my opinion! 1st point would be a really big win - but I don't know if Anaplan engine and system would be able to handle it, especially for non-sum summaries (and technically we have something like this already - Quick Sum Bar - but you have to pivot the view to have it as you've described this). For 2nd one we have workaround available (instead of selector, you can add the list as dimension and have it as boolean), but it would be nice to have it. To be honest, I would separate "list" format from "multiselect-list" format, as second one would consume much more space probably. 3rd - 100% agree

M.Kierepka · ‎10-10-2020

I really like this Idea, but very similar feature request has been already posted (even text of ideas is almost the same): https://community.anaplan.com/t5/Idea-Exchange/Search-Selective-Access-List/idi-p/37222 So as in the Idea Exchange Guidelines, before posting, please review the existing similar ideas.

M.Kierepka · ‎10-10-2020

Just an update, Anaplan now lets you have up to 6 columns (and 4 rows) in one space. So it's better than only 4 columns, but sometimes it would be nice to have an ability to put 7 or more cards - you can say it's too many, but some of them are fine with just one column width, like KPI cards or text, especially on large screens.

M.Kierepka · ‎08-17-2020

As a Model Builder, I want to use list-formatted line items as Conditional Formatting base (currently Conditional Formatting can be based only on number-formatted line items), so I don't have to create extra line item to use CF. Developer should be able to pick line item formatted as list as a base and define the colours used for each item, and colour used for BLANK cells. I know that it won't be really useful for big lists (or production lists, maybe you shouldn't be able to pick production list there), but for small lists it would greatly improve speed of development (no need to create extra line item and write formula like "IF Input=Item1 THEN 0 ELSE IF Input=Item2 THEN 1 ELSE ..."), space used for CF (you don't need additional line items) and it would be easier to maintain and understand such CF. It would also allow to assign different sets of colours for one line item - currently we are not able to set colours blue/cyan and green for the same line item (or white+yellow+green and many other useful variations). It would be extremely useful (mainly, but not only) for lists like "RAG status", "Workflow status" ..., and for lists when empty field should be flagged. This option would be even useful, if source and base of CF are the same, but it would be great to be able to format other line items basing on the list-formatted line item. Additionally, in most cases this list should be coloured in the same way for whole model. So as an option, developer could colour "Name" of each item on such list, and this would have global impact.

M.Kierepka · ‎07-14-2020

As a Page Builder, I want to be able to remove actions from New UX card even after they are deleted from the model. Currently, once action is deleted from the model, toggle switch for that action disappears, and I can no longer remove the action from the card — I have to delete the whole card and add again a new card with every action that was before on the initial card. It would be better if we can just add each action from the list on the left (as it is now), but to remove the action from the card we can click some trash can icon next to the action (or some button next to the field where we can edit the name of the action). Another benefit of this solution would be that I wouldn't have to search for the action which I want to remove from the card (if it's still available in the source model), like I have to do now. So this small change would save me time spent when I want to remove some actions from the card.

M.Kierepka · ‎07-14-2020

Hi @Misbah, Good idea, but you've already proposed that: https://community.anaplan.com/t5/Idea-Exchange/Creating-New-Model-with-No-Access-to-others-by-Default/idi-p/61896 Idea Exchange guidelines say that you should check if another similar idea hasn't been posted yet, and definitely you shouldn't create second post with the same topic.