Platform

nathan_rudman

WHAT: Creating Time Graph with extended time ranges to allow them to be dynamic in the future WHY: Anaplan Time Graphs are limited to the time periods available when you create them. As time goes, you have to recreate them. HOW: If you create your time graph (by time graph I mean any graph that displays time as rows or columns) with your regular model time range, next year when you add a year in the timescale, you will have to redo the graph. Annoying. That is because Anaplan graph will only be dynamic (with a filter for example) if the time period existed in the module from which you published. The trick comes with the Time Ranges. You can have an extra extended time range in your settings Now you can temporarily change your source module to that time range (or have a copy of that module depending on your size constraints) Publish your graph with all those years and then change the module back to the normal time range. Add a year in your timescale and there it is, you graph is good to go for the next 10 years (or until somebody asks you to change it)

nathan_rudman

A graph can only display time if the time period existed when you created and published it. Another "tip" is to use an over extended time range of like 20 years, use it temporarily to create the graph and then change your module back to the normal time range.

nathan_rudman

Something I had made for myself that can be very useful depending on your model: an archive module where I would copy the whole P&L (works with every final reporting module you have) and then check against the live calculation for any difference. I'd make a copy before starting some development this way I would know in a glance if a change I was doing had any impact at all on calculations.

nathan_rudman

Hi, In the load interface of Anaplan, there is a time format mapper that should be able to handle this. When you create the data import, go to the list of line items. For the date line item, you should have a boolean next to it, click on it. In there, you'll have a bunch of option. Choose the one that matches your source format and Anaplan will do the job for you.

nathan_rudman

In many modules and use cases, the row dimension is useful information. Hence the first column of a module contains a code/name that customer would like to use to search for in another selector/page. Currently, Anaplan behavior when you click on the row header, is to select the whole line. In order to manage this issue, we have to add an additional column, which uses space (both in GB and screen space, which is scarcer even) I'd like the possibility (or the default) to select only that first element so customer can copy it and paste it in subsequent dashboards.

nathan_rudman

Hi, you will have to share more in order for someone here to help you with this. We cannot tell what's wrong just from that.

nathan_rudman

Hi, could you precise what you mean by "Data Utility tool" ? Out of the box, Anaplan API makes available every saved export action, so if your data tool can read from the API (or Microsoft software directly) then you could go that way.

nathan_rudman · ‎06-23-2019

When creating elements in a list that has a subset as parent, we can get an error because some element have the wrong parent. It would be very useful to have a more detailed error, with for example the rejected lines.

nathan_rudman · ‎04-26-2019

Hi, it is possible with the API so should be possible with AC https://anaplan.docs.apiary.io/#reference/models

nathan_rudman · ‎04-24-2019

Hi, Anaplan follows the W3C standards for our web platform. We recommend Chrome or Firefox as these browsers follow the web standards ensuring proper functionalities for Anaplan (but that is true for all websites). Edge does not follow the same standard, you can use it but at your own risk.

nathan_rudman · ‎04-09-2019

I did a try in Meteor.js and my requests are actually going out via the node server so I haven't encountered that problem

nathan_rudman · ‎03-25-2019

Hi, I can see you have the time dimension in the target module. Are you sure this error is not related to how you map the time dimension rather than the date to date import ?

nathan_rudman · ‎02-21-2019

and with David's solution for 2, you can actually solve 1 as you can use your mapping to maintain the actual user role:you can import from the module into the user settings, avoiding "maintenance" and managing user rights from a dashboard which is more user friendly.

nathan_rudman · ‎01-21-2019

Hi, not sure what you mean by 2 but bug fixing while working on future relese with ALM happens all the time. It's not the best dev to prod in the world of devops but we have a way to manage it: https://community.anaplan.com/t5/Knowledge/Save-Incomplete-Changes-when-Synchronizing-in-ALM/ta-p/33595

nathan_rudman · ‎10-21-2018

Hi, you can do: text(line item 1) & "(" & text(line item 2) & ")"

nathan_rudman · ‎10-11-2018

