-
3.3.5.3 Check Your Work
I need help I am getting negative numbers for my beginning inventory and the week 1 comes off as a 0. On top of that the "Override Suggested Order Amount?" Boolean is not allowing me enter anything even though I have allowed the write access.
-
Level 2 Sprint 1: 1.3.12 - Can't see "Build Region" and others in "Build Geography Hierarchy"
Hello, I am on "1.3.12 Create a Process with Multiple Imports" of Level 2 Model Building: Sprint 1. I edited "1. Build Geography Hierarchy" process but can't find the below highlighted Imports: Instead, I can see the below imports where the action name seems to be the path from which I imported the saved views. Are they…
-
Level 2 sprint 3 3.3.5 confirmed Po delivery formula
I have used formula for confirmed PO delivery line item IF PO submitted =1 Then OFFSET(PO Submitted ,shipping time weeks ,0)Else 0 but this formula is not giving desired result of offsetting PO submitted in confirmed PO delivery..attached the screen shot for the issue please help me out on this
-
Level ! Exam activity 4 - importing data into SYS08 showing error in Role column-----Solution plz
-
Import Error : Shipping Metric
I tried to run process 9 - Import data from Hub. The issue is similar although it's failing to import into the Shipping Metrics. No details of failure is provided. I checked for data mapping by trying to import just the shipping metric Not able to successfully import the shipping metric. Can someone point me what's the…
-
How can i get back the names into E2 Employee# list the whole connected formats changed...
-
Cell History - No history found for this selection
When I am trying to "Show History" on a cell that I know has shows data, I have the following error message to show: "Cell History. No history found for this selection" Is there a setting or something I have to chose for the history to be shown for specific cells? Or has anyone ran into this issue before?
-
API Read cell data by coordinate
As an integration builder, i need to be able to read cell data based on a cell coordinate. This is similar to the update data api call with the difference that it s a read instead of write. This is needed as sometimes you need a specific set of data to be interacted with other applications dynamically and you dont need to…
-
Capability to define a Default Value
-------- Edit : There was a problem with the body, below the good explanation 🙂 -------- As a Workspace Admin, I would like to be able to define a default value for some Line Items (list, number or boolean). Ex: When a user adds a new row, I would like that some Line Item to be automatically filled with a default value.…
-
Restrict Date Selection
We have a date field to be selected in a line item which is date formatted....Can we restrict user to select a date beyond certain user defined date field....;,e any date they want to select should not go prior Oct 2021....(which is a user defined field) and its dynamic.
-
Help on circular reference
Hello, During my training, I had to build the Inventory ordering module for the supply chain model (level 2). After building it following the instruction, I'd like to test new formulas to determine the Suggested Order Amount for the Month. I'd liked it to be equal to the Forecast demand + Safety stock target - beginning…
-
How to create SYS: Modules, Filter: Period
Hi, I am trying to create SYS: Module and Filter: Period module. Can any one help me in this. Thanks, Maithri.
-
A list item value should be equal to the sum of values of other list items.
Hi friends, I am having a issue related to list items. As shown below, I have a list with items a, b, c, d. I have used this list as a dimension in a module which has value(number formatted) line item. I also have other list with items a, b, c, d, e, f, g. Now, this list is used as a dimension in other module which also…
-
Folder / Directory for Models or perhaps tagging feature to easily find models
Feature suggestion: In the Models view under https://us2a.app.anaplan.com/home/models for example, it might be good to have a feature to create a directory in order to group interrelated models or perhaps have a tagging feature to help sort and group models together. Not sure how this can apply from Customer end maybe for…
-
Unable to pull data from DEM02 module into DEM03 module
Dear Experienced Anaplanners, I am at Level 2 Sprint 2 trying to use formulae to add data to Demand modules. As per the lesson, I've created DEM01, DEM02 and DEM03 modules. DEM01 and DEM02 are Volume Growth Rate by Month and Volume Growth Rate by Week modules respectively. I have used formulae to pull data from DEM01 to…
-
Many to Many Dimensions Rollup
Given: End user can input in the following 9 columns as a dropdown(List Format) in the Input Free Form. Free Form is a module having a Numbered List applied which is having these Line Items as a List Format so that users can choose from the dropdown. Following is the count of List Members in the lowest level.…
-
Formula to add line item from Monthly set up to QTY
Hi Community, I would like to ask if this is possible. There are 3 modules done but 1 module is set to monthly and the other is set to quarterly. See below for the illustration: I had to create an illustration since I cannot provide screenshot from the model due to confidentiality. This is the revenue module. And then they…
-
TAR01 Detailed Sales Target Level 3 Model Building
Hi, I have a question on the LI "Initial Country Sales Targets" in Module TAR01 Detailed Sales Target. For this line item I'm assuming that we are pulling from the TAR01 Sales Targets where the initial country sales targets are calculated. Would I then use my SYS03 Module to SUM by Country and Product? Below is a screen…
-
Data Import error
The target mapping The Source mapping The dimensions are different in source and target. I am unsuccessful and having issues with successfully importing into the module. Any suggestions on where I'm going wrong?
-
Sorting and Filtering of the list based on page selector.
Hi Team, I have a module with Location as a dimension and line items Sales, Profit, Expenses, Opex and Margin. I want to create a Dashboard or Dynamic Report where these line item will be Page Selectors and the locations will be published based on the selection , sequenced and filtered with TOP 5 values. For Example :…
-
L1 Model Building - Actual and Forecast settings and difference
Hi, I have just started L1 MB course and unable to understand time settings. Could someone please explain why Actual period is FY2019 and not FY2020 when we have set the current year to FY2020 in main time settings . Also why forecast period includes FY2020 ? Please see these below SH. Many Thanks. J Hamid
-
Retrieve Current User
Hello, I can use item(user list) to get current user, i.e. the user who login current system, it requires to use user list as dimension. Now I have a module which is not dimensioned user list, is it possible to retrieve current user directly without adding user list as dimension? Thanks in advance.
-
Scaling a number in number format options
In Anaplan it is not possible to scale a number. i.e. show the value of a number in Millions or Thousands. Instead we create a scaling line item and divide all the related line items by this. It is a repetitive work. In New UX I have noticed this when bringing numbers from the source. Scaling option can be accommodated in…
-
Round Robin / All possible Pairs from List
Good afternoon (and sorry if this is a real beginner's question), I have a quick question regarding Anaplan's functionality. I was wondering whether it is possible to extract all possible pairings from a list (e.g. across the dimension of playing rounds), so that each list item is paired with another exactly once,…
-
Call Action using API
Hi Anaplanner, As we know in new UX we can send email notification using action, Can I run that action using API?, so that action will be running by scheduler. Regards, Panji
-
1 GB Workspace - 90-Days Anaplan Access Program
Hi, I was granted access to Anaplan Learning through the 90-Days Access program. I am unclear on how to get access to the 1 GB interactive workspace that is included in this program. Do I need to send in a separate request for the Workspace even though I have access to this program? I have sent emails to the TalentBuilder…
-
Properties and Subsets Enabled For User List
Quite literally what the title says. I am able to point and click on the different features just like a regular list, or I can apply the User List for specific roles to reduce sparsity. There are advanced methods of data entry, where validation is done up front, preventing bad data from entering the data set, that could…
-
New Model Experience: Open Model from Manage Models
Not the highest priority item in the world but it would be good that when opening models from the manage models box that it opens up into the New Model Experience as that's what i've selected as my option on the homepage. Hopefully this will be being fixed as part of the migration to New Model Experience being the default.
-
L3 Percentage calculation Not Matching
L3 Sprint 1 - User Story 5 My Percentage is not matching This is my Ratio. Let me know where I'm going wrong.
-
Time mapping issue
My Mapping looks like this What mappings needs to be done in the Time i can select the option for DD-MMM Please guide Regards, Srini