-
Have to design a model with L5 hierarchy but Business says sometimes they might have an input at L6
Have to design a model with L5 hierarchy but Business says sometimes they might have an input at a level below for some regions. So should I be creating L6 or create a separate list and link it the values to Its level 5/parent in some other way around.
-
Add dimension name in NUX
Hi, Is it possible to add the dimension name at the top of the GRID in NUX? Regards, Tom
-
ALM Tag
Hi All, Quick question on ALM - On 31st Jan I developed something and create a revision tag and sync it to prod. And on 1st Feb I again develop something and don't want this to be in the prod but I wanted to be on the dev model. On 2nd Feb I develop something and create a revision tag and sync it to prod .I do not want to…
-
Anaplan is not allow my export showing message Excel workbooks cannot support more than 65536 rows?
-
Input time range
Hi All, Is there a way to restrict users inputs of a number (formatted) line item to values between -1 and 1. I cant use a list for this as users are free to add any decimals. Thank you in advance for any suggestions.
-
Load monthly data into weekly time setting model
Dear Anaplanners I have a dump question whereby I cannot get it over yet. I have a model whose time setting is designed as weekly (for later stage replenishment planning) While the demand forecast is still by month, so I have an import module to load monthly history sales dimensioned as below: My source csv file looks like…
-
Copy/Paste & Copy Across/Down in NUX
Hey All, One of our cards in the NUX will now allow copy/paste or copy across/down. The model is deployed, and that particular line item has a dependent list format. The odd part is this works find in the dev version both with and without dependency in the list format. My only guess is that it's a numbered list, and we're…
-
Accidentally changed Switchover date to 2023 when it was meant to be 2022, what can I do?
As the title reads, someone in our org changed the switchover date incorrectly and we lost an entire year's budget, is there a way we can revert this and salvage all of our information? Thankfully we have an archived model but we have tons of connections written to this model and want to continue working in the one that is…
-
NUX Filter zero
Hi, How can i filter zero balances in my NUX when : -> Time dimension is in column -> Time dimension is sync to the year selected I created another module to have a filter by year but when i am applying the filter i still need to select the time to apply the filter: Regards, Tom
-
Difference between the two types of CSV Exports
Hi, Can anyone help us understand what is the difference between the two export options highlighted below. I have tried out both but don't see any visible difference. Regards, Aakash Sachdeva
-
Multiply Line Item by Extra Dimension
Hola, (That means Hi in Spanish) I greatly appreciate any help you can offer. Thank you in advance I have a line item and I would like to multiply it by another line item in a different module. This other module has an extra dimension that we need to calculate. "New Funding by Turn and Credit" is my line item. (SS7) This…
-
Bulk Copy Action
I am aware that I can add Bulk Copy as an action via Action in Model Settings Bar however to set this up I have to select the target and source version/list member. Is there any way to set this up so that I can select the target and/or source when the action is being run?
-
Moved: Model Building Level 1. lesson 9.2.5 updating unit cost % to 5% not able to do
This discussion has been moved.
-
Learning Anaplan
Hi Team, I am new to this community and exited to learn about Anaplan model. Looking for some tips from where to start learning about Anaplan and get familiar with tool. Can you share the link to get started learning about Anaplan. Any help would be appreciated!!
-
Identify selected item when it's a parent
Is there a way to identify what item is selected from a context selector when it's a parent in a hierarchy list? Item() works when the chosen item is the lowest level of the list, but I'm trying to show what's selected if it's at any level in the hierarchy. Thanks!
-
How to prevent edits to a version
I have set the edit from/to fields to 'None' However, for data inputs where there the time scale is set to Not Applicable, users are still able to edit the data inputs. Is there any way to prevent this?
-
Nested IF statement replacement
I am looking for a best practice for the following. I have a driver-based model where the user selects a driver from a list of possible options. The user requirement is to use a check box to make the selection. The module displays the options, the check boxes, and the result. I am looking for a better way to arrive at the…
-
How to apply conditional formatting based on total?
I have a module dimensioned by L2 SubFunction list. I need to apply conditional formatting based on the total of all functions(ie., L1 Function summary). If all functions =100% green else red. How do I do this given that all functions is not a line item but the L1 Function summary.
-
Anaplan ALM Process
Hi, Our Anaplan Workspace environment is DEV - Prod. I have made changes to a process in Dev workspace. I need to move these changes to Prod Workspace. Here are the things I did. In Dev Workspace - Made changes for a process in a model. In Dev Workspace - Created a Revision Tag. In Prod Workspace - I used copy and Archive…
-
Minesweeper: How we Built it?
Do you remember the good old days when we used to play games like Solitaire, Minesweeper, Pin Ball, Checkers, etc in your big and bulgy desktop? Oh! Those were the golden times of youth, even though we cannot match the high-end technological development in graphics, storyline, real life game play, regular updates but the…