-
whether Anaplan provides JOB BASED ID or ANY ID or JOB BASED QUERY or JOB ID
Hi all Wanted to know whether Anaplan provides what kind of JOB BASED ID or ANY ID or JOB BASED QUERY or JOB ID. Whether Anaplan supports Google BigQuery? If yes what is the process. (Any API Support for this)
-
How to export result as .csv file through Anaplan Connect script?
Hi Experts, I'm trying to explore on Transactional APIs scripting. When I execute below script is working fine and extracting all the List items. But I want to export this data as .csv file, how to achieve this? set Operation=-debug -service %ServiceUrl% -auth %AuthUrl% -workspace %WorkspaceId% -model %ModelId% -L I tried…
-
Data Load through One Cloud problems
Hi, I'm having a problem with a Data Load that comes in from One Cloud. The Process works fine when the Flat Files are loaded in manually, but when we try to do the same Process through One Cloud not all the data is coming through, (all my List Items are not pulling in the data). I need help trying to figure out what the…
-
Anaplan Api call via postman
Hi, I am trying to call Anaplan API via postman. I tried Authenicate with https://auth.anaplan.com/token/authenticate and generated token Then i tried calling imports pasting the token through the url https://api.anaplan.com/1/0/workspaces/[workspace id]/models/[model id]/imports and its retrieving the data. But i am not…
-
Level 2 - Conclusion - Create Country Currency List
Hello, While I try to import the currency data, the data for EUROS is not getting updating because it is similar for 3 countries. I tried selecting the name or code also, name only and code only. Tried selecting countries as parent and deselecting it. But facing the same error. Kindly help. Sneha
-
Import Shipping Expenses into OTH01 Module
Import Shipping Expenses into OTH01 Module In the Financial Planning & Analysis model: Import the data from the Supply Chain model into the OTH01 Non Employee Expenses module, Shipping Cost line item. * For department, import into the Sales department. * Run the import. * Results should have none ignored and 0 errors .…
-
Process ID
Hi, We are trying to integrate with Onecloud to have automatic uploads of files. For this I need workspace, model, and process ID. I have found the workspace and model id by just looking at the url. How can I find the Process ID?
-
Distinct count of Agent with comparing Date and Program
I have Module in DataHub without any Dimension I need to create a column that count distinct (Unique) Value of Agent Program and Agent are in Text Format DateProgram Agent Distinct Agent…
-
Data Load Time Setting help
Hi, Having trouble loading in the attached data set. I'm getting a error with my time settings. Please advise. The Flat File is attached. Thank you Error Time Setting for the mapping Blue Print of module
-
Model Building Level 1 - 6.8.4 Activity: Add Formulas to Country Details Module
I'm attempting the following...In your model, open the SYS03 Country Details System module in Blueprint view. Add the formulas to the line items: Line Item Formula CodeCODE(ITEM('G2 Country'))RegionPARENT(ITEM('G2 Country'))Country Only?TRUE When I add the formula, PARENT(ITEM('G2 Country')), to Region line item I receive…
-
Import Question
Hi, I currently have a Process that uses the same flat file to load data into my List and than my Module. I do not know if I need to upload the same file twice for both the List & Module like in the pic below? please advise.
-
Clarification on Anaplan API / REST API
Hi Experts, One of our customers would like to integrate through API / REST API to pull and push Anaplan data. Can Anaplan API's do push? meaning can Anaplan call the Client APIs to push data to client’s database? Thanks for your attention. I'm looking forward to your reply. Thanks & Regards, Anil
-
Import clearing data that's not in the saved view
Hi all, I'm stuck in an weird import action. My goal is to clear data in few line items via an import. My module has 2 dimensions (one is native time and the other one is sales reps). This is a screenshot of my module view. This is the saved view I used for import. First I created clearing line times with No Data format…
-
Is there anyway to omit weekly summary when export or hide weekly summary
Hello, Is there anyway to hide the weekly summary level when export. when i check omit summary it also omit monthly levels Select levels to sow is also disabled
-
Populate Currency module using Currency Rates.csv
Hi I am trying to do import but there is no 'column header' option to select for time why? how to resolve? Roya
-
level2- Import Shipping Expenses into OTH01 Module
Hi, I am trying to import to OTH01 module from this saved view: Ans this is my import setting: I got this error message: Could you help me to find the issue please? Thanks Roya
-
Restrict Users who can Run Action
Hi, I want to restrict users who can run import Action. There is Role function in Anaplan, and it can restrict users. But I think the master management of Role function is too difficult, because Role function has another Modules and Lists roles. It is set None as default. So I should set modules and Lists Roles. I want to…
-
Trying to filter by a Yearvalue with a nested Lookup to pull list parent
I have a module that we export data from using two system type modules that allow a user to filter their export by version and by year (time) using boolean selection boxes (checkboxes). I want to add the ability to filter by a third category, Division. The way the module is currently filtering the data in the export action…
-
Date Format Issue when exporting from Anaplan to BigQuery with CloudWorks
Anaplan is using an unique date format “1 Jan 22” and “Jan 22” as opposed to “2022-01-01” and “2022-01”, which are common in data science. Therefore, when exporting data from Anaplan to BigQuery through CloudWorks, the date column needs to be formatted as string, because BigQuery can’t read “1 Jan 22” as a date. There are…
-
Importing Data issue
Hi, After importing data, it says 'Success!' However, I can not see any data in my module. Please check the attached screenshots and guide me! Mark
-
export data (create export action) with data separator as pipe delimited
Hi Experts, I got a requirement to export data as .csv with data separator as pipe (|) delimited. Please help me how to create an export action in Anaplan as data separator as pipe delimited. Thanks in advance. Regards, Anil
-
Clarity with Anaplan API
Hi, We are trying to make a custom API call for running an Import in Anaplan using a connector that calls the custom API. When we try to look at the URL used for the API call , it starts as ''https://api.anaplan.com/2/0/workspaces/' -> I could conclude that 2/0 here means version 2.0, but this keep running into…
-
[HELP] The most efficient way to create a numbered list and import parameters
Good afternoon, I have the following question. From a stagging module I have to create a numbered list. In the stagging module I have several parameters of the target list that should be imported to a system module. What would be more efficient? a) A single view that includes code, display name and parent of the target…
-
Conditional Boolean: True if an item in Source Module belongs to an intersection in another module
Hi Community! I would like to create a boolean that is TRUE when an item with List format in the source module A currently has an "active intersection" in another module B. So for example, I have a list of Accounts. These accounts have a correspondent Activity related to it (specified in the module B) . I also have a…
-
Will the Action work fine after renaming the list involved?
Has anyone faced this issues? Scenario: I have a list named "List A" and Source module "X" and "Y". Process followed: 1. I created an action "AC01" to import data from "X" to "Y" in Dev model. 2. Synced this action to test model. 3. If I run "AC01", it works fine. 4. Later remaned "List A" to "List B" in Dev model and…
-
Looking for an "action log"
Hello, I want to ask, Is there an "action log" within Anaplan? Similar to History, but which tracks actions. It's important to be able to track when an action ran and its results. For example with import jobs, we need to know when & who they ran, if they failed, error messages, entities added, updated, etc. Thank you
-
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
-
How to Dimension ID and Item ID ?
Hi Team , I'm trying to get Subsidiary module data in a CSV using below API. How to get Dimension ID and Item ID API Used : curl -X GET 'https://api.anaplan.com/2/0/models/{modelId}/views/{viewId}/data?pages=dimensionId:itemId&format=v1&exportType={TABULAR_SINGLE_COLUMN}&moduleId={moduleId}' \ -H 'Authorization:…
-
Model Builders & SAs: Help us understand your model optimization processes.
The Anaplan User Research team wants to better understand the model optimization process, including view clean-up. We are looking for model builders and solution architects to walk us through the process of optimizing/cleaning models. During a 60-minute remote research session, participants will be asked to share their…
-
"Error" message using Import to clear user input date data
Hello, Community In a daily replenishment planning model I've recently deployed for a customer, everyday, the planners may need to manually override below line items (format in brackets): ADS Values (number) ADS % Changes (%number) Cancel Order? (boolean) Manual Order Input (number) Override Delivery Date (date) Hence, I…
