Modeling

Can Anaplan read data past model calendar?
I used the PERIOD function to fill in the dates for a filter I am using in Month LU line item. But Anaplan isn't reading any dates past 2025. Model calendar ends 2024, is that why?
Converting Data within module
Hi I have data in below format. I am expecting to create a new module with below dimension and structure. Could you please suggest an efficient way for the same? Thank you
REP04 L1 - Datatype error
Hello, I am completing the Level 1 Model Builder but am getting an error during one of the exam questions. I am pretty sure my formulae are correct but i dont understand what the error is telling me nor what to look to resolve. It is: 'Datatype mapping used for aggregation doesn't match any dimension of the result'. Can…
3.3.5.2 Inventory Ordering Module Formulas
Hi, From 3.3.5.2 Inventory Ordering Module Formulas I am not getting correct output for 2 line items - Beginning inventory and shipping time weeks. Beginning Inventory - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory…
Filtering Line Items
Some way of filtering line items; Use case is that users are on pages, and different users wanted to see a different set of line items. We were using a line item subset, but since it only could include line item that had numeric values, it could not hold all line items. Current behavior: Line item can only be filtered on…
New UX should allow publishing Page Selectors
Currently, New UX only shows page selectors which are dimensions of modules. In classic dashboards, we have the ability to publish any list as a page selector on any dashboard. For example, we publish parent levels(of module dimensions) as page selectors. This is a must to have feature. We feel that New UX is a step…
Scenario Planning.
I'm looking for scenario planning model building. Can anyone point me to a learning tutorial?
Iterate Process X Times
Functionality should be added that allows users to iterate a process X times. This could be done with nested processes (which have gained support and would have other use cases), or some other configuration to determine if a process should be run several times. Use Case - pro forma financial statement development. To…
Help - Stuck on 1.5.6.1 Create Historic Volumes Module
I am still having trouble with 1.5.6.1 in L2, Sprint 1. It says "DAT03 Historic Volumes Invalid Line Item Identifier." I have attached screenshots of how I have mapped things - can someone please help? Thank you.
1.4.6.1 Rename Actions
I'm lost here: "Rename the Action used to Build the P3 SKU list from the saved view" I'm not seeing any additional actions to rename. Also confused at which action contains the SKU flat list to rename "1.5 Load SKU Flat". Any assistance is appreciated.
Column Header Labels
One common ask that I normally get is having 2 levels in the column headers. While this can be done by adding another dimension, manually hiding excess columns, and publishing them in a page, this ends up taking up unnecessary space if the intention is to just have the 1st level of the column header act as a label. Would…
1.3.6.1 Create Build Region Saved View
As per the requirement i need to * Include: Code and items I dont have items as a column to be selected Please help with this, whether i have missed any steps earlier. Regards, Srini
Week Coverage, also known as forward coverage or stock cover
A description of the enhancement requested Week Coverage, also known as forward coverage or stock cover. As an example we have Forecast Sales and Current Stock. Formula should calculate how many future periods of forecast will be covered by Current stock. This is achievable in Anaplan with below function: Look Forward +…
3.2.11.3 Create Saved View for Combination Chart
Can someone help me debug this, I've checked my SYS01 - Planning Period Filter Weeks. I am sure I am supposed to see the rest of my weeks and not be limited to week 8.
How to Hide "Source module" in Dashboards
Hi experts, Does someone provide me with how to hide or inactivate "open source module" in dashboards? The client users are not allowed to go into source module from dashboards. In this case, I also want to conceal module name in dashboards. Regards, inoue
Anaplan History Extraction based on Specific Criteria
Hi Anaplan Team, We now only have one option for extracting history: selecting a date range. It will benefit all model builders and Anaplan workspace admin users who truly take part in model development if we can offer more options, filters, or criteria. History Extraction Options along with Data Range: based on a specific…
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…
Level 1 Model Building Exam - Model Building Activity 4
Hi, can anyone help me to figure out what's causing the error for importing the data into EMPO3 Employee Drivers by Role and Employee+Drivers+by+Role module? 1.1) If I load the original downloaded file of "Role List", it's showing the following error. 1.2) So I deleted the Parent column to load it as below. 2.1) After the…
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…
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi, Appreciate a starting guidance on below for what's needed as a starting example. Rather than let imagination run wild in learning stage and end up with incorrect requirements. Is conditional formatting needed here? Thanks. Add Read and Write Access Drivers to INV01 Inventory Ordering module to set up Dynamic Cell…
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…
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?
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
Changing the Sign for Aggregation
Use Case: In a lot of financial account hierarchies, costs are shown as positive numbers—but need to be subtracted from the totals. With Anaplan, this is easily achievable with line items. The line item formulae are as follows: * Margin = Sales – COGS * Profit = Margin – Costs This is a very simple example that is easily…
Multi-layer sort
Would be very useful to have a multi-layer sort (not filter) like in Excel i.e. Sort by column A alphabetically, then by column B, then by C. Acknowledging the workaround to concatenate the desired fields into a text line item and sort by that, but to me a publicised workaround is always a pointer to a needed/desired…
The three most useful applications of the data write action
Model building in Anaplan has been nothing but a pleasure regarding ease of use and adoption; not only it is an excellent choice to drive standardized models across an organization, but also provides support and follow-up at the needed cadence. And if we talk about the user experience — with upcoming features being added…
Using a KPI card to sync monthly data with a year time selector without additional filters
This example demonstrates how a KPI card can serve multiple purposes to provide users with a dynamic descriptive title on a page while also avoiding the need for creating additional filtering to update monthly grid or chart cards where users require a Year Only selector. The example uses a KPI card, grid card, and chart…
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…

Modeling

Discussion List