About M.Kierepka

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

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 )? ... View more

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.   ... View more

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. ... View more

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. ... View more

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). ... View more

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

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. ... View more

@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. ... View more

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. ... View more