Data Integration

Excel Add-in - New item in list and list reordering issue
Hello, I am facing an issue with the excel add-in, I am not sure how to solve it or if there are any workarounds. The context is, I am using an excel template with over 10 read-only connection for reporting purpose. In some instances, when refreshing "multiple connections", the refresh fails. After running a lot of…
Social Media Tags
I was hoping I could be able to enable or add a Social media link to my profile preferably Linkedin. I would love to know if you could work on that ,Anaplan Team.
AWS Data Lake (AWS Glue) Connection with Anaplan
Hey, Can someone suggest good DL connector, which pull the data from AWS data lake (AWS Glue) into the Anaplan without manual intervention. Thanks In Advance ! @jesse_wilson @rob_marshall @ben_speight
DATA02_LEVEL 1 model import issue
Hello Community, I am trying to import SKU.Volumes data into the DATA02 module However, I am facing issues while importing. Below is the step 1 STEP 2 STEP 3 STEP 4 STEP 5 FINAL OUTPUT Can someone please guide me? Thank you in advance
Import Lineitem with subset List
Hi, I want to import Lineitem with subset List. I have this below table. We are making production planning by weekly. Week has subset List, which is Lastest week. I want to import Production Planning only Latest week and its amount > 0. I tried to use filter, but it depends on particular week List. How can I import…
Ending Inventory
My formula for Ending Inventory = Beginning Inventory - Forecast Demand + Confirmed Purchase Order Receipt On the SKU level the ending inventory values are matching with the values shown in the activity picture, but when i change it to all products then the values are not matching up. Please help.
Import and Export Function Process
Hello, I am new to the anaplan software and would like to know the step by step process for adding a Export and Import button on a dashboard. Also I will need to add an Export filter so that I can select what department, version and Time I would like to see when the data is exported. Thank you.
CloudWorks Azure Integration - Connection Related API's
Similar to the API's available for AWS Connections in CloudWorks (refer below). The ability to do the same thing for Azure Blob Connections would be helpful. Specifically, updating of SAS tokens on connections. https://cloudworks.docs.apiary.io/#get_connections https://cloudworks.docs.apiary.io/#edit_connection
Cloudworks email notification to group email
Hi Anaplan team, We started using cloudworks for scheduling jobs within Anaplan. Sending automatic email whenever there are rejection , to the person who has created that job is a cool feature but I feel it would be great option if we have an option to enter specific email address. Examples email to include team email /…
Enhancements to API
Would like to see additional enhancements to the API, things like retrieving line item blueprints, list/module editing, list properties, etc. This would enable customers to control their Anaplan environments with various automations.
Custom return code for API / Anaplan Connect
It would be nice to be able sending custom return codes/messages to the API / Anaplan Connect. This will help us in be more proactively in case of errors. Think about a validation dashboard, which check data consistency. It could be that after a new data feed some functional data errors are flagged up at this dashboard…
12.4.1 Conditional Format
I feel like this is a easy fix but haven't found the right solution. it's not mirroring what the example should be looking like since the departments are in a different place. and since employees need to be under departments, im not sure where to go from here
Personal Export Settings
We've always used the standard Excel format as that was top of the list, now you've changed it to csv with the release 14/05/22; however, csv doesn't keep the formatting so we had formulas that failed in other Excel workbooks when we pasted the Anaplan export in. It's resolved by the user changing the export format to…
8.2.2 Activity: Add Volume Inputs Module
I am having a challenge creating the volume input module properly as the location is showing Region. How can I change from the Region format?
2.3.9 Activity: Historic Volumes to Baseline Forecast and 2.3.9.1
Hi - Super stuck on Activity 2.3.9 and 2.3.9.1 for the past 3 days. Any help would be much appreciated. Question 1 - for 2.3.9, what am I supposed to do here? The directions or lack thereeof are super unclear. 2. When I'm try to run Action 9, I get this error: "Import into DAT03 Historic Volumes module unsuccessful: Ensure…
Percentage format issue
Hello Anaplan Community, I am at the beginning of the training program and have encountered an issue with the percentage formatting while creating several modules in Anaplan. Let me explain : I am importing data from a csv file with bonus percentages by department. In my source file, the value of my bonus % is as a decimal…
Transfer the value from one time period to another time period
hey guys Please let me know is there any function for Transfer the value from one time period to another time period Without using offset,post,lag need to transfer the values directly
Power BI enhancements and upcoming improvements!
For all of you PowerBI users integrating via the connector, have you seen the latest enhancements - the big step being the increase from 1GB to 5GB for data export. Also...I know this has been a bugbear for some and it is scheduled to be resolved as of next month - no automatic 35 minute timeout on authentication! Changes…
Importing data Into Half Year Columns or cells
Hello, I have a module where I taken time ranges in weeks and Available Aggregation as Half-Year. Now I have a source file with the time range of Half Year (H1 FY20, H2 FY20) (Except half years, I don't have a data in weeks or months in my source file) . In my module my half year values are aggregation of months and weeks.…
2.3.9.1 Import data into DAT03 Historic Volumes module - DAT03 Historic Volumes'.Export" failing
Hello Community, Need your help I am not able to pull the data into the Supply Chain model from the Data Hub model. I get following error. I checked older posts, didn't find a solution for my problem. I have attached all related screenshots. Can someone take a look and advise. 9.1 Import Historic Volumes Model object…
2.3.9.1 Import data into DAT03 Historic Volumes module
I am unable to match my training screen with Anaplan document. and i received fail message for 9.2 Import opening stock. attached documents is the screen shots of my actions please support .
Converting a list to another list
Hi everyone, I recently discovered something within Anaplan that has made my life a lot easier when uploading data. For reference, I work at a mid-size firm and we have data that comes from our accounting software, and data that comes from our enterprise reporting software. Sometimes the naming conventions of things are…
export to S3 using cloudworks failing
I am trying to export data from anaplan to S3. I have set up the connection and it went fine. But the export fails with the message as follows: Your integration failed because of invalid connection. Check your integration setup and try again. Not sure what I am doing wrong here.
Code Generation on duplicate information entered by users.
Hey Folks, I am trying to generate code in the module in which user list is already applied, due to request from the team I want if the same information is entered by the user1 and use2 it should update the counter accordingly surpassing the users. for ex. if I have user 1 entered information as "abc" so the generated code…
Level 1 Activity 6 - No Medical Costs
Hi All, Desperately need help here! Why only the one field is not returning the results? EMP02 - Formula & Results In my REP04 File Results and Formula
New Formula Idea : Convert boolean into a number and stop IF BOOLEAN THEN X ELSE XX
Hello community, I have to do a lot of controls (boolean) and base and theses controls give me a value based on its true or not. I do a lot of these technicals line items for : -Controlling element -Color Coding -... I code it in 3 steps : * 1) Business Element (Number) : Uselly a business value * 2) Control (Boolean) :…
Importing and Exporting Data 1.4.3
Hi May I know how do I get rid of the "time"?
Will the Order list action works for End users?
Hi, Just want some clarity on the order list action in Anaplan. If I include order list action in any of the process which is being used by the end users will that action works for end users? I heard that the order list action only works for the admin. Can somebody clarify on the same Attached screenshot for reference.
Excel Add-In - Labels
Hi, When we export data from Anaplan we have the ability to add 'Labels' to the export. These cannot be added to the view as it would be too complex, but are pulled down for the Export, which is really useful. If we connect using the Excel Add-In can this be replicated. We connect to the view but i cannot see the option to…
1.3.4.2 Update SYS06 Country Details Module
Hi, I am unable to understand what's wrong in my selection. Please support

Data Integration

Discussion List