Data

How I Built It: Data locking and validation within processes
Author: Noah Jackson is a Certified Master Anaplanner and Principal Data and Insights Architect at Anaplan. Hello Anaplan Community! I’m excited to share this ‘How I Built It’ video with you. In this tutorial, I walk you through two types of actions that you can add to your Anaplan processes to improve your data access…
Clear Filer
Hello Community I have a list of BU's which is selective access enabled For example: If user have access to only 2 BU's Is there any possibility to clear data related all BU's Is Possible How it is done? Thankyou in Advance
What is Data Management System that was talked about during Anaplan Kick-off this year?
Time change in integration
Hi, After daylight saving time, we have to change our integration timings as well by 1 hour, or it will automatically change the time. Thanks, Vicky
Data Write Action: Optional input on children items if summary item selected via context
In general, data write action is a great thing, but it would be even more helpful, if the option could be set to behave the following way: When in the page context, a summary item in a hierarchy is selected, that the data write action could also be performed on that level, writing the value in all child elements underneath…
Bulk Copy Years
Hello everyone, I would like to move all the data in my model by a few years (Write all data from 2020 to 2023, 2021 to 2024…). For that I tried using Bulk Copy, but I can only copy individual months there, not entire years (if I select this accordingly, the button is greyed out). This is therefore a problem, as some…
Show process Id into actions window
it's would be useful to display process Id into actions window (in a dedicated column)
I am looking at integeration of Anaplan with SAP
We are looking on creating some utlity or similar to it using open source API's or using Python or R or can be any other tool to intgerate Aanaplan with SAP to make our offer more cost effective and lucrative
Supply Chain Related Functions
Just like we have functions for Financial (COUPDAYBS, COUPDAYSNC, etc) and Call Center Planning (AGENTS,ANSWERTIME, ARRIVALRATE) can we have something similar to support Supply Chain Planning? Like End of Stock, Beginning Inventory, etc based on input parameters?
Data Validation when using Anaplan API
One thing i've found quite challenging when doing API implementations (and at this point i've done well into my 20s of these) is, what is the best way to validate that my API calls are properly working? Specifically - how can I validate that file uploads are pushing in the right data? There are so many different variables…
Cell count copy limits in Anaplan - Cell count requested '178676' exceeds maximum '10000'
Hi Because of cell count copy request limitation below; it would be nice if this can be enhanced to a much bigger number; we can then copy/paste in other systems e.g. Excel.
Comparison with y-1, results from last year
Hello, I'm trying to build a module, where we compare the results with the results of one year earlier. Whey we change the year or date, the columns highlighted in yellow, should automatically show the data from one year earlier. How can I do this? Using a formula?
Do ignored columns (from imported files) take up space from my model?
Hi guys! Do ignored columns (from imported files) take up space from my model? Thank you very much!
As a modelbuilder I would like to use FindItem with a property or line item
I have seen that I am not the only one facing the issue that there is property or lineitem which is neither a code or name of list but it is needed for identification, like a WHERE statement in SQL. Might it be possible to extend the FINDITEM function by an optional parameter to reference a property or lineitem which has…
Can we capture a tenant-based date/time value?
With CloudWorks, we can schedule based on date/time with a selected time zone, but that is not involved in any user-facing functionality. As I am working through the new Workflow training, I realize that the platform is now providing interactions with end-users based on date/time values in a selected time zone. This has me…
2.3.10 Activity: Create Demand Forecast Sprint 2
Hello Everyone I have a logical question to make sure my approach and formula is correct for demand forecast in question on the LEVEL 2 SPRINT 2 activity . As we see, we have to create the baseline forecast for the current FY by importing the historic volumes data to the current FY from previous year FY19 data which we…
Mass export of asset URL's
I have uploaded 200 images to the Assets section, and as the url does not use the image name, I would like to export all 200 URL's and then create a lookup in a list. I can export 1 URL at a time, but 200 may take a while. Would it be possible to allow users / builders to export all the URL's of our assets in one hit?
Exporting all the URL's from assets
I have uploaded 200 images to the Assets section, and as the url does not use the image name! I therefore need to export all 200 URL's and then create a lookup. I can export 1 URL at a time, but 200 may take a while. Can i export all the URL's for the images anywhere?
Drag and Drop functionnality (Line Items - Modules)
Hello It's will be helpful to have the drag and drop functionnality directly on each line item in order to rearrange easily on purpose Regards Patrick
Drag and Drop Actions (Process - Imports - Exports - Others)
Hello It's will be helpful to have drag and drop functionnality in the Actions page in order to rearrange them inside their respective bloc (Process, Import, Export or Other Actions) so it will be easier to group them if need include actions into a process using the drag an drop dunctionality Regards, Patrick
Preview Window before creating Revision Tag (Preview of the result in the target environment)
It would be useful to have a preview window of the results of development done in a model before creating a revision tag (for synchronization). This involves setting up the ALM. This mode exists in the new UX in page builder mode Thank you Patrick
Fix filter selection for different roles
Hi folks, I have a filter that controls the data category (A or B) shows in dashboards (same model), and this filter could be accessed by Full Access users as well as other roles. However, I don't want the choice made by Full access users to affect others. For example, if a Full Access user change the filter from A to B, I…
Time mapping for daily data imports
I am importing data into Anaplan from a csv file. I am used to seeing the following screen for time mapping: However, this particular upload is daily data and I am seeing the following: Am I doing something wrong with the module setup or is this how imports usually look for daily data? Any advice on best practice for daily…
How to deal with 3 dimensions having many to many relationship?
I am having some trouble connecting dimensions because I have a relationship with many-to-many and therefore I can not use LOOKUP as I am used to. I feel like I had some trouble explaining the problem before so I will use some screenshots. I have a model for a book retailer, and my final goal is to determine the…
Process Ignores one of the Action in it
We have one automated process which has five actions in it which clears the list and reload the new items in the hierarchy. When the automated process runs it ignores the last action which reloads the list. Upon checking we found that the Server has the necessary access to run the action and also the source system(i.e.…
Converting Data within module
Hi I have data in below format. I am expecting to create a new module with below dimension and structure. Could you please suggest an efficient way for the same? Thank you
What is the impact if List subset and List are used in same Module.
For example: If a list subset say Pharmacy? which is subset of larger list Stores are together used in sales planning module. Aware that it cannot be used. However keen on knowing what would be the impact.
1.5.8.1 Create Saved View for DAT03 Module
Can someone verify my work. My work is not matching with the guided screenshot; It seems that my Jan column is calculating sums; is my Jan 19 meant to hold a value for this step?
Mapping data from module to module
IF we have data at Parent level in a module then how can we bring the data in a module having dimension at child level and Vice versa.
Bulk API Integration
Hi All, If I upload a file to Anaplan server using Bulk API, can a user manually run the import action from actions page in Anaplan to import the uploaded file into the Anaplan Model, are there any limitations or pre-requisite? For example I understand if I am uploading the file using basic authentication with a user ID…

Data

Discussion List