-
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 ?
-
import query c sharp dimension in the target module do not match the import definition
What does that mean? Something isn't importing from my sql query.
-
Non availability of Action buttons in mobile application
Hi, While using the mobile application, I observed that I am not able to see the import and export action buttons in the pages which I created in new UX pages. In one of the projects, since some of these actions are really essential for the process movement of the model as well as the requirement is for user friendliness…
-
Exporting Revision Tag details in excel
Hi there, Just wondering if there is an option of exporting Revision Tag details in Excel or other formats? I am trying to get all revision tags exported in excel for detailed documentation purposes. Thanks, Vish
-
Uploading file via REST API/Python
Hi, I am working on an item that uploads .csv file into Anaplan. I'm not sure why the upload doesn't work even if the response of API is successful. I've tried using some codes posted here but seems the upload does not work (download, import seems okay) I'm using basic authentication and 1.3 version of the API. Here is a…
-
L2 Sprint1 Set up import from Source Model
I was hoping to confirm if I created 3 new lists; G1 Region; G2 Country; G3 Location in the right area. They show up as Subsets.
-
Uploading user stories from excel
Is there a way to upload several user stories through an excel file instead of entering them individually?
-
Model import
Does anyone know how to deal with this error?
-
Not able to load special character
I am not able to upload List with special characters in my Anaplan model correctly. When I am uploading list with special characters, Anaplan is ignoring special characters and considering the other English language character. The line items are formatted as TEXT in list in Anaplan model. Ex: For name "STARK JYVŠSKYLŠ"…
-
Level2 Sprint 1 - DAT04 Distribution Center Parameters
I am trying to import the Half yearly data into this module. But I am facing difficulty to map the dimension. What format to be used here. The CSV file has data in the below format. H1 FY20H2 FY20H1 FY21H2 FY21
-
L2 SYS07 Location Details Upload
Hello, Thanks for the help in advance I am try to upload into the Flat List for SYS07 Locations upload and having errors. Below is my attempt to map, with the following error. Much appreciate the Communities patience with me as I have had a lot of difficulty.
-
Anaplan - Export via jdbc
Hi Team , As i am planning to Export data into sqlserver table i am getting the below error can any one please suggest me whats went wrong . Export Code below --------------------------------- @Echo off rem For Windows OS : This example explains the usage of basic Authentication with Anaplan Connect. rem It also loads a…
-
Data Hub Exception Reporting
Hello everyone, I'm looking for process guidance surrounding Data Hub exception reports for automated data loads that occur once or more than once per day. Exception reports are built, etc. Ideally, the process is automated so that the APIs pull data into the data hub and immediately into the spoke models. I'm wondering if…
-
Module to module import issue
Hi We have configured some imports within our modules where 1 line item is imported to another line item from one list member to the next. The List we have used here is Target Setting Stage. So a target being set in one stage is copied to the next stage using these imports as a Previous Stage Target. Now, the issue we are…
-
L2 Sprint 1 Countries Flat File import
Having some problems re running my countries flat file import. Is this the view I should be importing on? Also these mapping continually give me errors. Any help is appreciated.
-
DCA Import Access For Combination List
Hi All, I am working on a model where I have a module with dimension including a combination list, version lists & stages created with respect to P&L. The combination list has been created with the combination of states (rate area), product (Sku) etc. Now to restrict the access of each Regional Finance Manager so as to…
-
API 1.3 changes
Hi, I had some issues this week with the API 1.3 interfaces https://anaplan.docs.apiary.io/#reference if you also have problems please try this: * PUT method to upload file: In the Header the Content-type should be application/octet-stream * GET method to download a file: In the Header delete the…
-
Anaplan Connect Export Record Count
Hi, Using Anaplan Connect, when exporting a list is there a way to capture the number of records exported? When importing into Anaplan the record count is available but not for exporting. Thanks.
-
Import Action Into List from Saved View is not importing all values (no failures/ignores/duplicates)
Hi, I've setup an import action from a saved view to a list in a different model & workspace. It imports without any failures or ignores, but it does not import all of the items. Why is it not importing all items & how do I change the view and/or import action to fix it? Source (Data Anonymized): * 3 dimensions pivoted to…
-
Specification of importing a file changed?
Hi experts, I think specification of Anaplan importing a file has changed. Is my understanding correct? When we try to upload a file, which includes both key record that exists and doesn't exist in master list, <Before> Displays only "Success!" message window, and number of failed records can be confirmed in "View Details"…
-
FINDITEM A PARENTCh
Dear all, Can you please help me on this: assuming i have these lists: List 1: flat file List 2: Parent of List 3 List 3: Child of List 2 I created Module 1 with List 1 as dimension, of which i mapped List 2 as its parent in the module. is there a way i can FINDITEM the parent of List 3 in Module 1, using the text code of…
-
Criteria for developing using multiple Models vs set of modules in a single model
Hello, We are implementing Anaplan for our Finance planning for our business. We have a set of calculations for planning * customer: customer acquisition, retention and churn * revenue: subscription and transaction revenue * inventory: inventory planning and depreciation * warehouse: warehouse labour and costs * support:…
-
Delete List Item no longer found in source
I am working to remove Gross shipment data that is no longer found in the source DWH feed. Shipment actuals can be removed from the source data and I need to remove those not found in the source from the Data Hub and from the spoke planning model. When the shipment actuals are removed from the source them remain in…
-
Data Import
Hi, I need a clarity on data import through integration. For the first time load the load was set and configured in the Integration process, but what if next time the data load comes in with a different delimiter or separators. Will the Integration load auto detects the load and adjust the import or will it give a error.…