-
Network traversal algorithm using Anaplan
Has anyone implemented a network traversal algorithm in Anaplan? To explain the problem, refer to screenshot below. What I want is to generate a path that goes through all the nodes, e.g. Node 1 to Node 3 then to Node 4 then to Node 2 that returns the path with the lowest weighting. So Node 1 to Node 3 is 7 (as per…
-
Add Product Names (without codes) to a Numbered Product List via UX Page
Hi All, I'm a bit stuck and needed help here. I have a numbered list of products and user now want to add a subset of products under this list, specifically to a new subset called "Subset - X," which doesn't have codes. The users would like to create new products in "Subset - X" via the UX page and as model builders we…
-
How to copy data from one line item to another line item in one module?
Hi, I want to create an action to copy data from original value 2 to planned value?
-
What are the scenarios in which the ALM sync between Standard and Deployed mode will break
-
Anaplan History Description Definition
Hi, Is there a definition of all "Description" in the Anaplan history extract? Like "Change Line Item" - what are the activities related to this description? Thanks, Tom
-
Custom date log / History Log
Anaplanners, Currently, our user group updates a checkpoint where they record completed tasks, such as onboarding tasks, by entering the completion date in a date-formatted line item. We have developed a custom-built grid that displays changes in a funnel chart format, showing the latest update for each project, with the…
-
Importing a list from Hub into Spoke Model
Hi Experts, I have an import set for a list from data hub to my spoke model. My concern - the list items in the list on Data hub keeps changing based on the updates made in the upstream system. As an example say in Nov - I had the id ABCD1 as a list member in Data Hub and also in Spoke model when data was pulled. Now in…
-
Leading zeroes in anaplan
I want to fix the length by appending zeroes :- Consider below example where i am having 3 Prod ID :- 1234 1234567 123 Below is the result i am expecting:- 0000001234 0001234567 0000000123 Generally we call this left/right padding or leading zeroes.
-
DAT01 Beginning Inventory data issue
Hi, I am currently working on 3.3.5.2 Inventory Ordering Module Formulas and just realized that my 'DAT01 Beginning Inventory' is showing funny numbers. I can see the number 845,329 is the total value of beginning inventory. I tried to find out the cause in the community but I could not find the answer. Can anyone help to…
-
コード、テキストを並べて表示する
下記のようなグリッドを作りたいです。コード対応するテキストを表示したいのです。 どのようなリスト構成？にすればいいでしょうか。いま、”111_choco"みたいなものを作っていて、美しくないのです。
-
Efficiency of the lookup formula
I have some question about how efficient the lookup formula is I have a situation where we when we have new items have the ability to give that item a mapping to another item to pull some initial data for since we don't have anything for it yet. we used a lookup instead of just repopulating the initial data so the users…
-
How to get MAX value from line item to another line item in the same module?
Hello, I have a module (image below), how can I create a line item where all items will be max value from 'New Store Num' where 'To many Stores?' is True . For Example in image below it will be 8.
-
Cumulate calculation but skip 1st item
Do you have any ideas to calculate this; what I need? If I make a line item called "for lookup" and use LOOKUP formula, I can do this. However I need to fill in "for lookup" manually. I simplify the case here and "Figure" should be calculated using "What I need", so I cannot use "Figure" since it becomes circulation…
-
How to Resolve “Automatic Sum of Hierarchy Not Possible” Error Without a Top-Level Item?
Hi Anaplan Community, I’m encountering an error in my model: “Automatic sum over Over/Under hierarchy is not possible because the list does not have a built-in top level.” I understand that one solution is to set up a top-level item in the list. However, I prefer not to use a top-level item. I’ve read that using a LOOKUP…
-
get inventory per country per sku
I have an Invenotry ordering module where i have beginnening inventory, i want to get the inventory in a new moudule by country and by country and sku both i have a sku details module which has country made in as lst item and sku as a dimension i tried using this formula but got no data 'INV01 Inventory Ordering'.Beginning…
-
Level 1 Lesson 7.2.3 - Why is Department grayed out?
There is no way for me to map Dept Code to Department as Department in the Target Items is grayed out. Anybody knows why this is the case?
-
Instructions on how to develop a Model Schema
Hi there, Can someone please provide step by step instructions on how to develop a Model Schema per project (DISCO base). Thanks in advance, Siva.
-
Getting the total from another Module
Hi everyone i have a module [Employee Details] where i can filter the team center. for the below sample, i chose the Financial System which has 2 employees. whenever i choose Team Center, the amount will be selected in [Sum Selected] column. in my Testing 1 module, the only Total would reflect must be Financial System. but…
-
Formula change in Opening and Closing line items.
Hi Team, I needed small help to optimize the formula from Half-Year to Full-year. Current working System: If Jan 2021 (Budget) H1 Opening HC we were referring to Closing HC of Dec 2020(Actual) and IF July 2021(H2) we were referring to Jun 2021(Actual) Proposed System: If Jan 2021 (Budget) H1 Opening HC we were referring to…
-
Find common text between another modules without List
Hi, I want to find common text between another modules. I have two modules A&B. Each module has order Number and Product(Text format) I want to find Product(ModuleB) in ModuleA. It's Common Text. In this case, we can find product by finditem formula, by making product List. But I don't want to use product List, because it…
-
How to tackle duplication import into numbered list with list formatted properties ?
When importing into the list having properties as list formatted it create new list item with every import even if unique identifier already exists While importing transactional data into a List (Numbered List) which has properties Country formatted as Country, Year formatted as Year and Amount formatted as Number. In…
-
Displaying Line Item Based on Date Range
i have a module where i have line items such as client number, agent name, start date, end date and months between end and start date now i have another module where i am using client number as an dimension also time(months) and agent as line item now i want to display the agent name from the first module to this module…
-
Issue with Ascii characters in Anaplan
I’ve encountered an issue while importing data into Anaplan where certain special characters, specifically ASCII characters like ü, ä did not show properly, it showed as question mark Instead of importing these characters correctly, the data gets corrupted or replaced with incorrect symbols. As shown below, Although it was…
-
1.4.5.2 Import from Saved View
Can anyone help me with the mapping of this?
-
How to shift an item in line items
Hey, is it possible to get a value from column 1 to column 2, from column 2 to column 3 etc for Base Revenue. I would like to calculate base revenue for columns 2,3,4 etc. based on 1 column, but I don't know how to get the value from the previous column. The target formula would look like this: IF VALUE(NAME(ITEM('Number…
-
Format of mapping used for lookup doesn't match any dimension of the source
Hello, I can't understand why I keep getting this error. I am trying to bring in Keeper 1 from the source module that is dimensioned by player, but the line item is an "owner" list line item. My target module is dimensioned by Owner with the line item as a "Player" list line item. See Screen shots below, what am I…
-
Can we add numbers of list item in a numbered list by taking input from user?
For Example: If user entered 10 then 10 list item should get created in the particular list.
-
Concatenation in module failing
Currently looking to concatenate a number of fields on an existing module, which seems to work for some of the fields, however not for all. In the example below it is the Ent Code that doesn't seem to work - I've included the design view as well for reference
-
カテゴリー別合計が上手く出ない
作成したいのは赤枠モジュールです。 指定期間の数量Aの合計をカテゴリー別で出したいのですが上手く出ません。 お力添えいただければと思います。
-
Multiple Model Dashboard
Hello! I am trying to create a Dashboard which has 3 different data source MODELS. I am creating the grid view as per different models, e.g. 1,2,3. Though each has its own MODEL data as per filter, when filter is set to first model 1,3 shows the same model data while 2 shows blank(as it should). How to make 3 work the same…