About nathan_rudman

nathan_rudman

in short no, you can't roll back the structure and not the data. Often, data is harder to re-input. Un-deploy your model, make the changes manually, create a revision tag, deploy the model, create a new model from it (or make a copy) and make that new model your new DEV and you are back on track

nathan_rudman

I'll emphasize on actions. it is the killer of concurrency

nathan_rudman

I think it is a matter of judgement. Is your model already big and performance at the limit ? favor performance. Is this formula the center of the model and needs to be understood by all and often ? favor auditability Both ? Then actually measure the performance gain. Do you gain half a second of calculation or 5 ?

nathan_rudman

by the way START(ITEM(TIME)) works although it un-necessary.

nathan_rudman

Because your calendar is daily, you can use the function start(), which returns the starting date of the calendar period. In your case, the date of the day. You can simply compare with the formula: start() = recalc date Additional info: often we compare periods as well. For that it is better to create a line item called current period with a formula PERIOD(ITEM(TIME)) And you can compare that one with another line item period of another date. Format these line items to the period you cant to compare (year,month, week, day).

nathan_rudman

POST adds, it does not replace. so you an do it. However the logical choice if to check the same condition on the formula where you POST and not do it.

nathan_rudman

the URL you are calling ends with ?xxxxx I've not seen this at the end of an API call before. Was it just added when you copied it ? are you calls actually executing with this ? https://api.anaplan.com/2/0/workspaces/xxxx/models/xxxx/imports/112000000025/tasks/xxxxxx?_ga=2.153346232.1261344247.1578293402-1432993212.1563844307

nathan_rudman

1: yes we can do cross workspace imports with a user that connects via certificate 2: it shouldn't be necessary but is the user a model builder in workspace A ?

nathan_rudman

you might want to open with notepad++ and show special chars

nathan_rudman

this happens when you have a special character in the file that is breaking the column separator logic. try to make a csv with something else than comma and see if it solves it. or try to find that character....

nathan_rudman

to my knowledge there's no limitation to the number of elements you can insert at once. I'd be curious to know how many you can include from the GUI at once. If you do this by import, you should only be limited by the list size limit, which is 999 999 999. And remember, one list item is 500b of data.

nathan_rudman

Hi, Usually to control an import action we filter the source. I am very curious why you cannot touch the source module ? Creating a saved view is not a disruptive process. Whatever you do the the target module (filter, sorting, hiding), it will not impact the import action. However you can change the mappings of the import, for the dimension of "country" as " Ask each time the import is run". Or you can manually un-map the others. See below

nathan_rudman

if space is taken mostly by transactions then you don't have much options to reduce the size. I don't see any issues with having 2 data hubs, many are doing it. As your is a time cut off, here's how I would do the transition: 1 use the current DH for one last time to populate all spoke 2 make a copy of the DH, clear it 3 load new transactions 4 in the spoke models, go the models and change the source of the data hub to the new one 5 that makes all your actions using the new DH, no need to do more. I'd prefer that solution, not knowing everything as in theory you don't need to use the "old" data hub anymore. If in case you need, you can temporarily re-change the source or recreate one action.

nathan_rudman

what one need to remember about time on chart: a chart can only show items that existed when first published. And then you can narrow it down with a filter. So yes, publish your graph from a view with a filter, first with the filter showing all periods, then change the values of that filter.

nathan_rudman

Hi, The options to change the display of a dashboard are limited. Try to nest modules/graphs/texts next/under to each other in order to use the blank spaces that are created by default.

nathan_rudman

thanks Jared. I'll replace David here and tell you not to do VALUE(NAME(ITEM())) within the moving sum do it on a specific line item (with reduces dimensions) and then re-use it

nathan_rudman

For actions I'd add one thing: I personally consider any action with a default name to be rubbish and will periodically remove them. It forces my team to rename actions when they want to keep them. good success so far !

nathan_rudman · ‎12-18-2019

Personally, I try to avoid to have to maintain list, I prefer the instantaneous and safety of formula. You could create a mapping module by dimensioned by GL/IO/CC/whatever with one line item formatted as KPI. Then you have one KPI line item in your transaction module and you bring the KPI like this: mapping module.KPI[LOOKUP:GL,LOOKUP:whatever] Then you can simply SUM in this line item: transaction.value[SUM:KPI]

nathan_rudman · ‎12-17-2019

can you explain more your KPIs ? Is it just summing different transactions depending on their GL/other properties ?

nathan_rudman · ‎12-17-2019

no I don't think we have that API point.

nathan_rudman · ‎12-15-2019

you need to remove the first mapping, into #E2 Employees. As it is a numbered list, you cannot import a name, which is what this is.

nathan_rudman · ‎12-12-2019

you mean the order of the subsets themselves or the order of items within the subset ?

nathan_rudman · ‎12-12-2019

In my opinion this is a "bug", could you get the time to demo this to support ? I've encountered it before and simply solved it the way Vignesh mentioned. I'll finish by adding that modules don't exist. It doesn't matter where your line item is. For the engine, only line items exist.

nathan_rudman · ‎12-12-2019

not exactly on subject but icons on a dashboard will block used from saving their views for "Personnal saved dashboards"

nathan_rudman · ‎12-11-2019

Anaplan has its own API, which can interact with any other. However you cannot write script inside Anaplan itself so you are going to need a server and a script to handle that. The easiest is a container with a node.js server where you can quickly write that script We also have a python library (look for it on community).

nathan_rudman · ‎12-10-2019

if my memory serves well the text of Anaplan is a very long text field of 3 millions characters

nathan_rudman · ‎12-10-2019

As Jared said, every time it is a little different. Personally, I'd recommend having your version comparison on a specific module where the versions are line items. The simplest is just to do a [SELECT:your version] for each line item. This give you complete flexibility on the logic (change the rate, replace fcst by actuals etc etc without touching the actual data. And it allows you to simply archive. Remove the formula and voila, your values are here to stay and you can re-use the actual version for planning. So yes, it's not fully dynamic and requires the admin to change formulas but in my opinion (having managed an FP&A model long term) it's the easiest for the admin.

nathan_rudman · ‎12-09-2019

similarly, you can reimport this data from the DEV model.

nathan_rudman · ‎12-08-2019

No unfortunately that icon is on the right. You can use quick filters as mentioned by T_Caban or you can published line items that you use as filter, so they look like a form on top of the module they filter

nathan_rudman · ‎12-08-2019

what's in EM41 ?