Modeling

Returning Dimension/List Item based on Line Item
Hi, I'm trying to understand whether I can return a Dimension/List item when referencing a Line item rather than the Line Item result itself I have 2 modules. 1st module is dimensionalised by FX Rates (columns) & Regions (List Formatted Line Item) The 2nd module has a Line Item which is List Formatted with FX rates &…
Formula
Hi-Experts, I Have a requirement for that I need your help. Module name: Summery module Dimension in the module - Time, Category, Product, customer I wanna move to all products(except fruits) sales data to one customer(AR Channel). Fruits data move to another channel(FR Channel). IF ITEM(Customer) = Customer.AR Channel…
Sharing Lists Between Models
Is there a way to share lists between models? We use a number of different models all for the same company which uses the same structure - and it would be really handy if it were possible create a 'shared' master list(s) in one model that could be referenced by all the other models.
Get Value of Top Level
I have three lists: Product Lines L1, Product Category L2, Products L3. Total Products is the top level of Product Lines L1. I'm trying to calculate the product mix of each product in Products L3 as a percentage of Total Products. The module.line item that has the volume is Sales.Units Sold. But my question isn't about the…
File Load to List via process
Hi, I have loaded few Lists hierarchy from a file .txt and list was updated. used a process and included these actions, but when I run the process system is not allowing me to browse and choose the source file. So, If my source file data changes ,this process execution will not help me as it picks the old file everytime?…
Can I select a Parent within the same list and also another list?
I want to be able to select the parent from the same list and also another list, is there a way to do this? I am creating a Chart of Account, so there are certain account in the same list that I want to group it under. Example. 1000 -- General Stuff 1001 -- General admin stuff 1002 -- General Sales stuff In this situation,…
Loading parent/child DRM file to Anaplan
Hi All, I have a source file with Parent/Child and node Levels, total 7 levels max. I want it to Load it to Anaplan list(7 different list) at different list levels. we are creating 7 different load files to load at different levels in the list, is there any other way to eliminate the 7 load(1 process) and do this in one…
Insert text into summaries
Hi, I've got a simple list (with codes) with summaries at different levels. I've got a module that applies this list I've got XL file where I have codes(from the list above) and text (1 to 1) How do I insert text from the file into the module into the summaries in my list? Thanks
Revenue and Expense eliminations in reports
I am creating a Income Statement where I would like to see a column for eliminating intercompany activity. Has anyone built a report or module that handles eliminating accounts?
How to reduce the dropdown list of a column
I have graders name as a column in a module. The column datatype is a list (graders name) I want to reduce the dropdown from that column to only active graders ---- I tried creating a subset of the list (graders name) and then using that list as a datatype in the column but that erases all the data related to previous…
filtering
Hi, Please see details on the attachment. Regards,
Edition Compatibility between SQL Server 2012 “Evaluation” Edition and “Enterprise” Edition
Hi all, I'm Newbie to SQL Server 2012, I found out that there are paid and free editions of SQL Server 2012 available . those are 1.Enterprise [paid] Tableau 10.4 B.I [paid ] 3. Standard [paid] 4. WEB [paid] 5. Express [free] 6. Evaluation [free] 7. Developer [free,paid] Now I have ambiguity between paid version and…
Incremental Load
Hi, How incremental load works from data source to data hub ?
Ability to view a module side-by-side with it's Blueprint mode
When model building I find myself regularly want to see a module AND it's blueprint mode simultaneously so I can scan formulas, change things in blueprint, and immediately see the effects without having to toggle back and forth. This would be like using split screen in Excel to compare two workbooks side-by-side Toggling…
Format checker
I want Anaplan to check if the FORMAT of my line item correspond the the formula i'm entering BEFORE starting the calculation and if the format doesn't match the expected result, i want Anaplan to hold the calculation until i can change the format to match the formula results.
Delta Load
Hi, How incremental load works from any data source(other than anaplan) to data hub in anaplan?
Copy/Import Line Item Formats
To provide self-service modeling we need to allow users to not only add new line items to a module but also to change/update the formats. It would be nice to be able to import line item formats as well. Line items can be imported but then only a model builder can change/set the format. For example: I want to give my users…
Sum by Account starting with specific number
Hi, I have a List with accounts starting from 4* ,5* and 6*. These accounts have some data value against them,I want to Sum up the data value by 4* ,5* and 6*. Regards Madhu
Unicode References
HI Folks, Can we use Unicode Characters in Anaplan? As of my knowledge, we shouldn't use as it might reduce the performance of the model. Is that true? (I have access to One APP which itself built by Anaplan and I can see Unicode characters over there) If we can use it, can someone give or suggest the source where to get…
Pricing of Products with semi finished goods
Hi, How pricing of products for one plant can be used as semi finished goods for other plant with updated cost of product as raw material cost for the next plant. Please provide with the solution for designing the same. Thanks Pujitha
FINDITEM formula
Hi Can we use time rang for finding time period while using finditem function. Thanks & Regards Keerthi
Update Codes in a numbered list
Hi, I've set up a numbered list with an name property. The formula comes from a module - it should update the numbered list as well - any idea what I'm missing. Thanks.
Import from module with greater dimensionality
Hi, I'm attempting to import data from a module in another Model (monthly employment costs per employee) which has greater dimensionality than my current module (The source has a Currency List & also Versions which the current Model does not have) Is there a way to SELECT a Currency List & Version item to import or do you…
Anaplan history not updated correctly
Hi Experts, We are using the Anaplan model from the last 3months. Now, when I check the history I am not able to see any history of the model. Is there any setting for showing history in Anaplan ?? Please help me with this. Regards, Uma
Import data to a module - have code info in file but List has code description
Hi, I want to import data into module which has Account list, where Account list has code-description format Example '1000004 - ABC' My Source file has account code only with balance. i,e Account Balance 1000004 200$ while importing source file unable to map account code with account full name in list. Note: This is not a…
How do I sum across dimensions other than time?
Hello Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. 0x80070490 Beyond allocation use, is there a way to introduce a line item that returns the value at the next…
Fiscal Calendar Lookup
I am trying to lookup (using the lookup formula) the fiscal year, fiscal quarter, fiscal period and fiscal week using the date an item was sold. We have a calendar module that contains all of the conversions (date, FYear, FQuarter, FPeriod, and FWeek). Sales are tracked using Fiscal Week End Date so my formula for fiscal…
Extend Date format to include Time (hh-mm-ss)
Description: Being an Anaplan Builder, I would like to be able to have a date format with Time in it (hh-mm-hh) Some of our planning tasks are connected with work with exact timing (Date + Time). Currently, we have to upload this data as text and use RIGHT(),MID(),LEFT() functions to extract values. If we have a customized…
Month to Date Formula
Hello, I'm trying to use month to date formula. It doesn't look like it's working correctly. cumulative amount should never decrease if i'm adding values month on month. Thanks
Is it possible to override a formula in a line item? If not, how can I enter a starting amount?
I want to be able to enter a starting amount and from there on have a formula driven on the line item. Example. Beginning ARR manual enter amount in Apr, then it will drive the calculation to get the ending ARR. The beginning ARR will equal to previous months Ending ARR. I included several screenshot. The excel file…

Modeling

Discussion List