-
Importing Data at multiple level
Hi, I am trying to build a model which contains 7 different levels of product from the region, country, .., brand, to SKU level. The problem is whenever a user adds an SKU for a perticular city it is also automatically added to every other city and occupies a lot of space. How do I solve the space issue and give users…
-
Contracts missing after importing data
Hi all, hope you can help me. During my last data import to Anaplan, 2 contracts were not imported in. However during the import there's no error annoncement or log saying that these Anaplan has failed to import these 2 contracts. Only when users found out that their contracts are not visible on dashboard that I learnt…
-
Can't get my export right
Hi community members, I have created a saved view in which I enable a filter to filter out any rows which have a CIP value (kLOC) = 0. The filter uses a boolean line item in the module itself, which defines if the value is different than 0. When I look at my saved view, it looks good. However, when I export the view, the…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Hi, while running this import -Run Process 9 Import Data from the Hub, i am getting the following error. can anyone please let me know where i am going wrong?
-
load all data from Prod Env to Cert Env
Hello, The users have completed a forecast cycle in the production application. We have developed a new dashboard in the Dev application and moved it to the UAT application for user validation. To validate the dashboard, users want ALL data(actual,user-entered forecast, and data loaded from 3 other sources) to be Synced…
-
Level 1 lesson 4
Can someone tell me what the correct mapping is for this? Level 1 Model 4 Import data into P2 products list
-
How to upload a file using Anaplan APIs? [Anaplan]
0I wish to upload a file using Anaplan APIs but as mentioned in the API docs here is that Note: To upload a file using the API that file must exist in Anaplan. If the file has not been previously uploaded, you must upload it initially using the Anaplan user interface. You can then carry out subsequent uploads of that file…
-
Aggregating sales amount based on filter criteria
We have 3 modules where: 1. The Allocation module has Unique IDs(UID1), Time as a dimension and Attributes as Line items 2. The Sales Data has Unique IDs(UID2) as a dimension, Time, Attributes as Line items 3. Output Module which has UID1, UID2, Time as a dimension and Attributes as Line items We have to allocate the…
-
How can I change the hierarchy of list parent in module
Hi, I'm figuring if it is possible to change the hierarchy of list parent in module line item For example, I have the following list 'Test 2' with child 'A' with parent '1' and child 'B' & 'C' with parent '2', where the high level of list 'Test 2' is list 'Test 1' with two list item '1' & '2' I have put the following list…
-
Action Logs Not Capturing List Formatted Line Item Copy Across Changes
Hi Community, My query is more from a workflow management perspective. I will try to explain my case below : 1) I created 2 test modules both with same structure of dimension and list formatted line items. 2) The idea is that one module will act as a clearance module, i.e., will clear the line item values in the Target…
-
Experience with Cloudworks model to model integrations
Hi All I have noticed below with cloud works model to model integrations so far . Unsure if anyone else have noticed these as well * when setting up integrations page refresh is slow and hangs * when manually starting integrations i get message failed to start integrations randomly and after trying couple of time it works…
-
Data Import
In a dashboard, to update the forecast of particular FY, the user selects the FY and runs the process. But, instead of uploading file of selected FY, he uploaded another FY (say FY21 instead of FY22) file. When he ran the process, selected FY existing data wiped out in the target and no change in data of another FY. He…
-
Level 1 Model building Lesson 4 Lists
So I am playing catch up and I cant figure out the correct mapping for the list. I am on 4.6.5 Activity Import Data into G3 Location List. It doesn't outline the file mapping and sources like it did in the previous activity so Im just wondering what the correct data is for that. I import the list but then I get stuck on…
-
hide values in cell based on bolean check
hello guys, i have this module dimensionned by a list. The list is made from differents families and the row axis is made of many lines item and whenever an element is added by the user it insert itself on top of the its parent(family). so the parent is the total line of his elements, what i want to do is to be able to…
-
Missing data in forecast version of REP03 module
Please help. I am Missing data in the forecast version of the REP03 module and cannot figure this out. I feel like I've checked everything three times, and don't know why the data isn't populating.
-
Import data into the P3 SKU list.
Good Morning Everyone, I'm trying to import data into the list P3 SKU . I couldn't find the view Build SKU in SYS12 SKU Details module though i have already created the Build SKU saved view, tried to log out to let anaplan synchronize but it doesn't help , I cannot proceed further . Any suggestions are most welcome .
-
Email alert/notification if any error in log
HI Team, I am looking for a shell script which can send an email alert/notification if there is any error in Anaplan connection/logs. Regards, Tushar Bachhav
-
How to avoid garbled characters when importing
Hi, I want to import csv file which has Shift-JIS encoding which is Unique code in Japan. I have a problem the text has "(株)", "No.". <Data source> No. <Anaplan> �� I think this text is windows's environment-dependent character. So I changed the import setting from Shift-JIS to windows-31, and I could solve it. Does…
-
line item subset filter
hi! How do I show or hide different line items in a filter using line item subsets? To do this, we want to use the ITEM function to retrieve items from the line item subset list. What can I do to help?
-
7.2.1 Activity: Import Data into Product Details Module
Hello Please help, i spent already an hour and half to make a view needed in the task - i still have the wrong view. What I have The view needed Please help to solve!!! Thank you! Anton
-
import logic
Hi Anaplan Community, Below is the item I need help with this is regarding the clients extractor process. JFC will be sending 2 csv files for their extractor process. Below is the table with Months spread according to project name (this includes not in Budget – which is normally empty according to the user). Now the column…
-
Excel Add-in: Restore Connection after module rename
Hi all, Is there a way of restoring a connection to a module via Excel Add-in after the module has been renamed? the re-map functionality does not work either (model ID is the same) . My connection stopped synchronizing and the only change is the module name and I found below restriction on Best Practices for Excel Add-in.…
-
10.2.2 Errors
Hello, Can someone tell me why I am getting errors? What happened to my total? Thanks,
-
Add a item number when importing to modules
Hi, I want to import "order" file to modules. I have several modules which has Item number List as Applies To. module A & B. I want to import this type of csv file. This order files don't have order no. So I have to add Item numbers to first row. When I edit the csv files, some Lineitem( other) has 0 on the dead will…
-
Export API call returns only module headers
Hello all, I am trying to export out data from a module via an API call using an existing export action. Have successfully initiated the export action and retrieved the file details (chunk numbers etc), however when I attempt to download the first (and only) chunk details the API call only returns the module headers…
-
Workspace message error while importing a file
Hi, I have a little issue, In my development model i have created a process in order to import members of a hierarchy list regarding code, name and parent, in one step of the hierarchy for exemple let say that we have 4000 lines, in the lower level we have 40 000 each with parent, code and name, when i run this process…
-
import duplicate list item
how can i import duplicate data from excel to list : remember there is no parent or code with in excel i only want to import main channel please check screenshot THANKS in advance
-
API Anaplan Connect Export Action give no data
I can set a batch file that works and exports data, a small bit, but if I switch the action to a different one, it returns only headers. This is the exact file minus username:password and action name and path are removed. To be clear, the action run by hand exports a csv and the data is all there. If I run it via…
-
7.2.3 name and country error
Can someone help with these errors. I have tried several times to fix. I must overlooking something.
-
Associating a list to a hierarchy
Hi, I created a Cost Centers list with values (1, 2, 3, 4, etc.) and a hierarchy of Business Unit lists (Business Unit 1, Business Unit 2, Business Unit 3). I'm looking for a way to associate each group of cost centers from the Cost Centers list to the Business Unit hierarchy. The hierarchy Business Units 1-3 values…