Importing and Exporting Data

2.3.10 Activity: Create Demand Forecast_unable to see FY21 data
Hi, As per process I have created DEM03 Demand Forecast Module. It shows FY20 data but FY21 data is missing in the data. Could anyone please assist me If I am wrong anywhere. Please refer below screenshots. required output- I got below output -
Volumes for DATA02 SKU
Hi team, I have mapped the data SKU.csv as per below screenshot. And under DATA02 sku line items mapped volumes However, only Jan 2019 and Jan 2020 data is visible in the sheet attached jpg, Please guide me with steps to rectify so that volumes are visible under each month.
Turn off export functionality from cards in NUX
Hi, Is there a possibility to turn off the export functionality in the NUX, like there was in the classic dashboard? It is crucial for my use case that the end user cannot export the grids from the cards to excel for example. Thanks!
Optimizer: process incl. optimizer action with import on timeout should continue in case of timeout
For optimizer actions, there is the possibility in the action setup to enable "Import on timeout" to fetch back the results from Gurobi processing when the specified timeout is reached but the desired MIPGap is not achieved yet. If the optimizer action is embedded within a process, the process is shown as failed when this…
level2 - Create Inventory Ordering Saved View and Export- export setting
I am trying to do this activity: This is my export view: I used Tabular multiple column export, and got this result: which is differ from expected one: Which export setting needs? Regards Roya
Importing data but get different results
Hello community, I'm getting an issue while importing data with a csv, below i've attached data i'm trying to import but suddenly i get this kind of results which does not correspond to the data i supposed to get instead of getting 58.88 in anaplan ,i'm getting 5,887728739E9 even if i have set the format to 2 decimals.…
7.2.3 Activity: Import Data into Employee Details Module
Hi everyone, I'm a newbie to Anaplan. I have checked and tried every suggestion in this forum regarding this problem. Kindly help me out. Attached are the screenshots of everything I have done. Any suggestion would be appreciated. Currently stuck. Thanks
Run Process 9 Import Data from the Hub
Hi Team, While I'm Running the process I'm getting error. Please help me to run the process sucessfuly.
8.5.2 Activity: Import Data into Price Book Module issue?
Hi everybody. I import the Pricebook.csv file to REV01 Price Book module. Everything seems in order until the importing process is completed. As you see on the screenshots after importing the file the prices don't represent the correct value as in the .csv file. Where have I done wrong?
7.2.1 Activity: Import Data into Product Details Module - Invalid line item identifier
Hi, For L1 Model Building activity 7.2.1, I am having some issues importing the data file for SYS06 Product Details module. I am getting the following error "Invalid line item identifier" when importing the file Below my mapping selection Doe Does anybody know what the issue might be? Thank you
L1MB - 7.2.1 Activity
It seems that there is "Product" data but I cannot see data in Column SIZE. It is not allowing me to import it again. Any suggestions?
Ability to auto-name PDF based on context when exporting from Management Reporting
When exporting a PDF - the name is always the name of the page as it appears in the app. It would be good if you could configure this so that it recognises the context of what you were exporting, but could supplement this with text. E.g. if you were exporting a board pack, you could select the context of "Europe" and…
2.3.9.1 Import data P3 SKU
I am having a hard time importing the data from the DAT03 Historic Volumes module, Export saved view. Everything else seems to be mapped correctly, but the P3 SKU is not. Do I need to change the target item to display the SKU? Thank you!
Level 3 Sprint 2 Employee Details into G3 Sales Reps
Hey Team, I have encountered some issue(s) with importing the datahub saved view employee details module into the G3 Sales Rep list in the Sales planning model. After a completing the import, the results (per the attachment) are not the employee names but numbers. Could you advise on how best to quell this issue and…
L3 sprint 2 assign accounts to more than one territory
Hello, I am confused as to how it is possible to assign accounts to more than one territory. When we need to import into a numbered list, we need to uniquely identify each entry. I use the account code. As such, every time I change the territory assignment, the import function will automatically override it. What am I…
Export View with 4 dimensions to the left side and time in the columns
Is there a way to export with 4 dimensions on the left side and time (months) in the columns? I created a saved view and used tabular multiple column export (filtering the specific months with a boolean in a separate module). However if I put the line item and time in columns it errors stating line items must be in columns.
Cloudworks succeeds but doesn't actually run
Hi all, I've noticed for a CloudWorks process I have that the actual integration says "success", but when I check the model, the last run time of the process was not updated, nor was any new data added to the model. This is an integration from BigQuery that worked previously, and is now not actually pulling new data. Has…
1.7.3.1 Import into P3 SKU list
I am having trouble importing the data from the Build SKU saved view. When selecting my sources for the data, I don't have many options to link the properties to the sources. Is there something I am missing?
Options to improve performance when loading flat list used in reporting
Hello, I'm loading flat data between 2 Anaplan models and in the target model, I'm using the Sum function to dimensionalize the flat data into a reporting module. The reporting module needs to have 5 lists + time and also requires summary to be on so data can be reviewed at aggregate levels. As a result the import action…
Trigger mail to end user
Hi All, Greetings! I have a request from one of the user if I can trigger an export of dashboard to email ID at a particular time slot. I am assuming this can be achieved through integration only. But I would be glad to know if there are other ways to achieve it. Thank you, Harshitha N.
Tableau to Anaplan Integration
Hi Everyone, I was doing POC for Integration between Tableau and Anaplan, where we export the data from Tableau as a file(.csv) and load the file into Anaplan. Thought of sharing my approach here. Below are the prerequisites we would need to proceed further. Download the latest Tableau Desktop from the Tableau Website and…
Scenario Planning
Hi Team, I have an unique issue which requries a uinque.. Lets say I have a List called - "Scenarios" -Scenario1 -Scenario2 -Scenario3 Using the list in a module called "Data Scenario" I want to copy data of Net Sales from Scenario 1 to Scenario 3, I know I can use the import action, however in that case, I will have to…
Automatic import of failure dump
I have an action that imports data from excel into Anaplan. When the data fails to load, it is due to a missing list item (a project). When the items fail, I would like to extract the failure dump, and import those projects into another table, which heads off an import action that brings these missing projects into the…
Manual Input for Recipients of Notifications - CW
At the time of writing of this post, it's only possible to choose from a limited list of recipients who receive the Notifications of CloudWorks integrations. However, it would be very convienent to be able to manually input email adresses of the recipients. This would allow to send the notifications directly to Team…
Time treated as common list on Import Action
Hi, I am loading a CSV into a module that has simple time list at month level – however the import action is treating TIME as a common list rather than allowing to do the specific time mappings as expected. Im sending below the details with all the screeenshots I believe are necessary to help understanding the issue. Here…
Export/Import Time Periods
Hi team, I have a situation whereby users have the option to export the data from a module, adjust the relevant cells & then import the same CSV file to the module. There is an issue with 2 line items that have Time Period as the format. When they are exported the format in the CSV is 'MMM-YY' rather than 'MMM YY' & if you…
Activity 11.3.2 Import data into P&L Actual & Budget
Hi Community Members, I have been trying to import data into the DATA01 P&L Actual & Budget Module but getting an error. Same error for activity 8.5.3 (Invalid format YYYYMM) I have also checked the Example and follow the same but no success. Please see my mapping screenshots, errors and suggest me the best solution.
"invalid name: ....." error
Hi community. When trying to import into a list I receive the error "invalid name". Do you know where I can find the explanation of this error? Thank you.
2.3.8.2 Import into DEM01 Module
Hello All I m stuck in this activity, can you tell me if my mapping is correct ? I think that the probleme is with the time mapping, i actually change the time scale to month bu stell have this error: Help me please , Thank you
Why am i getting this when trying to import to a ticked production data (numbered) list?
"Deployed Mode is enabled for this model. You do not have permission to change structural data." it is ticked production data and i am just importing data to it, only 2 fields. I am the builder and have FULL access to everything I am not changing structure i am importing data

Importing and Exporting Data

Discussion List