-
Using Python's statistical capabilities to Manipulate data already in an Anaplan Model
I want to leverage Python's statistical capabilities to manipulate data already in an Anaplan model. Has anyone done this before / had any experience with this? I know I can use Python as a data integration tool, but would like to also use it for calculations.
-
Is it a Bug?
I have a dimensionless module with two line items Line Item 1: Amount (No TimeScale, No Versions applied) - Number formatted Line Item 2: Absolute (No TimeScale, No Versions Applied) = Absolute value of Line item Amount Change the Formula Scope of the Line item Absolute from "All Versions" to "Actual Version" or "Current…
-
Migration to new SKU code
Hi All, One of my client is under IT systems restructuring and migrating to new ERP system. Because of that the SKU codes for ~6000 SKUs will change to 18 digit in a couple of month. In Anaplan we currently have old codes for SKU and there is another numbered list of SKU-Customer combination code of around ~100000. What is…
-
Upload - Non Mapped Source Items Identification
Hi team, Is there a way to identify Source Items in a list that have not been mapped to an item in the target for a Upload to a module in Grid Mode? I am aware you can manually identify the non-mapped items by scanning the Mapping tab but this seems inefficient and error prone (especially with large data sets). When you…
-
Cumulate Issue
Hi All, I just need a little opinion whether excel is wrong or Anaplan. See below. So i only copied the values so there is no formula. Excel Driver Cumulate formula it adds the Excel Source value and Excel Source Plus value. So its like Sum(Value, PLus Value). The problem that I have is in Excel Driver when they cumulate…
-
Input into different hierarchy level and display balances in one module with Hierarchy and COA dim
Hi, I've been digging around all the resources but could not find any solution to my problem. We are trying to build a legal hierarchy tree (ragged) with inputs into each entity in varying levels and then presenting those inputs in one module with 3 dimensions: legal entity hierarchy tree, chart of accounts, and months.…
-
What's the difference between a model and an algorithm?
What's the difference between a model and an algorithm?
-
Find the minimum contract quantity falling within a contract range
Hi, Hope you all are having a good day so far. I would like to identify the least contract quantity falling within a price list range. if 10 contract quantities fall within a price range then I would like to choose the least from it. The catch is that the contract quantity is a calculated value and it is calculated for all…
-
Weighted Average by variable number of weeks
@rob_marshall I am looking for some guidance on how to do weighted averages based on a selected amount of weeks? Our call center planning is in need of looking at weighted averages based on a variable amount of weeks For example, a user selects the number of weeks they want to average the results by and based on that…
-
Switchover
Hi All, Is there a way to disable switch over in blueprint view for a line item without a time dimension? Thanks N
-
Ability to copy a List
There are occasions when I need to have a list that is similar in structure or content but serves a different purpose in the application or where I need to have different children but similar parents in the same module. In this case my only options are to export the data, create a new list and add the properties and…
-
How to calculate % of one row over another row?
Hi guys, I am trying to do the calculation of % of Show Specific / Total Universe and it's not giving me correct %. In the image below, the correct % should be 5401 / 21682 = 25%, but it's showing 4800%. Can someone please advise what I did wrong? Thanks, Jim
-
Sum based on specific value from another column?
Hi All, For line 3 in my module, I am trying to sum ONLY the lines where Total Inventory = Regular (Dimension), how should I setup this equation?
-
Update/add
HI, users should add/update the changes in the module.This should reflect in the Target modules while they submit. Like if already there is employee assigned to company and again if we wanted to update the details of employee how do we do that?
-
Displaying Line items by user or role
Hi, I have an issue I'm trying to solve. I have a module that multiple users have access to. I don't want all the users to see all the line items. I need to hide 2-3 line items for certain users or roles. Another module without those line items is not an option. Is there a way to this? Thank you Ronit
-
Circular Reference Issue
Hi Guys, I need help in figuring out a workaround for Circular Reference. I recreated the modules the best I can and I hope its enough to understand. See below: This is the driver module and this is already working fine in Anaplan. Lets say Row 1 and Row 2 and then Time Dimension. This is the countif module, this also…
-
Import for Weekly Data
I am trying to import Historical Weekly Data, but am constantly getting error. Please assist how to import Weekly Data? I tried several times, I have attached Screenshot.
-
Importing data from another Anaplan model using a filter in the destination model
I have a client who would like to use an existing view in the data hub as an import, but doesn't want to bring all of the data over from that view. Is there a way they can have a filter in their model so that when the data is imported from the data hub, they don't have to do any additional processing to remove the extra…
-
Cross Referencing Between Lists - Dimension of mapping used for aggregation doesn't match any dimens
Hi All, I'm taking our demand planners monthly forecast and converting it into daily then rolling it up into weekly buckets. I've successfully gotten us down to daily, using a fake timescale, added the week commencing date and I'm trying to do a SUM function with each day that matches the weekly period being added up. The…
-
Override function to SUM function
Problem Statement: We develop a table setting out the results of transactions per code type across multiple categories (AP, AR, GL. etc). The results are calculated from detailed transactions . The customer process dictates that the amounts determined should allow for overrides to assign the amounts (all or a portion) to…
-
Property in List using a formula
I have a unique key list which is a standard naming convention of 12345_123456_123456. I would like to use a formula to identify the last 6 digits that are not 000000 or 0000002 and create a list subset of those. Can you help me figure out the formula for that? Thanks!!
-
auto populate other fields
First and Last Name should be a list Email - must be users email ID is a list if the User provide value in one of the above and others fields should be auto populated.
-
Prompt for Import Data Source name and Import Action name
Something that would considerably help with building cleaner models would be if users could enter names for import data sources and import actions during the import dialogue. This would prompt model builders to assign a considered name, and substantially help to identify import data sources and import actions after the…
-
Level 1 Model Building
Hi, In Level 1 Model Building, we are asked to create an Employee System Module, with Start and Leave Date with Date format But in the Excel provided, the format is And During import, it says Invalid Date. Could you please help to know how to fix this. Should I change the format to date in excel and then import or import…
-
Re: How to Group Total sold from 4-4-5 to calendar month if data is weekly commencing monday?
@JaredDolich Your solution worked great and it's exactly what I'm looking for. I would like to ask a follow up question on the topic in the link below: https://community.anaplan.com/t5/Anaplan-Platform-Discussions/How-to-Group-Total-sold-from-4-4-5-to-calendar-month-if-data-is/m-p/59830# One question I have is that when I…
-
circular reference error with no time dimension used.
Hi All, I have a module without time dimension,I am facing circular reference error here: Line items used are: Total = Sum (Lineitem1 + Lineitem2 +Lineitem3) I need previous cell value of Lineitem Total for LineItem1 ie, Lineitem1 = previous(Total) As I am not using time dimension, I cant use PREVIOUS function here.…
-
How to count booleans?
Hi - I am trying to create a graph where it displays the number of items selected by the user. These items are marked through booleans. Is there a way where I can count how many items are selected per category using the booleans? Thanks!
-
Using Model Role to filter
I would like to filter a module which uses a list of users (either actual User list or a regular list which is a copy) by the Model Role each user has been assigned. Cannot seem to figure out how to import the model role into a module. Ideas?
-
How to freeze a verson from change in master data
Hello, I would like to have a "budget version" free from any change; formulas, list, metadata. Is it possible to do it with Anaplan? Is there a way within Anaplan to freeze a version i.e stop it from being rules calculated, whilst retaining the data? And can you help me with this? Best regards, Gaëtan
-
Sum of amount based on numbered list.
I have a numbered list, which has the same names (display names). These same name line items then have different child. The values of the same name list items needs to be added up to only one list item which has the latest PO date in the same list. For Example- This is the source module that has the same parent names with…