-
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…
-
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…
-
is there a way to show/hide line item based on a selection by the user
i tried using line item subset but did not know how to procced next
-
Enable Completion Task DCA on Workflow
Hi, I'm building Workflows and am using Decision Tasks as they are most efficient for my Business needs. I don't seem to be able to identify anywhere to set 'Enable Completion Task' DCA's on my actions in these specific types of task. Is there something that I'm missing? Sean
-
Level 3 - 5.5 Model Build Specifications
While Building Import process from the Data hub, I an getting confused should I import Sales Reps Flat# or G3S Sales Rep# in first Action of Build Sales Rep ? 5.5.2 Sales Planning Model - Import Processes Next, create import processes in the Sales Planning model to: Build Sales Reps Build Sales Rep Details Build Sales Role
-
what are the challenges while building a model in FPNA
-
How to Disable a Parent Filter When a Child Filter is Selected, and Vice Versa?
Hello Anaplanners, I'm working on a filter setup where Category is the parent of Task in a hierarchy. I need help implementing the following logic: The Category Filters should be disabled when any of the Task Filters are selected. The Task Filters should be available when none of the Category Filters are selected. If a…
-
3.3.5.2 Inventory Ordering Module Formulas
I'm really confused as to why my figures won't populate when I toggle from blueprint view . Here are my formulas. Someone please help.
-
Why are there items appearing in the source mapping of an action that are not present in the LIS
Why are there items appearing in the source mapping of an already existing import action that are not present in the Line Item Subset? I have updated the LIS and still in source mapping I can see items which are not present in the LIS.