About MarkWarren

MarkWarren

You may either want to refer to the CODE or create a display name for that list. Numbered Lists - Anaplan Technical Documentation

MarkWarren

I'd take a look at this, The Anaplan Way Guide - Anaplan Community This is how we recommend you approach a project. Look in particular at the model build section. You should put a lot of emphasis on what the outcomes should be, what are you trying to achieve or do better with the Anaplan model (and connected ecosystem). Knowing the goals of what is needed you can work backwards from the UX, this lets you create a model that only has the necessary functionality to deliver that outcome or output. Our PLANS methodology fits here too... PLANS - This Is How We Model

MarkWarren

rm is the command you need there. I'll use Ben's link from above to help here: http://www.gnu.org/software/coreutils/manual/html_node/rm-invocation.html#rm-invocation

MarkWarren

Yes, this is the endpoint URL for integrations, including Anaplan Connect. So you should set up a test script on the same server using the test.api.anaplan.com address to make sure it connects and authenticates okay.

MarkWarren

The instructions on how to test are here, and the test endpoints to use API services endpoint testing - Anaplan Community The outcome of your testing will determine if you need to put the end point on an allow-list

MarkWarren

kudos for reading the whole question, I missed this

MarkWarren

It's not something I've tried, my colleague @christophe_keom might have done. The script below for the conversion will only work on Windows. I've heard that it can be done with LibreOfiice and Python but here's a few ideas: 5 Methods to Convert xlsx Format Files to CSV on Linux CLI (linoxide.com)

MarkWarren · ‎07-01-2021

No, the underlying data will always be exported. You could, but you shouldn't, have a text representation of that data to achieve the same effect. But don't do this, Text is bad for the model and I should never have mentioned it. I'd apply the same formatting in Excel afterwards. Using the Excel add-in may help if you're looking to export to Excel in a specific way... Excel Add-in Series 4 - Anaplan Technical Documentation

MarkWarren · ‎07-01-2021

Hi, sorry for the delayed response. I was suggesting that none of the items in that module should be dimensioned by Time. If you have a time period line item that you need to filter you don't want the other dimensioned by time. Or you take out OCD and dimension it all by Time, but as OCD is at a daily level the data would be very sparse.

MarkWarren · ‎07-01-2021

I don't know of any issues, nor can I see any problems with this. It's something I have used. Emoji and special character support in browsers is much better now. The advice still stands for use in models for anything that will be used as a reference in any way. As long as it adheres to Unicode standards it shouldn't be a problem as far as I know. https://unicode.org/emoji/charts/full-emoji-list.html

MarkWarren · ‎06-29-2021

What line items in the module you want to filter are dimensioned by Time? OCD, FY and Check are not dimensioned by Time. I would take Time out of the module so you don't have subsidiary views, this may be adding to the confusion. Then show this ImportExport saved view with the Check line item

MarkWarren · ‎06-29-2021

What this is showing is that date, 1st July 2021 is in FY22, FY21 ended on 30 Jun. So the FY value is correct.

MarkWarren · ‎06-29-2021

We'll need to see your calendar settings - what is your current fiscal year, when does it start etc.

MarkWarren · ‎06-29-2021

Ahh I see what you're doing now. I didn't see the filter.PNG OR modules.PNG files when I first looked. You would need to dimension the module by Users to enable the filter, because Users list does not have a top level and you must want to filter the data for each user's choice.

MarkWarren · ‎06-29-2021

The import does strip away spaces, either before or after the text, even when using text delimiters on a file. I would suggest using a TRIM on the value you use in the FINDITEM. With TRIM:

MarkWarren · ‎06-29-2021

Is this not working? Looks like it should How is FY dimensioned?

MarkWarren · ‎06-29-2021

I'd do this by editing the labels on the fields and/or adding a text Text card next to the fields.

MarkWarren · ‎06-23-2021

Check this post to see if it matches your situation, if not I'd raise it with support if it persists. Solved: Unable to open model - "loaderutils#loadReduxApp: ... - Anaplan Community

MarkWarren · ‎06-01-2021

Not directly the map chart can only show one value at a time, but you could use a line item subset to change the value. I mocked up an example... Here's the original line items, create a LISS that includes these. Create a new module dimensioned by your geo list and this LISS: The module has one line item called "Value" which does a collect... The map chart can then use the LISS as a page selector to change the data of Value displayed on the map. Hope that's useful, not ideal but maybe better than showing 3 different maps...

MarkWarren · ‎06-01-2021

The script is correct. Could you show or detail more of the error - if you have not already resolved this?

MarkWarren · ‎05-26-2021

To reference an item at a higher level, in this case at L2 you need a line item for the parent of L3 so you can do a LOOKUP. Something like: IF isL3 THEN 'L3 reference' ELSE 'L2 reference'[LOOKUP: 'L3 Parent']

MarkWarren · ‎05-25-2021

