About nathan_rudman

nathan_rudman

Unfortunatel, I don't think the "ETL" tool of Anaplan will manage that mapping. However Anaplan can. you can create a data load module which has a "Load Time" dimension, that would be a list with items from 1 to 12 and a time dimension as yearly timescale. When you load, the months will map automatically to the 1 to 12 list items and the user can select which year they are loading (Ask each time the import is run). then all you have to do is map this Load time list to the real time (you can use Period formatted line item).

nathan_rudman

yes, that's the only way. and currently doens't work in the NUX

nathan_rudman

just use chrome developper tools (F12). You can use the presets or set your own resolution

nathan_rudman

I'm not very clear, but I'd say you want to use LAG(actual,12,0) https://help.anaplan.com/en/b10966f6-334f-4eb4-8c24-9a31f6c785ba-LAG

nathan_rudman

As mentionned, you'll need to use the summary type "Closing Balance". But first you'll have to create a technical line item that will take the latest non 0 value forward with the following formula: IF value <> 0 then value else previous(technical line item) This LI you change its summary type to closing balance. And then you can reference its value with a LOOKUP for a specific year (or [SELECT:Time.all periods] in your module two)

nathan_rudman

Hi, find the answer here: https://community.anaplan.com/t5/On-Demand-Courses/User-Filters/ta-p/63725

nathan_rudman

I don't know if there is a limit per say, there might be one but certainly it's far too high for you to worry about it.

nathan_rudman

technically no, this is wrong

nathan_rudman

The easiest is to create a top level to the numbered list that is used in your module one. Then you can reference the line items from module 1 into module 2 with a formula and Anaplan will take the summary level (so the top level) value

nathan_rudman

In 99.9 % of the cases, the number of users doesn't impact the size of a model. Only when using that list of users in a module, usually in order to filter that module per user, does it allocates space per the number of user (this is what Alejandro is showing you). Is that you issue here ? So what are you other dimensions ? Because if we are just talking about users, then 10 millions cells only is nothing for Anaplan.

nathan_rudman

You can use DCA. https://help.anaplan.com/en/d10ce953-9063-405f-b146-e7d5e55383e2-Dynamic-Cell-Access ps:that was the case in classic as well

nathan_rudman

Q7) Which modules are supported by Anaplan? Anaplan doesn't support "modules" per say. we're a planning platform and our customers use use to model many business cases: finance, supply chain, sale,s HR, operations etc especially module being a confusing term in the Anaplan world Q8) What are the Common Formula Errors in Anaplan? not sure what that means QUARTERVALUE TIMESUM MOVINGSUM TIMESUM WEEKVALUE Q12) Name the Access Control Roles in anaplan? your answer here is incorrect. I would not be satiesfied by an interviewee providing this Q13) Define anaplan modules I'd not take this answer either. we have only one type of module. Modules can have many usage, those you cite being some of them.

nathan_rudman

Anaplan keeps the files for 48hrs (or 72 I forgot). After that the action is still valid, if you feed it a new file it will follow the same settings. If you want to redo the mapping, you can redo an import with a file that has the same name as the original import, it will propose you to update your action's mapping.

nathan_rudman

Assuming the load is going to be manual: - can you define a set a properties that would make up an ID (account, CC + ...) ? if yes you can use a property base import mapping - prefix the count with the period. That means if you want to reload a month you have to clear the transactions - have a list like 500K (any size as long as it is bigger than your load) items over time, and load it this way. Hence every month you can have the same ID

nathan_rudman

these formulas don't work ? PREVIOUS() is how we avoid circular references in Anaplan world but I don't see any in what you are doing here

nathan_rudman

Hi find the documentation here

nathan_rudman

wahou... I was lucky enough not to encounter this in my projects but yes this is a major issue.

nathan_rudman

short answer: no long answer: you can work with two line items over the LIS, second one as text and change its value so it looks like a percentage and then hide/filter to show the first LI for the values, the second for the %

nathan_rudman

the only way to do sequential in pure Anaplan (without import/export) is to use the time dimension in a daily module and map results of each items to a specific day so you can previous to find the previous value of another item. I posted a guide on how to do inter-dependencies of tasks within a project (start date of one task depend on the start date of another) but I can't find it anymore...

nathan_rudman · ‎12-18-2020

one solution is: test all possibilities with a movingsum and a numbered list: extracting the result with first non blank: here's the list of possibilities: there might be an easier way if we are really talking about calendar days and simple numbers. but this solution will work for anything.

nathan_rudman · ‎12-18-2020

as I said you need to have atop level on your "rate" list. The formula is telling you that it is typed incorrectly. please check the names of the modules and the lists. This error says the rate list isn't called "rate"

nathan_rudman · ‎12-17-2020

depends where you type it but I put the full name of modules to be safe: IF rates.status and invoice.prod name = rate.prod name then IF Rates.start date < Invoice.Invoice date AND Invoice.Invoice date < rates.end date THEN ITEM(rates) else Blank else blank

nathan_rudman · ‎12-17-2020

you need a line item "rate getter" with the invoice AND rate list and do that formula with the conditions you are mentioning: IF all conditions THEN ITEM(rate) else BLANK That line item needs to have a summary type "First non Blank" (you rate list must have a top level) Then you can "extract" that rate into your valid rate line item by pointing to that rate getter line item. Anaplan will automatically pick up the "first non blank" result of the function at the summary level of the rate list

nathan_rudman · ‎12-17-2020

If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different dashboards. Recently re-discovered a solution that I find quite handy and decided to share it here. Here's the result. As you can see below, a user can select any level of the hierarchy, one by one and then all is concatenated into a final line item that you can use as a filter, to create the two grids below. I'm adding a "filter" dimension to that module so you can have several filters pre set. How do you achieve this ? Like this: And here are the formulas: The trick is on the summary level being Ratio. This allows us to bring the value of a parent level into the summary level of a child, like this:

nathan_rudman · ‎12-17-2020

Pre fixing a subset with the name of the list is A MUST and has been done for years but never seen using a subset as a placeholder like we do with lists and modules. can be quite useful for lists with large number of subsets. clever !

nathan_rudman · ‎12-17-2020

you could probably combine it if it was taking huge space, but it is better to split the formulas, for performance. Also, you might be re-using the movingsum result some other place in the future and that means you won't have to write back the formula.

nathan_rudman · ‎12-17-2020

applying a filter should not impact the order of the time dimension that you have set. you reorder, have all periods first, apply the filter, then what happens ?

nathan_rudman · ‎12-17-2020

for the version part, it really depends how you have built your model. If you have built it with native Anaplan versions, then you should simply have the switchover on your forecast in which case the forecast contains the actuals already. If you can't have the switchover you'll have no choice but to [SELECT:Versions.actuals] For doing the last 12, Id' use the formula MOVINGSUM like this: movingsum = MOVINGSUM(module.line item, -12, -1,SUM) do this in your source module then in your target module: source module.movingsum[select:versions.actuals]

nathan_rudman · ‎12-16-2020

I dont see why you cannot use it. When you try to apply the filter you just can't select your SYS module ?

nathan_rudman · ‎12-16-2020

this is too complex for this. You can achieve it faster with this: