-
I NEED HELP ASAP
Hello, I need your help please!! I wanna import this file CSV in a list on Anaplan without edit the file. should i import the file in a module and create a code for each line then import the view in the list ? and how to do it ? thank you RGDS
-
Is it possible to colour input line items for ease of inputting. For eg as added in the screenshot.
Is it possible to colour input line items for ease of inputting. Also this colour should be present even before any data is inputted.
-
Adding list items, but only display the result when a list item is selected
Hi all, I'm experiencing an issue in my module where when selecting a certain list item ("online" - in the screenshot), the numbers aren't displaying as they should, and I'm getting 0 in every line item. I think this is a build issue, however I want to try a hotfix by adding two different list items that I know total to…
-
Calculations with list items
Dear all, I created a line item "Figure" and a list "Divisor". The list just contains two values: 12 and 24. I further created a line item "Result" which should display the result of Figure divided by Divisor. So my module contains three line items: Figure: Number Divisor: List Result: Number Unfortunately Result = Figure…
-
Converting a Classic model to Polaris
Hi, Is it possible to simply port an existing model built using the classic calculation engine into Polaris? Thanks,
-
Formula to allow duplicate
Hello, I am trying to make a formula in order to be able to create duplicate codes. At the moment my formula goes like this: IF Boolean THEN Concatenated Code ELSE Blank And I want for my formula to do this : IF my boolean is checked, then my formula should return the Concateneated Code but i want to allow a duplicate not…
-
Time dimension formula
Source Module has Year, Target module has Months. Source - Time dimension (YEAR), Cost center dimension, Line Item Target - Time dimension (Months), Cost Center dimension, Line item Source has rate by year, for example for FY23, Want to bring FY23 rates to all the months in target module. What formula would i use in terms…
-
Formula SUM
I have A List of Farms - 'FarmNames' - showing the Farm name, and a Property - 'Shop NameShop Name' -which shows the shop the farm serves. A module - 'Farm Apples' - showing the name of the Farm, and the manually entered number of apples by month for the past two years, where apples is the only line item. I want to show -…
-
Assign values to duplicate items
Hi I have below module that is update every few days UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan two records were updated when the next time(eff from) the job runs like below UID Name From Date To Date 1 A1 17-Jan 2 B1 17-Jan 3 C1 17-Jan 4 D1 17-Jan 5 A1 25-Jan 6 B1 25-Jan I want to…
-
Is there any way to export the line items wise view, by using export action(date format line item)
Line-item kept in page selector as Date format
-
Setting time as forward 52 week
Hello, For my model, planning cycle we look at it forward 52 week. The planning cycle start at the beginning of each quarter. so if we are in Q2 2024, 52 weeks will be from Q2 2024 - Q1 2025 I see option to set week as calendar type but for planning year, I can only select complete year. The only option I have is to select…
-
Change fiscal year without losing Data
Hi Everyone, Is there a workaround to change the fiscal year of a model without losing the data? My colleagues made their planning in a model that has timesettings for 2018, but they want to change the Fiscal Year to 2019. is this possible without erasing their data (which is manual input)? The Model only knows the current…
-
Bill of Material Explosion - Best Practice
Hi, Pondering my head around a Supply Chain use case where a bill of material explosion is required with an undefined amount of steps to get to the lowest level. This should be an iteration where an SKU can have a one level explosion or up until 6 levels of bill of material. What is the best practice of Anaplan to set this…
-
3.3.5.3 check your work numbers are out (most likely Dem03)
Hi team, Working through the level 2 model builder course and have hit a snag. My Dat03 Historic values is populated and working as intended with the forecast year pulling the value from the previous year I believe my demand forecast is also working as intended with FY21 pulling from FY20 My issue is my final forecast is…
-
Dynamic Cell Access
Hi, I need to apply two DCA in one single module. It is like I have done driver based planning and applied one DCA with that. Another DCA I need to apply is for approval. Like if a checkbox in one line item is approved then related module line items should get disabled. Can anyone please help? Thanks
-
Why am I receiving the error "Not a recognised line item or list member" in my example?
Hi Anaplan Community I have two modules (“Allocations Stage 3 Mktng Media Allocation Result” and “Allocated Expenses”) that I want to link together but I am getting the error “Not a recognised line item or list member”. Below is the blueprint of “Allocations Stage 3 Mktng Media Allocation Result” Below is the blueprint of…
-
how to average on roll up
I have a module where I have sales per country. I want to average sales and not add when I roll up to region or when I chose region from drop down. How can I do that?
-
Help on Selector
Say I have a module with multiple different items and each item has a sales amount, a corresponding sales region, customer, and line of business. I am trying to build a dashboard where I can view sales amount by customer, and then have sales region, line of business and other options as a filter. I have built a separate…
-
Automated Loads not working | Working when manually run
Hi, Facing a strange issue. We have a process of around 15 actions that takes snapshot from each module and its automated and run using an integration account (full access). Strangely the same is not running in one the UAT environment, while running automatically in SIT environment. Also, when manually run its successful…
-
Notification error
Hello, Sometimes I get this failed notification. In some cases it works, sometimes it doesn't.
-
Anaplan Excel addin and windows 11
Hi Please advise: Quilter is migrating to windows 11. However, the Anaplan Excel addin - Check your software versions and settings for the Excel Add-in | Anapedia (anaplan.com) only supports: Windows version compatibility The add-in is compatible with: Windows 8 Windows 8.1 Windows 10. Self-Service Security Assertion…
-
NPV with Rolling Period
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
Level 3 Model Building: Schema Design - Part 2
Hi Team, Plz help me with the formula for Define in Active Subset? line item from chapter (4.2) List Subsets - Advanced Topics As I am unable to add subset in to the formula. @jared @Misbah
-
NPV with rolling start date
Hi - I am trying to build a module with an NPV calculation which in each month calculates the NPV of cashflows starting from the next month until the last time period in the module. So in Jan-24 it would calculate the NPV with cashflows from Feb-24 to the end of the module. Then in Feb-24 it would calculate the NPV from…
-
I am not able to Login to my Anapla to build models
I can login to view course, but when I try to login via this link it is repeatedly saying the pwd is incorrect. Im also not able to set it right as Im receiving no email. Do we need a business email or account to access this?
-
L2 Course - Supply chain model INV05 Shipping Export
Hi, Any expert please help , I am stuck in Importing G3 location in "INV05 Shipping Export" module , I alreay crteated Subsidery view doe CODE line item , in this Module , but while importing Data from G3 location List , it is ignoring the Parents like "US", please help me to understand what is wrong in steps , please…
-
I am hearing about custom versions these days and would love if someone provides an example of same
I am hearing about custom versions these days and would love if someone provides an example of same. Does we create any list for version or the versions tab for acheiving this
-
Export with different dimensions
Hello, I am trying to make an export. In my Export, I need to show on a column category Int and category Ext (both on same column). The problem that I have is that the domensions that I need to use for this information are in the Children of my dimension. Let me make a scheme; Dimension A - the one I have to use Dimension…
-
4.5.1 Activity: Rename Organization List, what to do:
Hello I am trying do the the Model 1 Lesson 4 but I am stuck. 4.5.1. In the model you are building, click the Lists icon on the model settings bar to open the General Lists tab. This allows you to see all of the Lists included in the model. When a new model is created, the Organization list is created by default. This list…
-
Average of active months
Hi, I have a module which shows asset values on a quarterly basis. For terminated products, the current asset values are nil. However, instead of showing nil, I want to show the average asset value when in existence. In my module there is a line item for product status and this can be active, liquidating, terminated but…