You need to limit concatenation as much as possible, see my article Memory Usage From Text Concatenation This can be done by doing as many of the concatenations at the lowest cell counts possible. So if you would add "Type" to Year at the Year level (assuming this is a time dimension). You might then add that part to the Currency (this is likely to be smaller than Group) Then add that part to the final Group part. (All assuming you are adding codes of lists, this doesn't apply if they are just values against a single list). I would question this code though. A code like this needs to be unique and I'd guess many of these will only vary by Group; Year and Currency could be quite common. Is it not possible to dimension your data by Time and Currency - importing in to a module dimensioned by Group, Year and Currency. My point is, look for strategies that avoid the need for text and text concatenation where possible, if this means reevaluating the source data then it should be done; the benefits will pay off over time.

MarkWarren · ‎05-24-2021

What do you mean when you say the input data is " 5/1 100"? If you have a line item dimensioned by time and data that has separate time values then you can import in to that line item easily. If the format is text as this suggests then you need to fix the source data so that it is in a better format to be consumed easily in to Anaplan. Can you elaborate on the issue a bit and the data, perhaps with screenshots?

MarkWarren · ‎05-24-2021

You're right that RANKCUMULATE does have performance impact. It is a function that has to run single-threaded, most other Anaplan functions can the benefit of splitting calculations over multiple parallel CPU threads to improve speed; this function doesn't, neither does RANK or ISFIRSTOCCURENCE. CUMULATE when used over a list will also run single-threaded and this may have been the concerns of @takushimozuru in the original post. CUMULATE over time does not have that problem, so those solutions here will perform better (than using with a list). However, I think you missed Rob's point that a if you just need the cumulative total over that list, use a summary. Another similar alternative would be to change the boolean to list formatted and have a list with 2 items, "TRUE" and "FALSE"; you can then do a SUM...

MarkWarren · ‎05-20-2021

A line item can be safely renamed, it will not affect any functionality. Every line item has its own internal ID that is used for the references within Anaplan. The only best practices are to avoid using special characters or emoji in the name.

MarkWarren · ‎05-13-2021

This article is the place to begin thinking about the solution Formula Optimization in Anaplan The reason why is shown in my recent article, Memory Usage From Text Concatenation I think you need to break down which combinations are valid and have those as booleans, but instead of a complicated IF statement is there a way to identify these items in a list or even a layer below that have this data as list formatted rather than text? The key point will be to do as much of this at the lowest cell counts possible, sounds like everything might be at the same dimensionality here though. Try also to eliminate the most likely missing values first in the booleans, and if possible do the checks for valid text as soon as possible in the model, at their source, and set to blank instead of pushing text values through the model that won't be used because their invalid in a later check... I haven't got any better solutions than yours though, hopefully some good modelers will add to this! Try what you have planned, split as much out separately as possible to reduce complexity and test as you go, keep an eye on the calculation times...

MarkWarren · ‎05-12-2021

yep, I just tested with imgur, works fine...

MarkWarren · ‎05-12-2021

It does need to have a file extension of jpg or png Consider setting up a webserver where you can host files needed. As a free alternative this site is one I found that has the file extensions: https://imgbb.com/ Select the HTML embed, copy the url...

MarkWarren · ‎05-12-2021

I definitely recommend a Line item subset here, use a COLLECT to get the number of teeth, and don't forget to turn OFF summaries!

MarkWarren · ‎04-27-2021

Data Hubs typically include large lists or numerous lists; both contribute to longer save durations. Model saves block other model actions, so we want to reduce the frequency of saves as much as possible. Reduce the Frequency of Saves First, put the data hub model into Deployed Mode. Learn more here: Enabling and Disabling Deployed Mode - Anaplan Technical Documentation Deployed mode will reduce save frequency by a factor of 10—when the model is used by a small number of users or a single integration user. What Causes Model Saves? Calculations and model changes cause model saves, but two common triggers for saves in data hubs include the following: Summaries. List Restructuring. Top-level members on large flat lists will create a large and slow calculation on line items dimensioned by this list that have a summary applied. For example, 100 line items dimensioned by a list with 10 million items will mean 1 billion cells will be aggregated to those top-level cells. This will occur if items are added to that list or data is imported to those line items. 5.07-09 Avoid using a Top Level for large lists of transaction data Re: 1.05-07 Avoid Top Level for large flat lists List restructuring—adding or removing list items—can cause recalculations that contribute towards triggering a model save. A way to reduce this impact is to enable a feature called Pre-Allocation. Pre-Allocation in Lists (and Impacts to Model Performance) This is done by adding a role (that has edit permissions) to the list. The role does not need to have users assigned to it. Do this with lists that are frequently changed. Summary To help reduce save frequency in models, complete the following: Enable deployed mode. Avoid summaries. Do not use top-level members on large lists. Enable pre-allocation.

About MarkWarren

Re: Laparoscopic gynaecologyical center in Panchku...