Hello Anaplanners, I am working on a deployed model and i am getting this error when i tried to model to model import data : 'Failed to locate model ' Can anybody help me on this. I am attaching the s…
Hi All, I've one situation where I need to build a optimizer which will minimise the transport cost & transit Time, Below are the details: Inputs : 1) Factory Supply Qty 2) Distribution center Capacit…
Hello, I see there is a 50M cell limitation on being able to use the rank formula. I'm trying to clarify what I look at to determine if the line item I want to rank would be under or over the limit? F…
i'm new to the Excel Add-In for Anaplan. If I point an Add-In model at cells in a particular version, say 'Working' and then deleted it, can I create another 'Working' version and will the pointers in…
Hello, I would like to build a filter where the user can select the dimension (list) by which they want to filter and then have another grid next to it where the selected dimension's members appear. I…
Hi All There is a list formatted line item in which the list is at lower level of hierarchy. I need dependent dropdown for particular items in the list without showing higher levels of hierarchy. Is t…
I have a module set up with weeks as the time dimension and covers a two-year timeframe. However, calculations are only needed for the user-selected quarter. To optimize performance, I'm looking for w…
Hi All, I have a module that has line item subset as one of the dimensions.. Cost Center, Time, and Line item subset. The line item subset has three members, A, B and C. You can have input on them, ho…
Hello, How can I get the information contained in "current year - list" (year dimensioned) and put it into "current year"(non-year dimensioned)? Thanks in advance, Luca
Hi All, I've one scenario where volume needs to allocate by Rank. E. g. We have demand at Parent level i.e Product family level. Now in each product family we have different SKU's & demand should be g…
Hello, I am trying to change the dimensionality of the line item "layer yearly pt1" from: company, gr consolidation, scenario, year to: company, gr consolidation, scenario in line item layer yearly pt…
Hello, I am trying to use FIRSTNONBLANK as a function to get the current scenario to match to the current year starting from module dimensioned as month. SOURCE MODULE TARGET MODULE As you can see it'…