-
Percentage format issue
Hello Anaplan Community, I am at the beginning of the training program and have encountered an issue with the percentage formatting while creating several modules in Anaplan. Let me explain : I am importing data from a csv file with bonus percentages by department. In my source file, the value of my bonus % is as a decimal…
-
Transfer the value from one time period to another time period
hey guys Please let me know is there any function for Transfer the value from one time period to another time period Without using offset,post,lag need to transfer the values directly
-
Importing data Into Half Year Columns or cells
Hello, I have a module where I taken time ranges in weeks and Available Aggregation as Half-Year. Now I have a source file with the time range of Half Year (H1 FY20, H2 FY20) (Except half years, I don't have a data in weeks or months in my source file) . In my module my half year values are aggregation of months and weeks.…
-
Converting a list to another list
Hi everyone, I recently discovered something within Anaplan that has made my life a lot easier when uploading data. For reference, I work at a mid-size firm and we have data that comes from our accounting software, and data that comes from our enterprise reporting software. Sometimes the naming conventions of things are…
-
BULK COPY - How to choose the SOURCE member and the TARGET member from a page in the app?
Hello Anaplan Community! Does anyone know how to choose the SOURCE member and the TARGET member from a page in the app? Thanks in advance. #NewFeature #UX #Dashboards #BulkCopy #Data #AnaplanRelease
-
export to S3 using cloudworks failing
I am trying to export data from anaplan to S3. I have set up the connection and it went fine. But the export fails with the message as follows: Your integration failed because of invalid connection. Check your integration setup and try again. Not sure what I am doing wrong here.
-
Code Generation on duplicate information entered by users.
Hey Folks, I am trying to generate code in the module in which user list is already applied, due to request from the team I want if the same information is entered by the user1 and use2 it should update the counter accordingly surpassing the users. for ex. if I have user 1 entered information as "abc" so the generated code…
-
Integrating to Anaplan with Talend
Hi all, Has anyone successfully integrated a Database result to Anaplan using Talend Studio? I've looked all over and cannot find successful examples of querying a db, using that dataset and pushing it to Anaplan without saving it to a file first. My issue is I cannot get the db result into a format that feeds correctly…
-
Will the Order list action works for End users?
Hi, Just want some clarity on the order list action in Anaplan. If I include order list action in any of the process which is being used by the end users will that action works for end users? I heard that the order list action only works for the admin. Can somebody clarify on the same Attached screenshot for reference.
-
Excel Add-In - Labels
Hi, When we export data from Anaplan we have the ability to add 'Labels' to the export. These cannot be added to the view as it would be too complex, but are pulled down for the Export, which is really useful. If we connect using the Excel Add-In can this be replicated. We connect to the view but i cannot see the option to…
-
Anaplan Connect Export to remote server
Hello, I'm trying to run a script to export a file from Anaplan to a remote server. Here is the line: set Operation=-service "https://api.anaplan.com" -auth "https://auth.anaplan.com" -export "myFile.csv" -execute -get "\\myRemoteServer\myFile.csv" But when i run it, it instead tries to find a repository called…
-
Data Integration Micro Lessons
Hi All, I have recently completed Level 3 model building and realized I did not have a background to understand all the data integration lessons that were part of it. I did get most of it but did not really get to appreciate the REST APIs and CA Certifications and the lessons/granularity around them. I wanted to understand…
-
Special characters import problem with Java Spring Batch
Hello, I have a problem when importing data to Anaplan. All the connexions work well, from my database to Anaplan. But when trying to import data with special characters (like "é"), they will be messed up. My database is in UTF-8 and the Anaplan model is too. Do you guys have any idea to where this could come from ? Thanks…
-
Anaplan Connect Error
Hi, im trying to create one anaplan connect script and when im trying to run its getting error . im passing the model id and workspace id as number only not in the string. but i think its takes the value as string. Server files not found: Server-Files not found for Model-ID= (Feign: status 404 reading…
-
circular reference issue
hi, I am facing the below circular reference issue. what can i do to calculate "carried interest"?
-
L2 Conclusion OTH01 import Shipping cost
I am not having any problem during the import process. The import was successful. The problem I am facing is after the import the data that are imported was not imported. I haven't received any errors or failures during the import. I am attaching the screenshots. I am stuck here. I don't know what is missing. Someone…
-
Email Notification : Cloudworks
Hello Experts, I am trying to leverage Cloudworks for automation from one Anaplan model to another Anaplan model and just wondering how can I add email ids of the team how needs to be notified on the status of the scheduled job. Currently I get the notification as I am the owner of the integration process in Cloudworks. ~AB
-
How to add Functions to existing Import and Export buttons
Hello, I am asking for help to add a Time, Version and Department functions to an existing import and export button in a dashboard. Any help would be helpful. TY
-
Duplicate entries - Module to module import
Hi, While carrying out a module to module import, if we do not import zeroes first in the target module, the values tend to sometimes double up if we execute the action twice (even after selecting the "Clear target prior to import" option while creating the action) but sometimes they reflect correctly even after executing…
-
Level2 Sprint3 Import DAT04 Distribution Center Parameters from Datahub
As I had issue loading data from Datahub, I wanted to do a copy paste so as to go on (not a prefect process i acknoledge) but when I want to paste data in the DAT04 distribution center parameters module (in the Suppplychain) I got an error message. It seems the module is on read only. I checked the parameter and as I am on…
-
Level 2 Sprint 1 - 1.5.6.2 Import Data into Historic Volumes Module
Hi Anaplan Masters, I am unable to understand what is wrong in my selection. I tried with other mappings also knowingly that are not correct . attached is the mapping which i consider that is correct but unfortunately I am wrong bcz it shows the error after import. Request you to please help me for this. Regards Abhishek…
-
Cloudwork Query
We have to integrate process in cloudwork with below condition. 1.User select source data and Target data in module have user dimension. 2.Based on user selection run process to load data for source to target for each user. 3.Integration job should run process as many time users have selected source and Target. How to…
-
Excel Add-in Cannot access view
Good afternoon, I have recently downloaded the Anaplan Excel Add-in. I would like to create a view based on my 'development model' (we are using ALM), in order to be able to test the add in. When trying to add a saved view of a module (any module) , the add in shows me the following error: New Connection - Cannot access…
-
Action error only for non administrator users
Good morning, everyone. I have an issue. When I import data from one module to another, anaplan returns an error for non workspace administrator users. The error is:"You are not authorised to update this entity". While the action works for workspace administrator users. Maybe it is because of selective access used in the…
-
Adding a new list of existing model
Hi All, I am adding a new list (dimension) to my existing model. I am able to pull in the actual data from the source system by the new list easily. However I am not sure whats the best way to go about integrating the new list for the forecast planning. Currently - in my forecast planning module, my current forecast data…
-
Issue when importing from one module to another
Hi, I have an issue when importing data from one module to another, and the scenario is the following: I have a source module with "Projects" as dimension, and a target module, also with "Projects" as dimensions. The source module is a "calculator", where you can enter values and factors, which then calculates the final…
-
Anaplan Connect - SFTP
Hello, Just a quick question, does Anaplan Connect support SFTP server or only FTP server? Thanks, Ana
-
Effective Line Items rename during Fiscal Year changes
Hello , For Every Fiscal year development, we used to copy the models and rename the line items in the modules / dashboards from FY21 to FY22 etc. Later it was discussed with the user and renamed CY, CY-1, CY-2 (CY = Current Year), but the users are getting confused with these CY terms. Have anyone tried a different format…
-
Transactional API For Meta Data missing information
I am building a workspace audit model where I want to extract all information about models, modules etc. When extracting the data some fields are only partially populated. For Example: Model Information - The Size is not always populated Module Information - The Module id is not always populated Has anyone else experienced…
-
There has to be a better way. Any ideas?
Hello, While on a rebuilding project with a client, I am ready to delete some modules. Problem is the line items in those modules are used in Formulas and are connected to downstream modules. I know I can reference the specific references in the Blueprint view, and scrolling over to see the Referenced By column. However,…