-
Show Parent when no child + selection
Good morning, My lists are as follow. Parent: Mission --> Programm --> Activity --> Expense (lowest level) My objective is to put in place a filter that allows me to see the Activity items even though I have no existing Depense under the acitvity, combined with a filter where the user can select to narrow the view on one…
-
Workflow Process Approval
Hi! I just wanted to ask for assistance because my driver module wasn't able to lock the input cells on my Input module. On my input module, dimension is the child while on the driver module, dimension includes the parent and version. Thanks.
-
Versions in the new UX
So I'm creating a page in the new UX, essentially trying to display Actual and Budgeted amounts for a period. I'm intending to have the Actuals and Budgeted amounts shown as columns and the different categories as rows. I also want to show the variance between these two versions on the same column axis as the versions…
-
Unit Testing is for finding bugs, not show correctness
Architect, Builders; Having worked projects with hundreds of bugs, the natural question is how did this happen? The solution passes User Acceptance Testing means that it was adequately tested. This could be a paradigm shift for some in thinking about unit testing. Doing a quality job of it adds time to get a solution to…
-
Processing when I wrote the formula incorrectly
Hello, I would like to clarify the information because I did not find it. I understand correctly that the number of actual working imports from one model to another affects the total processing time as a result of the formula writing curve. Example: In the working model, in case of an error, processing can take 9-15…
-
Issues with Action Not Working in Production
Hi All, I implemented this method (Article below) of dynamic renaming of line items for a customer that require time-based data combined with non-time-based attributes to the same data. It works very well in DEV Model. The issue is when I sync it and run the action in Production to change the line items name. It shows me…
-
Native YTD Calculation issue
Hi, I have various forecast versions and a prior year version. I want to do a comparison between the selected version and the prior year version. I am finding that the YTD time summary for the prior year version is not taking the YTD as determined by the selected version. You can see that the YTD calculation for Current…
-
MAPPING
I have a module with dimension x and I want to get a line item y from another module with dimension z . How can I achieve this in anaplan? I am unable to use direct lookup modules
-
Sprint 3 Level 2 - Shipping Time Weeks Error
So I can't currently can display the Shipping Time, I will attach on what I am seeing. You can slightly see my formula above the screen. What can I do to resolve this bug?
-
What is the difference between Statistical Product Forecasting model and Monthly Statistical FC engi
There are two types of statistical forecast models available for in Anaplan - Statistical Product Forecasting model and Monthly Statistical Forecasting Calculation Engine
-
how to calculate WEEKNUMBER of a particular date in a year
Hi Anaplanners, i am stuck with one the calculation ,which requires me to calculate WEEK NUMBER of a date in the year.In excel we can use WEEKNUM Function to get the number of the week . eg,WEEKNUM(2020-03-02) = 10 How can i achieve this
-
Cannot download Certified Model Builder after completed all activities
Hello, I just completed all required courses (please see snapshot below), but was not able to download the certificate. Refreshed the page multiple times and waited over half hour, still not working. Appreciate for your help.
-
Import Mapping Issue
Hi All, I'm having an issue with importing a csv file from excel. Below is the column headers that I want to match, the Unique ID and all the other column is what I want as "Header Row". When I make the "Header Row" to be the Unique ID row it then shows me this Does anyone knows how to rectify this and make it show all the…
-
Want to match a property that one data source has to another data source
Hi, I currently have two different Data Sources in my Model (D01 & D02). They both share a MID and a CID that can link the data together. I need to be able to look up my data in my D02 Module by a List named Legal Process. I'm having difficulties making this List match the data in my D02. I know I can potentially create a…
-
Prevent import in selected months
Hello, I would like to give access to a user so that he can upload himself a CSV file in a module (with a time dimension). I do not want that this user changes by mistake past months. I've done a DCA on the line item of the module saying "write in July 2023". The module is in "write" in July 23 and "read" the other months.…
-
Manage User Imports
Hello! I'm developing a Demand Planning Model for school books. Every year, it is critical to update the list of SKUs [both delete and add SKUs] as well as the SKU details [School Subject, School Year, Type of Book] - in the systems module Given that these SKU information are also lists in my ANAPLAN model, I would need to…
-
I want to put a period filter.
I want to put a period filter like this so that when the user checks the boolean, the data of the months associated with the year will be shown in the below grid. Need some help with this.
-
How to choose multiple departments in page selector
I'm creating dashboards for budget owners at my firm. In the dashboard I have a variance analysis module showing budget vs actual. If one of my page selectors is the department (Dev, Sales, G&A) and i wanted to show only software dev, and strategy under the dev department in the module how could i do it so that the budget…
-
Formula showing YTD actuals + Remaining Year Forecast
I'm looking to build a formula that would show the current YTD actual expenses, + the remaining year forecasted expenses to arrive to my FY total expenses. The current model we have set up adds together "Expense from direct Input plan" (Basically our YTD actuals) and adds this value to another column called "Expense from…
-
Condition on a Boolean.
Hello, Is there any way to have boolean line item with a formula and editable depending on the condition? For example: IF Condition_1 THEN True ELSE (boolean editable by the user) Thank you
-
How to change order of line items in a saved view of module
I am trying to change order of line items in a saved view but everytime I click on reorder It opens all line items if module and not default view ones
-
Employee department Change
For example, Amit Kumar joined on 01/01/2020 in the sales department and transferred on 05/01/2021 to the finance department. I made a UX page where user can choose the leave date and the new department the employee has joined and run the action which will add a new List Item [ Amit Kumar ( Transfer) ] with a new Code…
-
List not aggregating by top level
Hi, I am building a model which stores historic data of investments/"assets" and reports on them both individually and in aggregate (i.e. the portfolio). I have two Lists. One is called "Assets" and a second called "Portfolios". "Assets" has the total list of the investments in the portfolio. The Parent Hierarchy of the…
-
Formula for calculating Time Coverage
Hi everyone! I'm having trouble in resolving these request in Anaplan. Basically I've got 2 line items in a module with Time Scale Weeks: Expected Sales Quantity = Qty of Product that is expected to sell in every week Final Stock Quantity = Qty of Product in Stock in every week The request is to calculate for each week of…
-
Copy data from one item to another item by cloning
HI
-
Can't show previous period month
Hi, I'm trying to create formula to display the last date of the month with logic like this: If 'Manufacturer end date' is the 1st, the last date of previous month will display, otherwise the last day of the current month will display. e.g. If 2023-07-01 is the 'manufacturer end date', then 'Shipping end date' will display…
-
Sample Reporting
Good Day All I m looking for a sample report template on the assessment of incorporating two models into one ( like workspace optimization, impacts, and advantage ). Can anyone help to share the same? Thanks in advance.
-
How to handle time when setting a filter?
Hi all, I'm sure you guys already have dealt with this issue. How do you handle time when you need to set a filter (for instance "greater than zero) on a line item and Anaplan forces you to pick a specific month? Thanks in advance
-
Total number of Archived models in Workspace
Hi team, Is there any limit of archived models that can exists in the workspace? Any links/articles will be appreciated..!! Thank you, Shraddha
-
Count line items
Hi, I am looking for a way to count the number of TRUE items for a Boolean formatted line item. As per above image, since 3 of the Booleans are selected, I need a mechanism where I can get 3 as the output (it could be in different module as well)