-
Anaplan API: Basic Authentication failed for Linux
Dear Expert, Good day! Would like to seek your insights with regards to Process script issue using Linux interface as below. Thank you in advance. Check list done as below but still the same error “Anaplan API: Basic Authentication failed” * Anaplan access checked (able to access the workspace and model) and password…
-
Level 2 FP&A Build Guide for lost Level 1 Model
Hi All, I just completed the level 2 sprint 3 exam and I need to rebuild the level 1 FP&A model. I followed the given instructions, Level+2+FP&A+Build+instructions.pdf (anaplanenablement.s3.amazonaws.com) however I'm running into a few issues... I built my P3 SKU list and the DAT02 SKU Volumes Module in the FP&A model, but…
-
11.3.2 Mapping Issue
Hi - I am stuck on 11.3.2. It appears there is a mapping issue with location (see screenshot). When I try to manually map the locations to the regions, it will only allow me to select one city. That's problematic because there are multiple cities that belong to a region. Can anyone offer me advice? Everything else is…
-
MAILTO functionality trouble shoot
Hey Team, I am facing this issue on MAILTO. I tried getting it in two ways: - Option 1: - Used MAILTO functionality MAILTO(u, v, w, x, y, z) Result from triggering this option from the backend and frontend (NEW UX) has led to an error where the line breaker (%0A%0A) inserted in the body of the mail does not function.…
-
Level 1: 8.5.3 Activity- Unable to import data in Volumes module
Hi Guys, I am unable to load data in Volumes. The issue is that file is loading sum of all the columns into single month. e.g. in Jan'19, data for Jan'19 from file should load, but it is first summing up data from Jan'19 till Dec'21 and then adding that number in Jan'19. Same process repeats for all months. Can you please…
-
Countries with comma as decimal setting - How do you handle this for importing CSV files?
We just encountered a bit of a hiccup with some of our countries saving and loading csv files to our model. It turns out that countries using comma as the decimal have this issue in Microsoft Excel. When they save as a csv, it uses a semicolon as the separator. Even if you change the separator option in Windows/Excel to a…
-
Phone Cost for Sales Department
I have been trying to figure out how to solve this issue that keeps popping up when I enter this formula: IF Employed? THEN 'EMP03 Employee Drivers By Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 I know it is something with the Roles list and the…
-
Import using Python api insert not happening only update
Hello Team, I am trying to import csv data into Anaplan using API 2. but whenever I import new data is not being inserted old values are being updated correctly. When I import new data using browser it works perfect. dataFile = open(data.csv, 'r').read().encode('utf-8') fileUpload = requests.put(uploadURL =…
-
Level 1 Training: Unable to load data in Employees module
Hi Guys, I am following level 1 training, but at the step 7.2.3 Activity: Import Data into Employee Details Module, I am unable to load data as it is shown in the snapshots. The issue is E2 Employees# list is a numbered list, so getting confused on its mapping with the target module. Second thing is the source file has…
-
Level 2 Conclusion: INV05 Import to OTH01
Hello, I am trying to import the INV05 file to the OTH01 module, but I am getting an error message in regards to the fact that the INV05 export file has half-year time periods (ex: FY20H1). I've tried to use the Show function to hide them and the Months Only? filter as a way around it, but no luck.
-
Actuals load time
Can anyone share how long it would take to load ~20M records of actuals into Anaplan ?
-
More than one value for non-numeric cell - Boolean
Hello, I have a input module published to a dashboard that allows planners to enter new headcount for their departments (Planner Dashboard TBH Input - DB View). I import this data into another module that doesn't have the department dimension (To-Be-Hired - Input). The purpose of the dashboard module is to prevent planners…
-
Run multiple 'Delete Actions' at once
There should be an option to run multiple delete actions at once under the Actions tab. PROS: Time Save Faster execution (Extra space)
-
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…
-
Pasting Multi-Line Cells from Anaplan to Excel
I'm experiencing an issue where copying multi-line cells from a default module in Anaplan does not properly paste into Excel. In the attached image, I'm copying three rows from Anaplan to paste into Excel. Instead of pasting 3 rows, the second line within each cell of the "Admin Comment" column is shifted down and to the…
-
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)…
-
Level 2 conclusion INV01 export view
I have created an export view from my INV01 module. I've been able to deselect the hierarchy for the products but when I try to deselect levels for time the option is greyed out. I've tried pivoting the view and that still doesn't work. The export looks like the example except for the monthly summary. Can someone help me…
-
Dynamic target version for import to module
Hi, I would like to know if somebody is out there to help me with a problem 🙂 Each month we make a Sales proposal in our source module (in the version Plan Proposal). After approval of the proposal, the values of the plan proposal should be copied to a different target module. We need to copy the values starting from the…
-
Customized exports from UX Page
Hello, I was wondering if it is possible to customize the export of UX Page in PDF format for the end user. What do I mean by customize? Now we have created a UX Page, from which data export in PDF format is generated (it contains tables, charts that are on this page) - the data for the corresponding page selector is…
-
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