Modeling

L3 Quarterly initial sales target
I am actually stuck in this and need some help 1. In the Level 3 Sales Planning Model I have created a module and successfully imported the data from the data hub for Actual Sales Revenue. Its dimension include - A1 Accounts, P2 Products 2. I have another module in which I have dimension as G2 Country, P2 Product Family,…
Level 2 Conclusion - Import Final Demand Forecast into DAT02 Module
I'm literally at a loss at what its asking me to do here...nothing I do seems to work so I obviously dont understand the question. Please can you help?
Previous Value in a Dummy Time Dimension
Hi All, We are developing a module using a dummy time dimension as the planning needs to be done for a period of 3 months. So just to save the space instead of using Anaplan Time dimension we have created a list with a subset for three months to be used in planning. Now we have few line items as below where we calculate…
Anaplan Summary calculation, conditional formatting
I'm stuck in a particular case. I have a flat module that is is dimensioned by "Test Cases". This module looks to accept attributes for test cases manually entered/selected by the end users. The attributes are Test Case Name, Number, Country, Date, Category etc. Particular line items like Country and Category being list…
Working days between 2 dates - errors with proposed formula
Hello All, I used the suggested formula to calculate the # of weekdays between 2 dates https://help.anaplan.com/21bf8e70-3193-4912-98c6-f25327c11d19-Excel-Equivalent-Formulas and I noticed many errors when the end date was a monday (see attachment). Has anyone else also noticed that? Also, I would like to propose a…
I want to check only April from the period
hi! I want to check only April from the period. The reason is to use the cumulate function. I'd like to check only April in Boolean, is there any good way? As a concrete content, I want to check only in April of FY19-FY22 (month period) I am not good at English and may not be able to communicate well, but thank you.
Combining Line Items with Different Dimensionalities
HI all, I need to do an equation in the third line item that subtracts the second line item from the first one. The issue I am running into is the different dimensionality of the first two line items and then trying to combine it into having the third line item dimensionalized by both lists. I appreciate any help.
Level 2 - Sprint 1 - 1.5.6.2 Import Data into Historic Volumes Module
Hi everyone, I'm having trouble importing this into DAT03 Historic Volumes. I've been at this for 3 hours and I'm not sure what's wrong. Can anyone help? I can't move on to the next activity until I get this right. Thank you.
Set the Export File Name at the time of Export
Hi when running a Data Export I would like to be able to choose what the file name should be when exporting the file via a prompt. In an ideal world I would like to be able to decide on a prefix and suffix for the file name. With one of the options either being the date/time or the value I set in a module. One of my…
Aggregate Subset of Dimension
Hello, I'm trying to figure out the best way to aggregate a line item with two dimensions (SKU and Sales Channel) by Channel. For example, I would like all sales for a specific SKU for only website or Amazon channels. The issue I keep running into is my aggregation line item dimension should only be SKU to save on size,…
Increase end user adoption with smart filters
* Problem statement * How do we solve this with smart filters? * Customer examples * How to model smart filters * Size and performance considerations * Upcoming functionality * Conclusion Problem statement Anaplan users are often moving from an Excel environment (with the flexibility to filter, search, and sort data…
count wrt day timescale
Hello , I/p screen Products start date End DateA11/3/20205/3/2020A21/3/20208/5/2020 O/p Screen should contain the product count and it should look like 1-Mar2-Mar3-Mar4-MarNo of Products2221 Can we able to do this in anaplan?(As the output screen in Day time scale) Thanks Tejaswini
Datatype error?
Hello, I'm trying to get the desired output in (see below or view the attached image). So far what I've tried doesn't seem to work (datatype mismatch). Any ideas on how to solve this?
L1MB-5.2 model maps
Hi, I am facing problems in 5.2.2 model maps overview.I am unable to figure out how to do this step.Please help.
Level 2 Activity 1.4.3.2 Import Data & Add Formula
Hello everyone, I have a question concerning the task 1.4.3.2 in level 2 model building. Why do I have do add a formula to the code line item? I have already received the codes through the import (see picture attached - I didn't add a formula). Thank you in advance! Johanna
Modules/line items actually used for filtering
Dear Community, I have a few modules that were created specifically for filtering purposes, but after some time I can't remember whether they are really and still in use for filtering, therefore I don't dare to delete them during a model maintenance/clean-up process. I can see that those modules/line items are not used as…
Allow ISFIRSTOCCURRENCE to search against time
IFO returns true for the first occurence of a value against a specific list formatted dimension. i would like the possibility to validate against the time dimension as well.
Publish Modules/Actions to Dashboard
Hi Team, Can we have the ability to search the existing dashboards when we try to publish a Module/Process/Action. Currently we have to scroll and search for the existing dashboards while publishing. Thanks Sathya
Formulas - dimensions month vs years & collect
Hi, I have a module that shows line items in years and uses the collect() function. I now need this in months, so have made a copy of this module, changed dimensions to months and there's currently no figures showing. How do I fix this? Thanks in advance
Level 2 Sprint 3
@JaredDolich I am at the point where I am comparing my INV01 data to the Anaplan lesson example and my numbers aren't matching. I have a couple of questions about INV01. For Beginning Inventory: My numbers are good until week 4. Then I realized that when triggered the PO Submitted boolean, it showed up in the confirmed PO…
Level 2 Sprint 3 INV02 Country Summary module
Am I getting the wrong end of the stick?
Circular reference caused by interest effects on profit and cash
I have an issue with a circular reference for a revolving cash facility (RCF) calculation, which effects interest and cash figures, which then determine what the RCF closing value should be. The transaction/calculation is circular in its nature rather than it being an anaplan specific circular reference. Basic summary of…
Roles List
Hi, looks as though the Roles List has changed from what was originally in the Datahub (or perhaps it's a different list). We are given an Employee Details file to upload in the Datahub Model and the roles do not match the Roles flat list in the Datahub. Assume we need to create a new Roles Flat list and codes in the…
Level 2 Sprint 3 INV01
I am at the point where I am comparing my INV01 data to the Anaplan lesson example and my numbers aren't matching. I have a couple of questions about INV01. For Beginning Inventory: My numbers are good until week 4. Then I realized that when triggered the PO Submitted boolean, it showed up in the confirmed PO line for the…
Day Time Scale
Hi I want to show daily in my Model for (Monday, Tuesday, Wednesday, Thursday, and Friday). Example : My time scale should be like Mon 01 Jan ,Tue 02 Jan ...... Is this possible in Anaplan? Thanks Tejaswini
Correct Formula's for Confirm PO Delivery and Confirmed Purchase Order Receipt
HI. Please could you give me some guidance on the below? IF PO Submitted > 0 THEN POST(PO Submitted, Shipping Time Weeks) ELSE 0
Formatting time: Period instead of month
Would be great if a customer could choose how to format the months not just Jan 21 but P01 21 or P1 21 or P1 FY21. Now the period notation is only possible when selecting "13 4-week periods", but not if a customer selects any of the other option, like a month model or a week model with 4-4-5.
Anaplan Workspace, Model, Module, and Line Item Performance Planner
Some customers would like to have an Anaplan Platform feature to determine the resource utilization by a Model and Workspace from the Anaplan server-side: a tool that could show the specific amount of resources consumed by each line item and module. According to the same customers, that feature could show graphic and data…
Lists
Hi, I am creating a module where I want Assets rolling up into Products (I have set Parent of Assets as Products). It is currently just a regular list, but my question is, do I want a numbered list? What is best practice and when is it best to use numbered lists? I've tried ANapedia but I didn't find it very helpful.…
Highlight Dashboard
Hi Friends, I want to highlight the Dashboard and not the Module. As when I apply conditional formatting and edit rules, it updates Modules as well. How to achieve that? N.B.- I am referring to Classic Dashboard.

Modeling

Discussion List