-
% Total in FY/Q
Hi All, User wants to input the % in months, I did not enter q1 months%. from Q2- Q4 I have entered 1% each month. I'm finding issues in summary. Q1 should be 0%, Q2, Q3, Q4 should be 1 %. FY24 total should be 3%. How to achieve this solution? I tried all the summary methods , not working out. Can help to share the thought…
-
Does anyone has sample Anaplan Batch Script for importing timestamp value in anaplan?
-
Anaplan Integration Sript Generator
Hello, I have just recently heard about an Anaplan Integration Script Generator which really looks like a game changer. Does anybody know how to access it? I can't seem to find it anywhere. Many thanks, Luca
-
Snapshot
Hi, I have a scenario where I have to take a snapshot every week(forecast periods) -max 6 weeks forecast period. Source Module -Standard Time Scale, Article List, LineItem(which I want to take a snapshot) Target Module- Standard Time Scale, Weekly snapshot LIST(Contains list member of Lag 1, Lag 2, Lag3..6), Article List,…
-
Workflow: Can we use Import Actions with Source Type = File ?
Dear Community, we are struggling with a topic and would be glad about some help. We want to create a Workflow that starts with an Import Action that requires the User Upload of a CSV file. The user has to deliver a lot of data on various planning dimensions, which is why manual entry of data is no option. Data is coming…
-
How do I know the source of an import action?
For an import action, we can easily tell which modules / list the target will be. But how do we know which source is it taking from? I can't seem to find it easily available in the action tab. Thanks!
-
Can we use Anaplan for capturing everyday expense Actuals and estimate
Can we use Anaplan for capturing everyday expense actuals and estimate, to be updated by multiple users and used on a daily basis. Will the System get hung after a point in time , since we are using daily data instead of monthly or quarterly. How good is Anaplan with handling daily data.
-
how to complete anaplan way?
-
Anaplan Connect SQL - Cannot Connect to Database
We receive the below error when trying to connect to the SQL database. Anaplan API: Could not connect to database! (SQL server: Login failed for user) However, our test odbc connection on the server connects successfully, so the credentials are valid. What do we need to do to resolve this and connect successfully? Below is…
-
Excel Add In - limited by licence type?
Hi all - hoping for some guidance here… I'm looking to roll out the use of Anaplan Excel Add In's so people can retrieve information from the data hub without having any write access. I was wondering if this is possible with the "Limited Finance Contributor" licence, or if they would need to have a "Professional User"…
-
Inquiry Regarding Zero Chunk Count in Anaplan Integration API V2 Downloads
I am currently working with the Anaplan Integration API V2 to download a list of files and obtain their corresponding file IDs. In previous downloads, the chunk count for the files was correctly indicated. However, I have noticed that the chunk count for the same files now shows as zero, despite no changes being made to…
-
How to Split A Parent with Many Child List Members?
Hello All, I have a parent list with 135 child list members, and we want to split the child sites into two group with half with the current parent and the remaining half with a new dummy parent. We are not able to split them in the data source, so it will continue to be loaded under the current parent item. Instead of a…
-
Anaplan Integration with Alteryx
I'm currently experiencing an issue with a new Alteryx to Anaplan connector. I've setup the import and mapping process similar to how we map for Anaplan Connect. I create the imports manually, map the file as "Admins Only" and then add it to a process. On the Alteryx side I reference the process name as a part of the…
-
Anaplan Connect : SSL handshake error
Anaplan API: Basic Authentication failed! (Retryable: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target executing POST https://auth.anaplan.com/token/authenticate (SSL handshake:…
-
Can Anaplan models be accessed via tabs in salesforce?
-
Make REST API Calls From within Anaplan
Hello all, I was wondering for whether it is possible to make rest api calls to another service (say servA) from within anaplan. The other service servA will of course then make some work and then maybe make a rest api call on anaplan back. I understand by reading some other posts regarding REST, that it is possible to…
-
7.2.3 Activity: Import Data into Employee Details Module
I can't see the Target items, please help me.
-
Hyper connect
How can we download Anaplan Hyper connect from informatica website?
-
Scheduled Process not Working when Scheduled, but does work when manually run
We are having an issue with an action/process not updating when it runs as scheduled that I am hoping to get some assistance on fixing. This process runs overnight every night and is designed to store a snapshot of the weekly lag 0 forecast. The source is a Saved View with a time filter of current week to end month 3 so it…
-
Selecting Authentication for Anaplan Connect
Hi All, I am testing Anaplan Connect. I used the script builder to build me a script. However, when I went to run it I got the following error: unable to find valid certification path to requested target executing POST https://auth.anaplan.com/token/authenticate (SSL handshake: sun.security.validator.ValidatorException:…
-
Anaplan add list API timeout.
Currently we are running an integration which we are inserting values into list through Mulesoft. However sporadically through out the day, we would get time out errors inserting into Anaplan. If we are inserting batches of 500+ records from the API, Anaplan endpoint seems to either timeout or extremely slow. This has been…
-
Can't add new CloudWorks Connection
I'm working with a new client, and I can see CloudWorks, but whenever I click the drop-down menu to connect to a service, it appears empty. I assumed it wasn't a permissions thing because I can access the UI. Anyone seen this before/
-
Is it safe to roll back model for calendar update?
Hi all, Did anyone do a roll back for model calendar change and encountered any loose of data /issues when syncing later revision normally to PROD? Time is structured in the model : weekly(4-4-5 , 4-5-4, 5-4-4), 1 past year, 2 future years and 2 time ranges( current +2 and +3 years) . Of course previous year will be lost ,…
-
Response from adding item to a list. Success but not added or ignored
I'm calling the API to insert an item into the list. { "items": [ { "code": "test", "properties": { "Display Name": "test", "Time/Date Stamp": "2023-10-27 13:19:19", "Amount": "Data Unavailable" } } ]} I'm getting a response back that show it has not been added or ignored. { "added": 0, "ignored": 0, "total": 1, "meta": {…
-
Level 2 - Conclusion: Export data from INV01
I am currently working on the Conclusion for Level 2. When preparing the export saved view for INV01 Beginning Inventory, I noticed I have significantly different numbers in my module as compared to the example .csv and the screenshot from the course. I am wondering if there is something obvious I am missing, or if I need…
-
Invalid Parent when Importing into List
Hi! I have this list called Strategic Customer. I have a module based off this list called Strategic Customer Details. the parent hierarchy of this list is Strategic Account Owners. In the module, I have a line item to choose a different Strategic Account Owner for a Strategic Customer. The choose new SAM line item is…
-
getting Error while importing a large file which was successfully uploaded few days ago.
Hi Anaplanners, I am getting error while running a import action by uploading a large size file. The same file was successfully uploaded with the same action 3 weeks ago. I have tried all the ways:- tried after by clearing cache and cookies tried to make new import action with the same file. restarted my system and…
-
Embed python into looker
Is there a natural way to wrap Python code to display in Looker? The ideal dataflow for my problem is SQL DB->python-> looker, or alternatively, looker->python-> looker. I am hoping to embed a.py into lookML so that I can automate python analysis, ready to display in looker.
-
2.3.10 Activity: Create Demand Forecast
Hi, I am stuck with creating formula for Baseline forecast, I have used formula "IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' But it only seem to work for FY20, I dont see data for FY21. Can somebody…
-
Pushing data from SQL to Data Hub via ADF
Hi all, I am currently creating an environment in ADF to push data from SQL to an Anaplan module which in our current toolset (Informatica) works perfectly via the Anaplan API connector but not so much via ADF having had to do the work manually given there is no connector. Has anyone here done this and if so, do you have…