-
Creating custom codes best practices
What are the Creating custom codes best practices. I cannot find in custom codes creation video please.
-
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 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…
-
trying to load from Snowflake to Anaplan using IICS (process in Anaplan)
Hi, We are trying to load hierarchy in Anaplan using IICS Anaplan connector from snowflake. Below are the steps we took- Step 1 - Mapping created with source as Snowflake with SQ query with all the required fields. Target is Anaplan Import( any hierarchy). Upload only import option checked. This step will upload the import…
-
Anaplan Mulesoft Connector v3 - Please specify the following parameters: -mappingproperty Period:?
Hello All, I am using a v3.1.0 connector for Mulesoft integration and trying to invoke an import action. The metadata for the import action shows that it is a type: MODEL. { "meta": { "schema": "https://api.anaplan.com/2/0/models/<modelId>/objects/importMetadata" }, "status": { "code": 200, "message": "Success" },…
-
latest excel add-in - are there any. security risks?
My client is going to use the latest excel add-in, and they are asking if there are any security risks. Does anyone know?
-
IMPORT failing - Not sure WHY?
Hi All, I am unsure why the Import is failing whilst import into dimensioned / non-dimensioned module.. Import snippet: 1st & 3rd columns are List Item Property Whilst Import it is failing due to duplicate values: The final output in module is the consolidated values of all number types.. Screenprint from BluePrint (not…
-
Anaplan SSL wrong version number issue in Import action
Hello Team, I have Pyhton code that connects to Anaplan using API 2.0 and import data.I am using proxy server to connect. This was working fine until yesterday we found below error from my application. Error occurred:- Exception method name:- auth_request exception details:- HTTPSConnectionPool(host='auth.anaplan.com',…
-
Automatically Open Model
We have multiple models that take a significant amount of time to open the first time. I am hoping to find a way to use a tool to schedule a model to open at say 8 AM every weekday. That way executives opening for the first time will have a reduced wait time. Anyone had any success doing something similar? What did you use?
-
Linking Line item to List
Hello folks, I am new to anaplan and stucked at one small requirement. We are having two modules i.e. Module 1 - Product segment (Defined in List for different products) with transportation cost line item and Module 2 - Transportation cost for Each segment in line items (input). Need to know how can i link the…
-
Level1 7.2.3 Activity mport Data into Employee Details Module
I'm processing Level1 training and I can't understand how to deal with "7.2.3 Activity mport Data into Employee Details Module" . Could you tell me how to set the Mapping tab (Source) also #E2 Employees Tab ?
-
Formula to get a Line Item formatted as a List based on a Trimmed data field
I am importing data with a field that has the names trimmed from a list. What formula can I use so that that rediscovered name corresponds to the name of the list in Anaplan?. Let me try to show this example: Data TXT File: Crititcal Line Abrev Field:AllocCrediDirecFixed Anaplan List: Critical Line List:AllocationsCredit…
-
Microsoft Excel Add-in 4.2 Issue on Data in Excel
Hello, I hope you're doing well... I just have a quick question on Anaplan MS Excel Add-in 4.2. Situation: 1. In Anaplan, I set up a workflow such that, when the data is submitted, the data will turn from blue to black, which means cannot be edited anymore. 2. When I set up a connection in Excel Add-in, those cells that…
-
Anaplan connect Model to Model import
Hello All, I am looking at the Anaplan Connect documentation and I see the section Model-to-Model import which mentions the option to import from list and module. How about importing from SAVED VIEW. In cases where we want to import only certain items via view, how would we use Anaplan Connect to import. Also, the document…
-
Creating a new model - issue
I got stuck at one point in building a new module and I thought maybe someone could give me some advice. 1. I built an INPUT MODULE that has a lot of line items (about 30) - some of them are filled uploaded file and some are calculated based on other line items. For this INPUT MODULE data is loaded for two version…
-
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…
-
Import from Excel using Cloudworks
Hi, Is it possible to import data from an excel sheet placed in my desktop to Anaplan using cloudworks? Thanks
-
Level 2 - Sprint 1 - Data hub - 1.3.10.4 Check Your Work - not getting data as expected
What is expected: 1.3.10.4 Check Your Work After completing the import processes, the G3 Location list in your Data Hub model should look like this example: but what i get is: 😞 Below are from other lists: G1 Region: G2 Country: i feel i missed something in the G2 Country, but please check the above screen shots and advice…
-
Sprint 1 user story 4. I am stuk at 1.7.3.2 Import into SYS08 SKU Details module
I am stuck at 17.3.2 Import into SY08 SKU details. I am importing SKU details saved view from Data Hub model. However I am not able to do the target mapping. I have attached the screen shots. COuld not move further due to this. It would be great if someone point out where I am going wrong.
-
Can I export a saved view?
Can I export a saved view or will it export everything?
-
Calculation Functions
Hi , I'm facing an issue with the Selector in the below image . In Grid 1 , when I select Project Name = DARE , Product = Integration and Specifics = BU, I can see all other combinations as well which has these selected values whereas I just want to see the one highlighted below in Grid 2 . Grid 1 has List drop down line…
-
Import Issues
Hello all, I am having some issues in importing the data for Level 1 Lesson 10.2.2. I have made the module correctly but when it comes time to import the data I keep getting the following error messages. Is my matching correct or have I made a mistake somewhere? I have attached screenshots below. Any assistance is greatly…
-
Importing data with two dimensions?
I'm playing around with Anaplan to learn better how it works. I want to import population data (see below). The data in the csv has country on the rows, years along the columns and the respective population it the cells. In Anaplan, I have created a list for the countries (with the codes) and I created another list for the…
-
Informatica Issue
There's an issue while running a Process in Anaplan from IICS. When a certain process is run from IICS instead of picking the new source file it's picking up the Native file and after 48 hours it throws an error "localMessageText=The uploaded file is no longer available; please upload the file again, occurrences=0,…
-
Anaplan Connect Script
Hello there, I am trying to run a script of process but I get this type of error,anyone to help me.
-
Is there a way to integrate mailto function?
Hi, I would like to integrate MAILTO function so that it automatically sends email to dynamic users based on selections done at the backend. Thanks
-
PlanIQ Error Messages and Warnings
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…
-
Dynamic User List
Hey, I am creating a dynamic user list, wherein I need users with a specific designation (A). Now i created a module, applied a filter and filtered all users with designation A which is populated into my list 'Users with A' however when a user who is updated into the list ('Users with A') but later is changed from…
-
Issue with swapped data in 12.4.4 Activity: Create Saved View for Profit & Loss Report
Hi there - I've got a question for activity 12.4.4 It appears that my data is swapped in the actual and budget columns. Being new to Anaplan, does anyone know how to untangle this? How can I correct the data? Any step by step instructions would be appreciated. Thank you!
-
Integration of Data from Anaplan to Power BI.
Hello All , My source is Anaplan data , i extract the data in CSV and do run a R-script for unpivoting the columns and then connect the updated CSV file to Power BI. Now , i have requirement to connect the data directly from Anaplan to Power BI. Any Suggestions ? Thanks for the help in Advance. 😄