About MarkWarren

JaredDolich

@anikdas was going to say the same thing as @MarkWarren - The reporting will be out soon and images are going to be critical. Thanks for sharing this how-to!

MarkWarren

To follow up from Rob, when coming from Excel its important to think about how to transition to multi-dimensionality, like here where you have 5 lines in Excel with calculations on each line. In Anaplan we can have one calculation applied to a list of 5 items instead. here's a couple of short courses, the first one here is what Rob has described to use for your cumulative interest: Understanding Top Level - Anaplan Community Manually Adding and Organizing Lists - Anaplan Community

ben_speight

In Shawnm's case it looks like a stray percent character in the command line.

JaredDolich

jack.stewart@ralphlauren.com You're a rock star! Nice job. Good luck with TAW.

luke_e

Appreciate the responses @jasonblinn @MarkWarren . Glad to hear that my peformance metrics weren't lying, hah. But agreed, fortunately the majority of our x[LOOKUP: FY] usage can be quickly updated using the line item extract except where there's additional parameters involved (which in our scenario is minimal). Thanks again, L

takushimozuru

Thank you for your reply. I will try it as a reference! best regards,

MarkWarren

What is it the users are doing, I think we're missing that context? I assumed from reading they were editing data, which could be done as effectively in Anaplan; especially if the data has come from Anaplan and needs to go back in to Anaplan. Maybe the Excel Add-In can meet requirements, as a bridge between having data in Anaplan and editing it externally? Expand on your use case and we, as a Community, can try to offer some practical advice.

MarkWarren

Unfortunately not, even though it is possible to sync to the page selector and you can set a filter on the page selector which would allow you to hide the levels. That filter does not also apply to fields. This is something you should search for or raise in the Idea Exchange - Anaplan Community

MarkWarren

I think this is something that could be achieved with a new Anaplan feature coming soon, Management Reporting. At least to create something that looks like a fishbone chart... Uncover actionable insights with Management Report... - Anaplan Community

Hexagon1

I see, the EMP02 shows the values for the two dimensions, but cannot filter or distinguish them. Now having referenced to the SYS08 where the two dimensions are in, it actually work. Many thanks for the hint.

anand.shekhawat

@MarkWarren Thank You Mark for being so humble. Really appreciate Regards, Anand

Suman Reddy

Thank you @MarkWarren for clarifying it. Any way it is working through integration job daily as you mentioned. Only concern about manual run. Suman.

anmol1111

Hi, I was talking about the code of the line item which has been recently updated in anaplan. Attaching screenshot for your reference.

MarkWarren

I think you may have the wrong forum, this is for Anaplan! This post does not relate to Anaplan. however, I think your problem lies in that your table has the ID field defined as GENERATED ALWAYS, you should have it set to GENERATED BY DEFAULT if you want to set a specified value in your line: users.setId(payTransactionRecord.getUserId());

Kayley

Hi Mark, Thank you for your reply. The source data has a dimension of VVD list roll up by Months. So, what i'm trying to achieve is to have look at the VVD on the row, trace to it Revenue Lane and link to the target module to identify which slottage type it is. Below is the target module i'm using VVD rolling up to Revenue Lane. I have did one manually, based on its VVD and Revenue Lane and below is the mapping i did, the co-relation between revenue lane and it slottage type

MarkWarren

That is correct, we've made to the decision to keep the Planual online. It allows us to keep it up to date and make changes quickly. the biggest benefit though comes from being able to link Planual rules to articles that dive deeper in to the subject or link to posts where that topic has been discussed by Community members. This extra detail is only possible in an online version.

MarkWarren

If the exported files are Excel format, then you might want to consider using the add-in. Excel Add-in Series 4 - Anaplan Technical Documentation This allows you to set up and format the Excel file before importing data in to it. Could meet your needs...

MarkWarren

Yes. But this is the strength of ALM in that you can have different levels of data between the Dev model and Prod. Being able to work on a smaller version of the model with less data has a lot of advantages, so consider this before adding too much data to the Dev model. Ideally, you'd want just enough data that is representative of the Prod model so that it allows you to fully test and develop functionality on.

SilviaDF

@MarkWarren thanks again for your input. I think splitting out the subsidiary view into a new module makes the most sense. I believe this module was built quite some time ago before the NUX took legs. With the world moving on in the UX space, it is a good reminder to think about what input modules will be required on dashboards and to reconsider the use of subsidiary views in these modules. Cheers.

ballzpop

I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this? tomzpot mobdro

AWhitworth

If your display name is text formatted then you can reference this with a [LOOKUP: LIST] which will bring the display name through in the text format.

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

Phinphimon

Thank you. i tested the link "https://test.auth.anaplan.com/token/authenticate" but failed the error show (HTTP 405 method not allowed). currently, the interface will run batch script and via proxy server and push file to system. so i have to add whitelist first and re-test. please advise.

Tiffany.Rice

Very odd, as it works for me. Could be something in your Excel configuration.

MarkWarren

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

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

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

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

vinayvm · ‎06-02-2021

Hi @Dominika_Dudzinska , @jczimbal , Renaming a lineitem which is used as a source in any import action will break the mapping (even if you use Map items manually) Please consider revisiting such actions (if any), to do the remapping! Regards, vinayvm