Data

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?
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
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
Show process Id into actions window
it's would be useful to display process Id into actions window (in a dedicated column)
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…
Can Data Hub hold formula related data? or just the spoke model is supposed to that?
Upload Image for NUX
Anaplan don't allow to upload images but there is the possibility to show them only with the use of links. This can indeed streamline the App but it can generate some problems where some clients have restrict web access in regards to websites that are visitable. It would be great to have the chance to upload image and -why…
How I Built It: Data validation
Author: Matt Liffmann, Certified Master Anaplanner and Senior Solution Architect at Deloitte Consulting. Hi Anaplanners! My name is Matt Liffmann, and I’m a Senior Solution Architect at Deloitte Consulting. Today I’m excited to share a ‘How I Built It’ tutorial on data validation. Data validation in an upfront Data Hub is…
What is the process for viewing a workspace map like a model map in Anaplan?
Hello, I'm attempting to figure out how to examine workspace maps, similar to Model maps. It will be useful for us to keep track of the dataflow between models. Is there anything we have for Anaplan? TIA
Displaying an Incorrect Version of Data
Hi All, I just would like to check if anyone experienced the issue wherein affected users are viewing an incorrect data (ie. Actual was selected as version on context selector however, the report in Apps shows Budget data). I tried to replicate the issue by giving the same role permission on my account as affected users…
How to import Negative Values from txt files
Hi All, I am importing data from tab separated txt files and I noticed wherever the values are negative, its populating as positive numbers in Anaplan. As shown in above example the negative values are denoted by a negative sign after the number in the txt file. Is this format supported by Anaplan? Thanks in advance
Data Alignment on Columns in UX Grids
Hi, it would be very useful and nice to have the possibility onto the UX Tools for Format Settings to aligh the Data inside the cells on the right, centre or left. In this momenti this functionality is possibile only for Column Headers and Row Headers, but not for Data. Thank you.
How can I restrict users selection of months
How can I restrict month selection drom a dropdown? For example I would like to set a dashboard where end users can only select pre-defined months i.e. Jan 23 to Mar 23. Is there a way I can easily change this by adding (locking/unlocking option) additional months if needed. Thanks!
Compare numbers in different modules
Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…
Model Builders and Solution Architects: We want to connect with you!
Are you a Model Builder or a Solution Architect who works to create a set of rules and validations for data in Anaplan? If so, we want to speak with you! We invite you to join us for a 60-minute remote research interview, during which you'll be asked to weigh in on a new way of creating rules and validations in Anaplan.…

Data

Discussion List