Data Integration

Mapping Datahub and Spoken Model
Hello, I have two questions regarding Datahub and Spoken Models interaction: 1. How Spoken model can find the link to Datahub after an ALM if we have a dev and production version of Datahub? For exemple, we have 4 models: Spoken Model DEV, Spoken Model Prod, Datahub Model DEV and Datahub Model Prod. The inter model actions…
NUX: Import File Selection Type as CSV by Default in Instruction
Hi While importing from NUX, by default it asks the file type to be CSV, but the file I am using may .txt file or other. Although it has no impact on data/action, it may confuse user while running the action. Is there any fix for this? Rahul
Decimal Places for a Number Formatted Line Item
What is the maximum number of decimal places for a number formatted line item? Is there a way to check which cell for a given line item has the most decimal places? Need to know for an export into a datalake / warehouse for storage
Blueprint view - Modules
Hello, I have some modules with views that are connected to interface dashboards.. I accidently saved one in "blueprint" mode so now the dashboard doesn't show up and it seems that every time I go in to try and click out of the "blueprint" mode, the system just automatically takes me to the general view of the module not…
Power BI connection using basic authentication
What are the steps involved to establish a connection from anaplan to Power BI using basic authentication?
Configuration of Anaplan Connection with authentication using an Anaplan issued certificate
How do we donwload anaplan issued certificates for using in anaplan hyperconnect to establish an anaplan connection?
L1 model building certification Completed
Hi, After completing L1 can we get job opportunity in same field Because I m not able to get any till date. So thinking should I continue for L2 is it really worth it to do.
Warning when attempting to change a saved view used by an action
No small amount of problems have been caused in our model by someone unknowingly altering a saved view that is used by an import action. It seems reasonable to me to tell the builder who is about to delete, or overwrite a saved view that is used by an action so they can make a decision to proceed or not. Ideally, it would…
Anaplan Connect - Proxy setting in Import Script .
Dear Expert , As suggested in Anaplan Connect to Whitelist api.anaplan.com and auth.anaplan.com . But due to security policy client is not willing to do the same . Is their any ways in Script where I can use different URL prvided by my Security team to use as below for Example... Can we use a different url…
Search in Select source
Please add the option to search from "select and existing source" while defining and import. Currently, we need to scroll up and down and it is tedious if the list is big.
Upload csv file through Hyperconnect
How can we use Informatica's Cloud service to upload a flat file or csv file into an anaplan model. Is there a step by step walkthrough available regarding this? Should we upload the data into informatica cloud first or can we directly link the source and target?
Option to select Column Headers starting column(optional)
Hi All, I am seeing this error for a long time, so I thought of sharing this here, there might be a solution which I don't know. if there is a solution pls share it. Let's assume I have an import template as follow Column 1 - Display Name of the List Items Column 2 - Unique Code Column 3 to end - TIME(JAN 21, FEB 21,...)…
Excel Add-in Connection -Refresh workbook fail
Hi, I created a Multi-Sheet connection (5 tabs). After reopened the file, I found Excel Add-in cannot find the module used when I try to refresh all tabs with one click. Could you kindly tell me how to solve this issue? Thanks,
Mapping issues
Hi, I'm having trouble mapping this excel sheet. Attached is a snap shot of what I'm trying to map and also the excel sheet I'm trying to map. Please advice. Thank you
Pulling data from Source systems into Anaplan
Hi Team, I am searching for some information to connect Anaplan with different source systems. Is there any white-paper as such to know which will be the best way to connect different source systems to Anaplan for planning purposes? Also, if I may ask about IQVIA, Integrichain, SAP and other ERP sources? Does getting the…
Trying to load from file to module data
Hi Community, I'am developed following dashboard to our end user. My problem is that if I want to load local accounts from a file - all local account will goes ignored state. The module contains a numbered list. My primary key in the module is combination of company+local account number. My question is that how can I…
Excel add-in not showing extra year
I have used excel add-in to refresh to include the new year. However, there are still issues where, even though the saved views within the modules and the modules itself has an extra year, it does not show up within the excel. Please advise - certain tabs had an extra year eg. FY25 whereas some could not simply show up.…
Help With Level 1 Model Builder Section 7.2.3
Hi there, I was doing really well on Model Builder Level 1, but I have become stuck at Section 7.2.3. I have downloaded and saved the data file "Employees.csv" I went to module SYS08 Employee Details Went to Data -> Import and picked the saved CSV file Please can you assist with the Source Columns I should use? I picked…
Increase Size of the Action Icon for Additional Insight Cards with Actions
When working in a worksheet the user is able to add various cards (text, field etc.) to the additional insights pane and even add a process/action to these various cards. However, the Action icon in the top right of the card is extremely small compared to most large blue processes Anaplan offers in the UX. Can we increase…
Banner export practices are leaving orphan Budget Items in Anaplan
Ok, so this is a weird one for sure. The implementation team suggested that we exclude zero balances when exporting Budget data from FGBOPAL to keep the Anaplan model size as small as possible. We recently found that there are times that a value will get imported into Anaplan creating a balance for a Budget Account. If…
Power BI connector - Invalid Credential
Hello, I followed the process "Anaplan connector Power BI Desktop" in order to see an export file in power BI. It worked the first time, but every time i reopened the file in order to see the updated export in power bi, i can't connect to Power BI because of "Invalid Credential", and i can't connect to Anaplan either. Is…
Badges
Hi any idea how much time the Level 2 and certified model builder badges take to be added to the profile? It has been a couple of weeks since I completed those and got my certificates. Thanks!
Anaplan Extensions: Building Reports in PowerPoint to Present User Stories
Recently, I interviewed Jared Dolich, a Principal Consultant at Columbus Consulting, about his clever use of Anaplan Extensions as a consultant in an Anaplan implementation project. Q: Tell us about yourself and your Anaplan journey Well, first, Magali, thank you for your interest! It means a lot to me to have the…
Level 2 Sprint 3 - issue import shipping, DC from Data Hub
Hi, I need some help, please. I am digging a hole, chasing my tail, hitting my head against the wall, and drinking too much coffee…to no avail. Level 2 Sprint 3, lesson 3.3.5 Activity: Create Inventory Ordering – shipping method data SYS07 Distribution Center Details and SYS06 Locations Details have no data. It has their…
how to update flat file daily.
Hi, I would like to know how I would update my model daily with my Flat Files that I have. i have created the actions and placed them on a Dashboard, but need to know how I would update theses files daily and run the actions? Thank you
Taland and Anaplan - Integration
Hi Team, We are looking forward for a Data Integration between Taland and Anaplan, would like to seek advice if anyone has done this integration and any information that would be helpful before we start implementing the same. Regards, Shivankur
Let end user add multiple items to a list
Hello, The organizational list of my business in Anaplan need to be updated every week, because there is a lot of new client. One end-user need to have the possibility to add several items in the same time in this list. I created a form to let this user add item to the list but the user can only add one item , and this…
Script - Error while Executing Import Action.
Dear Expert , Seeking your kind guidance n below matter , I am trying to import File to my Anaplan Model but while doing show I am getting below shown error. I also crossed checked the Java Path which seems correct to me . Could you please assist me on this I would be highly thankful to you. Administrator: Command Prompt r…
Cloudworks Seetup Issue
My ability to login to AWS and reach bucket is validated and all is good on the AWS side Setting up the Cloudworks Connection seems to work and getting a valid connection. When an Integration is being setup, I can connect to model and see what I would like to export from Anaplan, but the Data Target remains greyed out and…
Import Mappings: "FY" added to line item name
Hi community, I have a source module with a year time scale. When I try to do an import from this module, Anaplan adds "FY21" before every line item. Why is this and how can I get rid of it? The "FY21" comes from the current month setting which means that when the year changes, this mapping breaks. I find this extremely…

Data Integration

Discussion List