-
dynamic Version selection through anaplan connect
Hi team, how to select version dynamically through -mappingproperty in anaplan connect . or is there any other option to select version dynamically. I have used the mappingproperty previously but through hard-coding of version in the batch file. So please suggest me the better solution Thanks, Ritu K.
-
Excel Add-in 3.2 - Push data back to Anaplan ?
Good afternoon, We would like to use the Anaplan Excel add in to enable user to modify data from a view and push it back to Anaplan via Excel. Apparently the last available version to download is the 3.2 that doesn't allow a two ways connection. Version 2.6 allowed it, but is not available for download anymore. Any other…
-
HyperConnect
Hey Everyone, I have been doing some digging around the Anaplan community surrounding HyperConnect. Our company currently uses Anaplan Connect for all of our integrations, but as we role out additional use cases, I am wondering if we need to look at a different approach. Does anyone have any personal experience using…
-
Module or line item id using restful API
Hi Guys Does anyone know if we can export module / line items ids using anaplan rest api? Using rest api i can export workspace /model/files IDs etc however i cant seems to find any unique keys for modules /line items . Surely there has to be unique IDs for modules / line items behind the scene . Thanks
-
Simple Import failing and cant see why
Hi, I have a saved view in one Module in Finance Model and it has about 20 fields, one of which is Unique called 'NPD Ref Code' I am importing this view into a list in NPD Model, using 'NPD ref Code' and selecting 'Name only' It is giving me an error on a record "New property combination found but name or code already…
-
Excel Add-In 3.2 Log in Issues
We are experiencing access issues with the new Anaplan Excel Add-in Version 3.2. When trying to log into the Excel Add-in (regardless of whether a browser window is open), we are receiving the following error message: "Your session has been logged out. It is recommended that you close your browser to complete the…
-
need to do a look up formula
Hi, I need to do a lookup in my line items so that I can import the data into a module. I have a flat hierarchy factory list. I have 2 line items Inbound Qty and Lot Numbers. I've split them so that I can see: Factory 1 inbound Factory 1 Lot Number Factory 2 Inbound Factory 2 Lot Number I'm not sure what formula to use in…
-
Importing forecast numbers with forecast version and time scaled into a module without forecast vers
Hi All, I am trying to import forecast numbers from one module having forecast versions(list) and Anaplan time into a module only with time-scale. The idea is to have a page selector(forecast) in the target module and when users select the respective months ,they should be able to see the numbers forecasted in that…
-
Level 2 Sprint 2 - Importing data from the data hub
Hi, When I try to run the import data (9. Import Data from Hub) from the data hub model into the DAT03 Historic Volumes module, I am getting an import definition error. I need help to troubleshoot the actions. Thanks!
-
ALM question
Hi All, I have a Dev model where I made various changes in the hierarchy (production data), re-shuffling lower levels and adding a couple of new ones. The data itself, however, stayed the same as I didn't delete anything. I need to transfer the changes to the Prod model now, and I want the data in Prod to be re-allocated…
-
Why did Community delete my post?
I posted a question on File upload via REST API, made several edits, uploaded screen shots and code samples...So the post took A WHILE to compile. On the final submission, my post was marked as spam and deleted. This is frustrating. What happened here? How do I get my content back?? My question was still not answered.
-
Best Practice suggestions to reduce published import action buttons ??
We have two models across which we need to import data by versions (Actual and forecast) and product category, as different categories are managed by different heads. The actual data needs to be imported by month, and forecast data needs to be imported once. We are planning to provide data Import to these head users…
-
Anaplan Connect 1.4.2
Hi, Please check the attachment for details. Regards,
-
Module exports
Hi Team, As pat of my requirement I need to read the file under the models and load into the snowflake for that I am using v1.3 api https://api.anaplan.com/1/3/ I need to get the latest details from the files , so I need to use the export When I start the export at model level, it will export all the files under that model…
-
Dynamic Cell Access - Import
Hi Team, I created a module dimensionalised by Time with Dynamic Cell Access set to Read for all periods except for Sep19 to Jun20. The setup was working as expected when tested manually. When I Imported data from another Model with the same time dimension the data was uploaded into the Read access periods & the write…
-
importing the same day's data
Hi. I have a question about importing. I want to import excel data(below) but the days are same. So I want to import value into Anaplan( -7+7=0 ) After imported, import completed successfully and the value became 0 as I wished. In Anaplan, the value was 0 because it was conducted (-7+7=0)?? If so, even if I have the same…
-
File Schema details using api
Hi Using the Anaplan api how to get the schema details of the file by passing the file name. I am using api version 1.3 Thanks Kandasamy
-
Import Issue
I have 3 models in my workspace. 1 is a data hub while the other two are production models. I imported data from data hub model to one of the models and it was right. But when I imported the same from data hub model to the other model, it is changing the data even when the mapping has no issue. Can someone please help with…
-
Level 2 - Missing actions
Hi, I am currently doing the Level 2 training am just about to get started with the second user story in sprint 1. There it says that I should have a number of actions in my model already (actions that came with the model), but I don't. See screenshots below. I am essentially missing two import (highlighted in yellow in…
-
about date format
Hi, I'm trying to import date data. I failed importing as date format, so changed to text then succeeded.(below "week date") Next I'm thinking that changes to date format. So I tried using Mid function and Date function, but the value wasn't filled with cell. What should I do or is there good way to import date?? Best…
-
import data into module
HI, I'm trying to import data(below 1) into module(below 2). And mapping are(below 3 4). But result was below 5. Please let me know if there is solution. Best, Regards,
-
Data Integration
In terms of data integration, Anaplan uses pre-built connectors like Snaplogic. How does the data integration take place? Where exactly is Snaplogic placed in the technical architecture -b/w client cloud and Anaplan cloud or Anaplan platform and client cloud?
-
Level 1 Model Building: Geography Hierarchy
Hello! there are no files in Level 1 Model Building: Geography Hierarchy...only discription can you add them? Thanks
-
Creating Combination list from Module with 6 Dimension
Background: We have a module with 6 dimensions including time, we have to make a staging list from this module at combination level to store the previous data. For this we need only non-zeros combinations to be created in the staging list. Limitations: Each line item in the existing module is taking ~10-12 GB space…
-
Excel Add-in v3.2 - Boolean values
Hi all, I am having an issue that seems to be a result of the new v3.2 add-in update. Previously, where boolean values were being pulled from the excel add-in, excel would automatically recognise them as general formatting and they would be activated and process the cell as a boolean. Now it seems the values are being…
-
Export Inquiry
Hi, Hi, I would like to ask if Anaplan has an option to export data in this format? The client requirement is that we can export data in this format so they can load it to another system. I have tried the export definition txt file and it is not the same. Appreciate the assistance Regards,
-
importing data about time
Hi. When I import data and map. I have to unify the time format(like below) or not?(there are Y-M-D and D-M-Y)
-
Anaplan Connect 1.4.2 JDBC export: Could not connect to the database
I'm trying to use the new JDBC export in Anaplan Connect 1.4.2, but I get the error "Could not connect to the database. Retrying in x seconds." I'm using a connection string identical to what I use for JDBC imports, so I know that's solid. Additionally, I am using integrated security, and I do have sqljdbc_auth.dll in the…
-
Informatica Cloud: using Hosted Agent with Anaplan connector
Informatica connectors typically give you the choice between 2 types of runtime options: - one or more secured agent(s) that run(s) on a managed server - a hosted agent managed by Informatica that lives in the cloud The feedback I got from Anaplan was that the Informatica Anaplan connector is only compatible with the…
-
Insert item to dimension via Excel Add in
Good afternoon all, Iv'e just downloaded the Excel Add in V3.2 . I have managed to create a tab based on the view on my module. The module has my numbered list 'expense' as dimension + several line items. The objective of using the Excel Add in would be to enable the user to manage their expense as well as adding new ones.…