Data Integration

Job after completing L1 in india
Is it worth to complete L2 also bcz completing L1 there is no job prospect.
SAP BW
How can we use Informatica to establish a connection from Anaplan to SAP BW server? Are there any links or tutorials for the same?
Level 2 Sprint 2 question 10
Hello, I have taken Level 2 Sprint 2 Exam today. I am getting incorrect answer error while submitting answer for question 10 which is Selecting best formula for DEMAND FORECAST MODULE, BASELINE FORECAST LINE ITEM. I choose the correct answer. The same formula I implemented in my module as well which is working fine. Other…
Leason 4.8.2 , Import data in E2 Employee
Importing and Exporting Data Hi team, Did the mapping as per my understanding making some error here, I am unable figure out the error getting numbers under the Sales and not the names of employees in sales team. Please guide me. @noelle_murphy I also tried the steps from…
looking for some volunteer project
Hi Everyone, Recently I did level1 and level 2 certification. Is there a way I can volunteer to some real project to gain some experience.
Modelbuilding 1 question 7.2.3 importing employees
Somehow I can't get the employees imported, in SYS08 Can anyone explain how to do it, I do not know what to use as mapping. I tried this: But it returns failures on start date, leave date and other columns Then I tried manual mapping, which partly worked but still it won't fill all the columns: Does anybody have an idea…
UX View the action in progress during a process
I would like to be able in the UX to see what action is in progress when I run a process like it is possible when we run the process directly in the model. Here is an example : This could be interesting with big process that take time to know exactly what action is currently processing and not only with the loading bar and…
Search Functionality for Import Data Source Selection
When setting up an import into a list or module, it would be useful to be able to search for a module/list/saved view when connecting to an Anaplan model on the "Select Source" section. I have a model with hundreds of modules and having to scroll through these modules every time I set up an import action can get tedious.…
Formula or Filter
Hello Everyone, I need here in getting solution for this issue, my question is. "change rule: when Forecast AND Actual equals 0, the deviation % should be 0% and not 100% as now" so where do we change the rule and how do we do it. welcome to hear solutions, Thank you.
Anaplan Live! Spotlight is back
Hi DACH Group, we hope you are all well and ready for a new year. There's an upcoming event targeted to model builders / data integration experts to learn what's new about APIs. Register now for Anaplan Live! Spotlight Join the Anaplan Community’s next Anaplan Live! Spotlight on Thursday, February 25 at 10 a.m. CST to hear…
Ability to use Line Number as the List Member when Importing from Excel/Google Sheets
There are times when we are importing data that Anaplan recognizes a row of data as a duplicate, but the duplicated data has meaning to our end users. Anaplan is able to tell us in the error message which line of data the duplicate was on. Is it possible to create an option to use the row number as the list member to avoid…
Extensions
Hello, I am the Product Manager for the 3rd-party add-ons (Excel add-in, PowerPoint add-in, Google Sheets add-on). If you have questions about these, feel free to ask them here. All ideas for improvements can go in the Idea Exchange and you can add the link to your idea here for extra visibility. I am looking forward to…
Import Data from Microsoft Azure into Anaplan using Informatica/Hyper Connect
How can we use Informatica Hyperconnect to import data from Microsoft Azure to Anaplan. Is there any direct solution or links to this?
Include non-time based line items in export of time-based modules
Hi, I have a module with the following dimensions: time, items and sites. And I have the following line items: Demand and code item at site (which is independent of time). I want to make the following export (where the line item "Demand" is filled in under each time period and the line item "Code Item at Site" is included…
Anaplan Connect API and Process to pull data between models
Model A has a process that imports data from Model B..both in same workspace. This process runs successfully if triggered manually in Model A I have succesfully run Processes that are currently importing Csv data on a daily basis. I cannot figure out how to trigger the intra-workspace import using the Anaplan Connect. Any…
Anaplan Connect - SFTP integration
Hi, Would like to ask if is there any sort of documentation we could look at in integrating from SFTP using Anaplan Connect? Thanks, Leah
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

Data Integration

Discussion List