-
Create Child in Numbered List
I had the original Model, and I was trying to replicate it. The pic 01 and 02 are the Original ones. The pic 03, 04, 05, 06 are my Model. It is restricting me to enter the values:- Soft Drinks, Tea.... I even tried creating .txt file and import it but it failed too. I need your kind help for this. Please feel free to ask…
-
Import Failure while importing from one line item to another in same module.
Hi Can anyone explain me the cause of the error " No value loader exists for this type: NONE " . Any help would be appreciated. Thanks
-
Why won't my vendor roll up to my Total department. It seems to be only this vendor.
I created a a vendor call MISC. Its to group all the vendor under a certain amount to MISC rather than showing a bunch of vendor. When I select Total Department, MISC won't show up. But if I go to the specific department call N/A or No Department, which is the roll up level. It will show up. I tried moving N/A around to…
-
Importing Text: Result ends up longer than import
This is a pretty bizarre one... am importing in a transactional level data set which has a unique code for my list - model best practice fans. Then as I load into one of the properties of the module some of the information transforms from a four digit character to the same four digits but with FIVE leading zeros. I've…
-
201 course activity 4
Hi ! I'm taking a class activity 4 of 201 and trying to import data of 2015headcount. But I failed to import in terms of stat and end date. I'm thinking the reason is that I used a different date format. So in the guide line, there is written " select the Rep Setup Line Item Tab in the mapping wizard and choose Custom…
-
System Default date
We are building dashboard with workflow, where user approve/reject demand plan, would like to keep system date so that we will know when user made changes. It would be great system default date and time can appear there. Thanks,
-
SUM Function Example
I tried to create a simple SUM function. In a video it explains transaction as Line Item whereas I failed it as Line Item. So I tried using Transaction as a List. It worked out. Can you please let me know, if I am right or wrong? I have shared Screenshots for reference.
-
data import unsuccessful
Hi I am trying to import data from a .csv file into one of the list that I set it up, but the data import fails with the message ' New property combination found but name or code already exists'. Please see the screen shots attached for the setup. Any help would be appreciated. Thanks Regards Prabakaran
-
Distinguish between List Item or Line Item
Dear Members, I am new to Anaplan, so I would request your generous help. Order Number or Transaction Number is a Line Item or List Item? And if the answer is List. Then let me know, if millions of transactions happen daily in any Retail chain or Bank. And if we create Numbered List for the Transaction, after 1 Billion…
-
Anaplan - Informatica Cloud upload only import
In Anaplan Connector - Informatica Cloud am trying to Upload Only Import and then make use of an existing process. I can perform these steps in Anaplan Connect, but not seeing how to make this happen in the Informatica Anaplan Connector. I see the checkbox for Upload Only Import on the Schedule->Advanced Target Properties…
-
Anaplan Connect - Illegal Argument error
Hi, I tried to do the run on Anaplan Connect 1.4.1 Basic Authentication and this is what I receive as a message. I temporarily remove the password on the batch file. Please see attachment on the script with error Regards,
-
API: Running a process
So if I have created a process that I use via a dashboard button. Step 1: clears a list Step 2: The file to upload selection is available Step 3: You choose the file Step 4: You hit run The process runs manually without issue. If I use the Anaplan Connect, I created a .bat file and can trigger this process and it…
-
Data Mapping for Import failing
Dear Community, I need a help. I am trying to import import the Unit Cost and Sales Price. My file image 002 depicts desired output. Image 03 is the .csv file to be imported. But I am unsuccessful. I need help badly. Kindly guide me. I have shared screenshots for reference.
-
How can I return the current date in line item?
How can I return the current date in a line item i.e. automatically get Anaplan to show the current date in date format so that it updates each day? Tweakbox Tweakbox Tweakbox Many thanks, iosman
-
Exporting table from DB into file with all data from table including zero data rows/columns
Hi, I have this table in a dashboard and when I export this table into an excel file, it only shows the rows that have a number > 0. See pics attached. How can i export it so that it exports the whole table, including everything that has 0? Thanks! Amanda
-
Currency Page Selector/Filter
Hi, I need to be able to create a DB that allows me to choose what currency to display. At the moment I have data in various currencies, a currency conversion module has been made which hosts GBP, Local Currency and USD. I've created the FX List. What I need to do now is on the dashboard somehow create a page selector that…
-
Introduction to Model Building Couse Guide
Hi all In the training course 102, extra line items should be created, but i cant find the guide or requirements for this. Where can I see what is include in "Sales Performance", "Sales Region Roll Up", "Company profit"...etc? thanks in advance. Tsuyoshi
-
Updation of master data and its reflection in spoke model
I performed an incremental load / full load of the master data(lists) from my Data Hub to a Spoke Model. Now, in my data hub, I renamed a list item in one of my lists and I want to update the same in my spoke model in some way without having to manually change the same in the spoke model. Is there any way to handle this…
-
Google Chrome Extension to make long formulas easier to read
Hi everyone, I created the chrome extension Anaplan Formulator to make long formulas easier to read in the native formula editor. The extension inserts a return before and after each IF, THEN, and ELSE in the formula. Please take a look and let me know what you think! Thanks, Ryan
-
how to load data into sub-products in line items.
Hi All, i am facing a small issue while loading actual data into line items. we have two products category. Products L1 Examples : TR,TW,UC.,,, Sub Products L2 TR_M, TR_Q, TR_HY, TW_M, UC_M .,,,,, Data file contains both products and sub-products can any one help me solve this. i am loading data via list to module. getting…
-
Numbered List import issue while using 'Combination of Properties' with "Month" as unique identifier
Use Case and Workaround: I am trying to import data into numbered list using "Combination of Properties" option. The catch is, my only unique identifier is "Month". I have records for a GL Account by Cost Center by Product and by Location. And will have same combination coming in as Trial Balance records but for different…
-
Saved View in Import
Hi, I just want to clarify something. Please see attachment. Regards,
-
Code for Numbered list
When I want to create member(s) in a Numbered list, I can create it by inserting in the list (without having to mention a code) or through 'Create' action without having to specify a code at the time of creation. Why does an import action into a numbered list needs a code or combination of property for creating list…
-
Saving changes to selections on a Dashboard
On a dashboard, you may want to hide or show additional rows or columns. If you make any changes to your selections, and close the dashboard, your changes will be lost. In order to save changes to selections, you can go into Page Selector Options, uncheck the 'Show module name' button and click 'OK'. Then go back in to…
-
Import Error
Hi, Please see attachment for details on issue. Regards,
-
How to do use dropdown list within the PROFILE function
Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a drop-down list from a number of different allocation profiles to use in the PROFILE function. To hold the different…
-
Specify mapping options in the rest call
Hello all, I would like to ask whether it is currently now an option or in future plans to specify mapping options when making an rest api call. For example, we could append to the basic rest api call to trigger an import action: /workspaces/{workspaceID}/models/{modelID}/imports/{importID}/ things like:…
-
IMPORT ERROR (MODEL TO MODEL)
Hi all, Anyone encountered this error? We cannot import from one model to another because this error occurs every time. Kindly see below:
-
Data Import Error - “Key for this row maps to more than one list member”
Dear Anaplanners - we have a couple of import processes that are presenting a number of Fails, with the Error_1_ message “Key for this row maps to more than one list member”. Is this an error message I need to be concerned about - as both of the lists that we are importing against we are aware are replicated to support two…
-
Error in importing CA Certificate
Hi All, We are trying to achieve CA Certificate authentication. While we followed the instructions provided in the link below https://community.anaplan.com/t5/Knowledge/A-Guide-to-CA-Certificates-in-Anaplan-Integrations/ta-p/39305#toc-hId-1363730354 , we got an import success message. But still, we don't find any file…