-
Issue with import action when importing data using saved view
Hi all, @Misbah I am trying to import data from saved view to module and i have applied some filters on that saved view depends on filter the data getting updated and at some point of time the saved view getting empty because we don't have any data as per filters(as per requirement its working as expected) so when we run…
-
Python API with Anaplan || Import || Parameters
Hi, While running an import or process through python API , is there a way to check if the import or process needs a file and which type of file is required? In other words, I need to check if the import is a model to model or csv/txt import and in case it uses a file what is the type of the file required. Any help would…
-
!!! Stuck on 1.5.6.1 Create Historic Volumes Module !!!
Can someone please show me the exact mapping that needs to be done for this exercise? I have tried this several different times over the past several days and I am still stuck on this. 😑 Any help would be greatly appreciated.
-
DAT02 Shipping Metrics Module
How to import data in to module - DAT02 Shipping Metrics Module? Not sure if I missed this on what but during Sprint 3 I realized there is no data in the module. Thanks
-
Anaplan + Boomi Integration
Hi Team, I have flow which runs using Boomi. In this flow data being pushed from DB to Anaplan (upload). While running this flow, i'm getting below error message. [1001] cannot parse the JSON response. HTTP Response: Unable to complete the HTTP call due to a communication error with the remote server.…
-
Export with same formatting
Hi, Is it possible to export with the same formatting as the module / dashboard ? e.g. I have zeros showing as blanks or dashes, but when exported, it's coming up as 0 in the excel. Thanks in advance,
-
Manual import in the PROD model
HI: We have just created a DEV and PROD model setup. During month end, we need to import data into the PROD model, and we have setup actions to do some of these import, which it does work. However, if I decided NOT to use to action to perform the import but use the manual import function instead, this error appears…
-
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…
-
Data Export to a customized name instead of default module name
When we export data from Anaplan, sometimes we want to keep a customized name instead of the default module name. If we save an action with our preferred name, although the Export Name is changed, when we click "run" actions, it will still be exported by the default module name. To solve this problem, we can create a…
-
Run-off activities and innovation
Hi! I'm currently working on a KTLO project within Anaplan and we are looking for new ways to drive more impact to our client and innovate in our run-off activities. For example, we have come up with a model size tracking dashboard in order to do quality checks on how data gets uploaded every day. If we detect a huge…
-
CloudWorks Integration Limits
Hello, I am very new to data integration and trying to start explore this subject thanks to CloudWorks. On the CloudWorks Anapedia page, it is mentioned that it is only possible to have 25 integrations per Tenant. I am not sure what it does actually mean. Does it mean that one tenant can only use 25 import/export "Actions"…
-
Actions
How to add the Import Volume Growth Rates Action to the Process.
-
Level 2 Sprint 1 Activity 1.3.4
Hello guys, I'm having trouble completing activity 1.3.4. I think that I'm supposed to refer to SYS05 for the region code when importing the parent to SYS06. Below is the capture of my mapping. After running the import, the "Region" line item on SYS06 is still empty. Your tips would be much appreciated. Thank you
-
Finditem Fails to Detect Valid List Member
Hi Anaplan, I've come across something strange and wanted to ask if anyone has any ideas what is going on or if this is a bug. I am creating a List using a Saved View that contains a list of codes (text) to be added to a list. The import action is set to use code only, and the source codes are imported into both Name and…
-
KTLO activities and innovations within Anaplan
Hi! I'm currently working on a KTLO project within Anaplan and we are looking for new ways to enhance the platform performance and drive more impact to our client. For example, we have come up with a model size tracking dashboard in order to do quality checks on how data gets uploaded every day. If we detect a huge…
-
Running a process results in The uploaded file is no longer available; please upload the file again
Hello, I am trying to run a process by ID after I upload a file via API. I get the error "The uploaded file is no longer available; please upload the file again" The file uploads and there are no issues, I can see the data in the console. When I upload the file via API, I see the file is set to "This file is not shared…
-
New features for Bundling Actions.
Are there any new features recently released that can be helpful in streamlining various actions into a process other than the usual way a model builder does it?
-
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)
-
How to convert flat data into monthly - GL example
Confused on how to work with this flat data and derive monthly values from it. Appreciate the help! Each row is a unique combo of Account (GBAID), Ledger Type (GBLT) and Year (GBFY). The snippet attached is 4 entries for the same account and ledger type for 4 different years. GBAN01-12 are entries by month. For example,…
-
Delete items of list with no parents
Hello all, I'm trying to delete items of a list that are not linked to a parent. Therefore i cannot use "the delete from list using selection" action. Do you have any tips to achieve that ? The list is quite huge so it's difficult to do this clean-up manually. Thanks for your help, Maxime
-
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…