About M.Kierepka

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.

M.Kierepka · ‎05-06-2020

I think this topic can be closed, as Anaplan now properly handles updating of the "Last visited" field.

M.Kierepka · ‎04-09-2020

Hi, thumbs up for idea, it would reduce complexity, space usage, and development time, as well as speed up of the models. Possible duplicate of https://community.anaplan.com/t5/Idea-Exchange/Conditional-Formatting-on-Booleans/idi-p/39299, can we have it merged ( @Miran )?

M.Kierepka · ‎03-25-2020

Hi @rachel_goering , Great idea! It would be very useful. I can also share my current workaround for this, "oneliner" in Excel (paste in Y2 and double click the bottom-right corner of the cell): =IF(D2="",A2,Y1) I'm using D column (s "Is Summary"), as for line items is either FALSE or TRUE, but for modules it's blank. Maybe it should be in separate Idea, but it would be also helpful to see size of single modules/line items - for optimization works overview, as cell count can be misleading. Again, I'm posting my formula to determine single line items size (paste to cell in 2nd row in any column after V and double click the bottom-right corner of the cell): =IF(D2="",0,V2*IF(IFERROR(FIND("BOOLEAN",E2),0)>0,1,IF(OR(IFERROR(FIND("NUMBER",E2),0)>0,IFERROR(FIND("TEXT",E2),0)>0),8,4))/POWER(1024,3)) V column is Cell Count, E is Format, D is used to determine if it's line item or module, as in previous case (module size is calculated as 0 here) The "/POWER(1024,3)" part is used to convert size to GBs, omit it if you want just bytes, change "3" to "2" for MBs.

M.Kierepka · ‎03-25-2020

Well, in my opinion the current functionality is helpful. I would definitely like to have this option always on in the models I develop. In production environment it also reports about "heavy" user activities, such as exporting huge data sets or running long process. This should also discourage developers from unlocking production models - use ALM, always develop (and make mistakes) in a DEV environment, when the model is smaller and its rollback time is minimal. Maybe it would be better to have this setting as your personal? You could choose globally if you want to be anonymous or have your data displayed in the message.

M.Kierepka · ‎03-23-2020

Currently, new Home page allows you to quickly access last visited models. If you want even more that 8 recent models, you can go to new Models page or classic Home, and there models are (by default) sorted by the time you accessed them last time. The problem is, "Last visited" model property is updated only if you launch model through classic Home. If you open a model via new Home or Models pages (so de facto via link "app.anaplan.com/a/springboard-platform-gateway-service/workspaces/{Workspace ID}/models/{Model ID}/redirect"), "Last visited" isn't updated. Because Anaplan is switching default landing page after logging in to new Home soon and most users will be opening their models without using classic Home, it's very important to update "Last visited" correctly.

M.Kierepka · ‎03-06-2020

Hi Nick, You can export all actions, then in Excel just filter based on "Used in Process" column. The only problem is, this way you don't know in which order they are.

M.Kierepka · ‎02-27-2020

Hi, It would also be good to add an optional argument in which you can provide your own seed. This would ensure RNG repeatability. But overall, I think there would be a problem with providing such features in Anaplan. The question is, when will the numbers be generated? In Excel, it's up to you when to calculate formulas (Formulas->Calculation Options). But you don't have these settings in Anaplan. So, I think the only way is to generate pseudo-random numbers whenever ANY data cell is changed or the model is opened (which would be catastrophic for the model's performance). So for me it makes sense to generate it in Excel and import to Anaplan (when you save the CSV file with numbers, you will always get the same result, so it will be repeatable).

M.Kierepka · ‎02-04-2020

Hi, It looks like Anaplan released the update, and auto-axis is now available in the New UX:

M.Kierepka · ‎12-01-2019

Hi @Ari, According to the New UX training, "this feature is coming soon". And because we could have seen this on the video for a long time, it looks like they are polishing it and I hope that we will get this functionality really soon.

M.Kierepka · ‎11-29-2019

@CallumW, I have never had needs like that, but maybe you could set automated History export from the model. It would be useful only in developer models (unlocked), where you make changes to the structure manually. When you have an export file, you can filter changes using " Description" column, and automatically separate data changes (in DEV model there shouldn't be many of them) from structural changes. And if you only need that info for specific module or line item, you can filter by "Module/List" & "Line Item/Property" properties. I hope it helps for now, but I agree it would be good to have better, Anaplan-based way to do this.

M.Kierepka · ‎11-29-2019

Hi Callum, Well, I think this option is in Anaplan for a long time. If you set an export from "Modules" or "Line items", and tick the "Save Export Definition", you can then reach it through an API and execute as normal export. For me it works perfectly.

M.Kierepka · ‎10-21-2019

Currently, if card has no name, description icon isn't displayed on dashboard. But sometimes we don't want to enter the title, but we need to show the description - and also don't waste the space above the card just for that small icon. If this is not feasible, at least we should see some kind of warning in the card designer view, that because there is no title, description won't be displayed.

M.Kierepka · ‎10-14-2019

As a member of Anaplan Center of Excellence and user of Anaplan Integration API, I need to get more information about models. In old version of API (1.3), we could get more information about models than in newer one (2.0). The missing (and really useful) data are: -'isoCreationDate' -'lastModified' -'lastModifiedByUserGuid' -'lastSavedSerialNumber' I would need above available also in new version of API, as I'm actively using these. Also, for workspaces we can get 'sizeAllowance', but for models we can't retrieve something like 'currentSize', which would be very useful.

M.Kierepka · ‎10-11-2019

As a Page Builder, I need more than 4 columns on the New UX Board. Currently, in New UX, there is a limit of 4 columns in a single row. But when designing a page, Page Builder can easily see, that there should be possibility to have up to 12 columns - that's how Board is divided. I know that currently, when you place card on the grid, whole row is automatically divided in equal parts (and it's not achievable for 5, 7, 8, 9, 10 & 11 columns), but it shouldn't stop us from placing more cards - they just don't have to be equally spaced.

M.Kierepka · ‎08-13-2019

As a Model Builder and member of CoE, I need to be able to set the model in the Locked status as "Offline". Currently, when the model is Locked, all users who have access automatically have access to it (so it's in "Online" state). But sometimes, we need the model, which only Workspace Admins can see, but it's not editable (i. e. for investigation or searching for a bug; model cannot be seen by the users, be uneditable but easily accessible, and has to occupy space to disallow other models to grow too much). But currently, radio buttons for switching Online/Offline are grayed out and disabled, like for "Archived" state.

M.Kierepka · ‎08-13-2019

As a Model Builder, I need a function to return User's First & Last Name, so I think the best solution would be adding CODE() function for Users list (which would have current functionality of NAME()), and change behavior of NAME() function applied to Users list. For backward compatibility, if NAME() cannot be changed, some function should return User's name. So ideally: New function available for Users list and change of the existing one to behave more intuitively: CODE(User) -> text (Email) NAME(User) -> text (First Name & " " & Last Name) Or, if NAME() cannot be changed, something like this: DETAILS(User) -> text (First Name & " " & Last Name)