edit: to be clear, this issue is when you when to add into a subset AND at a selected position, which you can't do at the same time (button will add into subset but not at the right position while edit insert does the contrary)

nathan_rudman · ‎10-11-2018

Hi, isn't Anaplan working this way already ? You select and element > insert and then choose to append after or before or as a child.

nathan_rudman · ‎10-10-2018

" and asking me to post additional pictures seems like a typical IT delay tactic. " this is a community, not Anaplan support. Nobody here is paid to answer and we're all doing it because we like the principle of a community. FYI some of the replies I made to this question I did them at 23h30 my time. The chart you have obtained is the best thing you can get in Anaplan. The X axies cannot have an additional tag and you cannot do overlay. on the values. With an additional week list, the only thing you can do is name it week 2 FY18 - FY17 but I don't think that brings much value. If you want to do that, you need to have a mapping between you additional time list and the real time and have that mapping in your data module.

nathan_rudman · ‎10-04-2018

Humm, yes for system integration, format shouldn't change... Maybe you can do several imports to accomodate for several formats ?

nathan_rudman · ‎10-03-2018

Hello, If you look in the "Actions" menu of Anaplan, you'll get three tabs: actions, imports and import data sources. Every import is based on an "import data source". Look at your import take the source label and search for it in the "import data sources". You should find it, edit it. if it tells you file no longer exists (which it will), it means you need to reupload the file. That is possible, if you just do "new source" and upload a file named the same way as the original one. You should then be able to edit your existing import. Personally, I just usually re-do them when the mapping needs to be changed.

nathan_rudman · ‎10-02-2018

if your two modules are on the same time dimension, you can simply make a reference to gallons without any formulas, providing your row list has a top level (you should have one)

nathan_rudman · ‎10-02-2018

I think you created that week list upon my instructions... however now I'm not sure you needed it. Why not having your second module directly over the real time weekly timescale instead of a yearly timescale ? Otherwise you have to do a mapping between that week list and the real time and [SUM:on it] another question, why is you data loaded over a weekly timescale, is that required ?

nathan_rudman · ‎10-02-2018

"week of year is not a dimension, row numbers are" then what is this time dimension we can see on top of that data module ?

nathan_rudman · ‎10-02-2018

Oh I see now ! In your module activity numbers (the one with the rows), this is where you need to have a line item "week number" where you do item(week of year). Then on your "gallons" the formula should be: Activity Actuals Import.Gallons[sum:week number] That should bring you the data ps: your week number could actually be in the second module but it doesn't make much sense in terms of logic

nathan_rudman · ‎10-02-2018

oh yes, I know that one. When using numbered lists like this with the same "name", Anaplan cannot identify them as they have the same name. You should rather import the code if you have one or the item number (the default numbering of the numbered list) that you can get with name(item(your list))

nathan_rudman · ‎10-01-2018

Hi, can you show the your import setting ? You must be importing by code, and as codes go, abc123 and ABC123 is the same thing. You can't have two elements with the same code. Just make sure the code field is blank and you just import abc123 or ABC123 into a display name property

nathan_rudman · ‎10-01-2018

Hi, I think we have given you bad answers because we misundertsood your needs. First you expressed that you wanted a double time axis with years on X and weeks on Y. I don't think that's what you want. In your module with your timeline, you just need two line items Gallons and Gallons PY. Bring the numbers on Gallons and do a lag(Gallons,52 [if in weeks],0) for Gallons PY and that will do it.

nathan_rudman · ‎09-27-2018

yes, I was just point to my own bookmark, upload is here: https://anaplan.docs.apiary.io/#reference/upload-files/upload-file-as-a-single-chunk/upload-a-single-chunk?console=1 If you want to run that upload from POSTMAN, I believe you need to put the actual content of the file inside the body. It's probably a CSV so just copy in there the text

nathan_rudman · ‎09-26-2018

Yes, Period.previous should be list fromated as Period and then you can input the value yourself

nathan_rudman · ‎09-26-2018

What is the format of the previous property you created in the list ?

Platform

Academy

Master Anaplanner

Programs

About nathan_rudman