-
Excel Add-In OLE Action
Hi All, I wanted to see if anyone has been encountering this issue with the Excel Add-In. Oftentimes members of my team will go into Excel, log into the add-in, and then the whole Excel Application feezes. It freezes for a few minutes and then comes up with a message box saying "Microsoft excel is waiting for another…
-
Import Pop-Up
Hi Team, A user has just started receiving a strange Pop-Up when they use Data - Import when within a Module Normally you start with the Select Source pop-up and move to the mapping items etc while this has no mapping items etc Is this due to access levels? Thanks User Upload Pop-Up Normal Upload Pop-Up
-
import action not grabbing latest data file
I have an import action for importing data into a module. I've created a process for this action and a button for the process published to a dashboard. When i click the button....sometimes I have to select the file to upload and sometimes I don't. The data in the flat file has changed but I don't see that reflected in the…
-
Filter by formula
I have a particular existing module. Now I want to create a new module which will only have the filter records. Please assist.
-
Delete record without saved view or filter
Hi Friends, I have a Module from which I want to delete the highlighted records. But without using filter or saved view. I can use any formula to do so. Is is possible by any chance? Kindly help me, if you had worked in a similar restriction.
-
Importing a csv file - Question
Hello Anaplan experts! I am very new to Anaplan and am going through the courses to get my Level 1 certification. I am sure this is a vey silly question, but figured I would ask rather than keep spinning my wheels. I have a csv that is attached. I need to Import this file into a Geo Hierarchy, but am having trouble mapping…
-
L1MB-Part 8: Data Import For Rev
I'm not able to import the data correctly. The mapping of the columns seem off. I'm trying to use column headers for time but it keeps picking up the first column where it says Volume (See attached). Is this because the way I built the module (see screenshot)? Thanks, Kevin
-
Anaplan API WADL
Hi , We are looking to use the anaplan api with one of our ETL tools which allows us to setup a connection using a rest connection, however it's looking for a WADL. Is this something that exists or will we need to create this ourselves. Thanks D0nmac
-
Db2 integration with Anaplan
Hi All, We are planning to start to integrating data from Db2 into anaplan for planning. First i did not find any search results with Db2 so starting link in case any one ha earlier experience please share your inputs. Secondly, more specific question are their any anaplan recommended connectors for Db2? And third in case…
-
how to update list with hierarchies
i hv created a list with different properties and want to update some properties when end user done some changes in the property published on dashboard and same gets updated in the list. i hv created a system module with two line items same as property in the list and published on the dshboard. once user does some changes…
-
Model Building Level 2 Training - Import Issue
Hello, I am trying to upload data in OTH01 module of the FP&A model from INV05 in the supply chain model. Every thing looks perfect. I juste have a problem when matching the location. As you can see in the source module i have Mumbai as location while in the target module i have Bombay. Is it normal ? What module should i…
-
FAILURE_BAD_CREDENTIAL when executing curl command for authentication token
Hi, I'm following the Anaplan API and trying to create an authentication token. I'm using the command with my username and password included: curl -X POST --user YourUser.@anaplan.com:YourPassword https://auth.anaplan.com/token/authenticate However, when I run it I get an error message FAILURE_BAD_CREDENTIAL. I'm using the…
-
Import Data into SYS06 Product Details
I am having issues when I import, this is what I have done. Only one size gets imported
-
SYS08 Importing data
Hi all. I've been constantly running into issues importing the employee details csv file. I'm going to attach the three things I am seeing on my screen. Was anyone successfully able to import data? Let me know how I can do this.
-
Can a parent numbered list and child numbered list have the same code?
Hi All, I have a parent hierarchy in numbered list.Both are uniquely identified by code. Parent List : Program Child List : Project So When I am importing into child list(Project), it is ignoring some of the records. After the analysis, I found that the records that are being ignored have their codes already present in…
-
Triggering Scripts or Rest API calls from within Anaplan
Hi, I want the ability to trigger scripts or REST api calls from within Anaplan. For an example, say I have a file watcher on a network share drive location. If files are added or updated in this directory something should happen to them. In this case I want the files to be uploaded and imported into an Anaplan model. I'd…
-
Level 1 Model Building: EMP01 Employee Drivers import
I've been working on the Level 1 Model Building course and I'm a bit confused by this import. I'm sure I have followed all the directions exactly from setting up the EMP01 module to downloading the correct csv file for import, but the one thing I can't get right is the time that it's asking me for. It's asking me to…
-
Incremental data load for current month
Hi, I want to do a data load only for current Month data, I have a data file where I have complete year data but I want to Load data only for current month. We have created a boolean line item which filter my current month records based on current period setting in model. but Just wanted to know, can we setup a process to…
-
Data import from excel to List
HI all, I am loading data from excel to List and i have blank entries in the excel sheet which has business meaning, hence i am bit struggling to maintain blank entries in the list or how Anaplan recognizes the blank entries from excel records and loads automatically to the list. -Santosh
-
Importing between Models - Mapping
Hi, I currently have 2 models and I'm trying to pull staff costs from one over to the other. The module I'm trying to import into is dimensioned by employees and years. The module I'm trying to import from is dimensioned by employees, years, and versions. When I connect to the Anaplan model and select the module, the…
-
Percentage Issues: Level 2-Sprint 2
Hello, I have a problem when importing percentages from a CSV file into the DEM01 Volume Growth. In fact after importing, it looks like all the percentages from the CSV file have been multiplied by 100. Any one has faced this issue ? This is my number format configuration. I tried ti change it but it didn't have any impact…
-
List with active products only
Hi all, I'm trying to figure out how to show active products from a list of all products including historic, non-active ones. I currently have 2 modules: a module dimensioned by the product list and time (years), with a boolean for active / non-active and secondly a calculation module dimensioned by the same product…
-
Import Error
Hi All, I am receiving an error 'Illegal Argument' while importing data from the saved view of the module to the same actual module within the same model. Please help me with the possible reasons. Thanks in advance. Sampriti Anand
-
Costume view with sorting in the excel add in
Hello, I have a Costume view with sorting. I want to create a connection to this view. When I do that and want to change the page selection i get the following messages: Why does this remove the formatting? Is there a way to solve this? Thank You, Ronit
-
Level 2 - Sprint 1 User Story 1 Rename the action
When I try to rename the "G1 Region from Level 2 Data Hub [Your Name]/ 'SYS05 Region Details" to "T3.1 Build Region", I can't find the right place to click on the "Rename" button (I also tried right click on Import items but in vain), also tried to click the "Rename the action" hyperlink but there is no demonstration…
-
Model change has been rejected to prevent the workspace exceeding its size limit
Hi, I am working on a Sales Forecast Model by using customer and item for a Region. In the Data Hub, number of customers = 13,083 number of items = 24,876 However, I got an error message when I tired to create the forecast model by using customer and item (see attached.) Is there any memory alert in Anaplan or how can I…
-
Export in Tabular Multiple Column Layout - Overlapping Filters
Hi Team, Reading on Anapedia that when you export using the Tabular Multiple Column option and use the Boolean filter options that if those Boolean filters overlap then both criteria must be met for cells to be exported I created a very simple test where I created 2 Boolean line items for Product Family & have Chocolates…
-
Import Data Between SSO Enabled Workspace & Non-SSO Workspace
Hi all, I know that we can import the data from different workspace. My question here is "What will happen if SSO setting is different between the those?". i.e. Workspace A→SSO enabled Workspace B→Non-SSO →Can we import the data successfully or it will fail? *Both workspace are in the same tenant. Thanks Mao Ninomiya
-
Import Fail - Invalid date or Timescale error
Hi Team, I have a line item where the data is Imported from another module in the model I have also created another line item in the same module which is set to No Data that I Import to the line item mentioned above to clear it before running the previously mentioned import action. I have these 2 Actions in a process (1st…
-
Transformation Data
What is "Transformation Data" in Anaplan ? What is its significance and in what scenarios, it can be applicable ?