-
Exporting summary calculations from Anaplan to Tableau
Hi I have an Anaplan model whose data I'd like to see in Tableau. A lot of the line items that I want to see are ratios, and in my Anaplan model they are recalculated at summary levels. e.g. * North: 25% * South: 15% * West: 30% * East: 45% * Total Company: 29% (not 115%!) I've read the documentation here and it advises…
-
Informatica Import from file via Process
Is it possible to run an Anaplan process from Informatica in one Informatica step with the standard data import process? Or do you have to call each action individually in Informatica and set up the sequential ordering (A then B) in Informatica? Process: Step A = Import into list from file (builds Anaplan code from UID)…
-
Anaplan integration with SAP
Can Anaplan consume REST based SAP Webservice?
-
Add-In Sign on
Hi Team, When attempting to sign on through SSO in the add-in, the window moves to the view of a web browser and I'm unable to sign on. May I have your feedback on this please? Thank you Matthias
-
Level 1 Model Building import data for Non employee model
Hi all, please help me in importing the data of non employee expense
-
Lesson 7 importing employees
please help me to correct the format exactly with anaplan screenshot given in leaning centers for example i need SHALA ENGLE in first column
-
Level 3 Sprint 1
Hey, Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file for now. Can anyone help me to identify if the mappings given in the image are correct? Unfortunately, I am getting the error "Invalid line item…
-
Unique ID longer than 60 chars
Hi, As per Anaplan's best practice in loading data, we are trying to create unique ID, however, since the original codes are very long, the unique IDs we are trying to create by concatenating the codes of the different dimensions are longer than 60 characters long. For example, we have Cost Center, Measure, FinGeo etc, and…
-
Confused as to why this import is not mapping automatically
I am trying to build a process where end users can upload values into an input module. Ideally they can export out the template from Anaplan and then update the values and then import the updated csv into the Module. However when I am trying to create the import action the automatic mapping for the field Sales Plan Region…
-
Commission % on employees details module
I have imported the data into the employees details module. everything is correct however the commission % is not showing correctly. The correct format is 0.15% and the imported format is showing as 15.00% what am i doing wrong? screenshot attached.
-
Import a csv file to a module where "Months" are line items
Hi, Anaplaners I am struggling with import data where one of its columns represents time "YYYYMM" to a module where Time dimension is "Year" and "Month"s are a line items. Would you take a look at the attached to see what I would like to achieve ? Such an import ever possible ? Thanks in advance.
-
Possibility for Data encryption during export
hi Community! Our business users would like to protect exports from anaplan with a password. So that, any time when they export a file with confidential information, it could not be accessed people without authorization. Do you have any idea how this can be done in anaplan or using other technologies in addition to…
-
issue loading data from views with page selectors
Hi, I am running into issues when I try to import data from views with page selectors - when I save a view that has selectors and then set up the import elsewhere, the view looks completely different, and can lead to unpredictable results. There are workaround available, but this seems like an problem. Thanks Ethan
-
Anaplan - Denodo
Does anyone know if Denodo can be used to connect with Anaplan?
-
How to use AI tool
Hi. My team is going to use AI tool in Anaplan, and I can't know how to use it. This article in 2019 said that we can use it.…
-
level 1 Model Building (lesson 7)
How to map data for module employees? import process will populate the module with Name, Country, Start Date, Leave Date, Current Salary, and Commission % data. also need to set header and first row.
-
Snapshotting Issue - Formula Summary for Time Periods
Hello! We are doing snapshots for some key metrics, and I'm facing an issue where a few of the source line items are %ages with a Formula summary for Time period. When these are being imported into the snapshot modules, the quarter value is being messed up because that can't have a Formula summary. I figured I could create…
-
Boomi + Anaplan Integration
Hi, I'm building the integration between the Anaplan and DB using Dell Boomi. Is anyone has any sample flow? how it need to be built? Thanks, BS
-
Importing data from .csv files
Can you please explain how should I import the .csv File at the mapping stage? How do i know what options to select under the SOURCE dropdown? what logic it uses so that the data can be displayed as desired in the model. I am trying to import the subset file however it is a bit confusing as to what i should select in…
-
Excel Extract in mail attachment
Hi, I want to attach Saved view as a mail attachment and send it to clients. We dont want to show other module data to them so excel add-in doesn't work. So do we have any solution for that. Regards, Ajinkya S
-
Can't upload a new import data source for part of actions
When I tried to upload a new import data source file(.cvs file) for a action, I find it is void, no any error message, It looks like everything is working, but when I want to edit the action after upload new source file, still prompt "The uploaded file is no longer available; please upload the file again". And I found it…
-
Level 2 sprint 3 activity 3.3.4 TRA01
I have been trying to figure out the formulas in this activity, I know that YEARVALUE function would be used with LOOKUP function. I am not able to figure out so as to what the mapping dimensions should be for LOOKUP as P3 SKU and G3 Locations are not lists. These are only dimensions I can think of as of now. Please guide…
-
Export Formats
Hi, Just wanted to know that while exporting from the New UX is there any way in which the pdf export format be obtained as an A3 page. Currently the export is landscape oriented by default so is there any way out that this can be changed. Thanks in advance!
-
API scripting manners
Hi, I got this question from our partner consultant. Any advice would be appreciated. Thanks! Anaplan Connect is provided as a Java JAR, but I think it is actually provided as a sample that executes Java from a shell script or bat file. The customer already has an infrastructure that can run Java directly as an…
-
Data01 P&L Actual and Budget
I had a question about importing data into the Data01 P&L Actual and Budget module. Whenever I imported data into this module, for some reason, only half the data gets imported. I never see the budget section under this module after importing data, only actual and forecast. Can someone please tell me how to import the data…
-
Error : Evaluating the forecast in Hold Periods ～ Statistic forecast
I'm trying to evaluate the statistical forecast by using Apply Hold Periods. But when I set them, the almost of product's best-fit forecast is set to New Item Forecast. How can I correctly evaluate the forecast?
-
How to use batch file process ~ statistic forecast
In statistic model, there are some instructions and power point file. -Daily Batch Process for Demand Forecasting In this document, I can see there are some Batch Process or import actions. But there is no Actions in the Statistic forecast model. How can I run the Batch Process?
-
Anaplan Connect import error 12476
Hi, I am currently having issues with my script using Anaplan connect and I hope someone could help me with this. The error I receive is: “ERROR 12476 |-- Imports not found: Imports not found for Model-ID=8954E749858F4CEEB35EBD5BFB54595B (Feign: status 401 reading AnaplanAPI#getImports(String,String,int);…
-
Sprint 1 : Import flat list for country
Hello, The csv file contains country name, code and parent, but needs to be imported as a flat list. A) There is no way we can leave the fields blank while importing as it is throwing errors B) Can i make changes in the source file itself to just get the countries? We do not want the parental hierarchy c) I have just…
-
Referencing models in another workspace in real time
Can a calculation referencing a line item from a model in a different workspace be accomplished in real-time? Or will it require other forms of interfacing?