-
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…
-
September 2022 releases and October sneak peek - View Modules Used In Pages
The release this month is helpful but I think it missed expectations. What would be more helpful is to be able to see what UX pages a module is published on in the exact same way the "Used in Dashboards" column is in the Modules. The update would more or less be "View Pages Used in Modules". I used the column in the…
-
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…
-
Function to Count Booleans
There are occasions in a model where I want to count the number of True or False boolean values. Currently the only way to achieve this is to have another line item with an IF THEN function to create a 1 or 0 and then sum the line item. It would be great to have a function to do this automatically.
-
Level - Sprint 1 - 1.4.6.1
1.4.6.1 Rename Actions Using the recommended naming conventions for Actions: * Rename the Actions used to load the P3 SKU list and SYS12 SKU Details system module:* Organize the Actions in the correct sequence. * These Actions will be included in the Process: 1 Load Products. * Rename the Action used to Build the P3 SKU…
-
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…
-
1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
-
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…