-
Tooltip for Cells
Hi Team, Is there anyway to create Tooltips for individual cells? I know you can create them for a module but I require more detail @Hayk I saw that you requested this in the Idea Exchange & also you mentioned a workaround involving involving a formula which displays in the drill down window....any chance you could explain…
-
Issue in fetching data from one module to another
Hey Everyone, I am facing a problem while taking datas from one module to another module. I have to Fetch data from detailed level to aggregated level. My Source File is containing more detailed data and my Target module is supposed to have the aggregated data from source. As my target and source file is containing almost…
-
Retrieve user details when Importing to list
Hi, I have a module where the user populate a few line items with information, which is then imported into a list and used further on in the model. However, now the client wants to include a column (line item) where they can see who made the new "transaction", that is, the user that is logged into Anaplan. So my question…
-
List Item Limit Reached
Hi everyone. Sorry to drag this topic back up to the top but I encountered a rather strange issue today. My standard list hit 1B list item record limit even though there's only 12 million list items. So I checked all my standard lists and saw that the record limit is growing on all of them after each import. Did I…
-
Option to Tie Time Range to Current Period
In an effort to reduce sparsity and improve in every aspect of "PLANS" from the planual, having the ability to attach time ranges to the model's current period would help in so many ways. As an example, in a model set as a "Calendar Months/Quaters/Years" Calendar Type, adding time Ranges that are Current Year, Current Year…
-
Minimum value through out a 12w period of time
Hi! Hope that you all are doing fine with this crisis! I have a line item that, for each reference, calculates the balance between need and stock for each week. I would like to create another line item, without the time dimension, that gives me the worst situation in the next 12 wks for each reference and (another line…
-
Dynamic reporting for weekly and monthly
Hi All, I need a suggestion on below requirement. I want to create a P&L report where by current month data should be shown at a weekly level for current month and show the month total and the remaining months in R12 will be planned at a monthly level Can this be possible in a single grid(single module), to publish as a…
-
"ask every time"
HI All, I have an action that exports data into a specific format. Is there a way of getting the action to dynamically link to the version selected or do you need to record an action for each version? (also specifically asking for an APP on the UI as that seems to default to the one selected at the time of setting up the…
-
Optimal Design
Hi All, I have the excel files which has to be uploaded in Anaplan at each quarter levels so we are uploading this file four times in an year, each file contains many columns which are lists in Anaplan. There are about 12 Lists (columns in file) and the each file has nearly 40K records. I have created an Input module with…
-
Compare Descendent Row Data
What's the recommended function/formula combination to compare the Period and Final Amount data in order to identify duplicates? Note: The items being compared are in a composite list and share a parent. I would only want to compare items that roll-up to the same parent. In this example I want to flag any rows with the…
-
Unable to Change the Summary of Line Item from Sum to Formula: Time, Sum
Hello, I'm getting an error when changing a line item's summary from "Sum to Formula: Time, Sum": "Invalid combination for line item 'Sales' of summary method 'Formula' with formula using LOOKUP and/or SUM (or other summary function)" The formula of the line item does indeed have a Sum function, and I'm getting it from…
-
Option to open Settings Menu Items as Tabs
In our model, we have 220+ dashboards and 400+ modules. When going between looking the list of modules and the list of dashboards, the lists reset my view at the top, causing me find the one I wanted to look at again, this can be very time consuming. Ideally I'd be able to open these Settings Menu items as tabs, so that…
-
lookup not working
Hi, Can anyone please explain why the below formula is not pulling any data? I wanted to fetch the details into LoS from SYS13 using LoS(numbers) as driver LoS >> Line Item List(Length of service) I tried converting the LoS(Numbers) into Text & tried vlookup again but it didn't fetch any details Thanks
-
User Role Notes
It would be helpful to have a Notes function in Users Roles to be able to describe the workgroups typically using that role. Especially with new UX pages now crossing multiple models additional roles are needed to facilitate the cross-model access.
-
Level 2 Sprint 4 Conclusion - Importing DEM04 to DAT02
Hi Team, @einas.ibrahim I am facing difficulty while importing DEM04 saved view demand data in SC into DAT02 volumes data in FPA. I am not getting data in SKU, LOCATION CODE as can be seen in the IMPORT01 file. Also, my Demand numbers are coming up as weird numbers. Is that because I choose SUM as a summary method in…
-
Anaplan HyperModel
Hi All, If we have multiple workspaces which we want to put in HyperModel and want to allocate the space from some WS to others, then is this possible? - Is there any limit on increasing one WS in the Hypermodel? Thanks
-
Level 2 Sprint 3 - 'Inventory Ordering Modules'
Hi, I believe I have completed the Inventory Ordering Modules section, but I'm not 100% confident with all my formulas. Below is an example of what my outcome is when I do an override suggested order amount in week 1, along with a shipping method override. Does my outcome look correct? If you need to see the thinking…
-
Level 2 Sprint 2 DEM03 Growth Rate % line Item
Hey there, Anaplanners! I am on Level 2, Sprint 2 and am having difficulty with the Growth % line item in DEM03. Growth Rate % line item With this line item, build a formula to pull the Volume Growth Rate % from the DEM02 Volume Growth Rate by Weeks module. I understand that I need to look up the SKU to get the Parent…
-
Is color coding General list name possible?
Hi We have a bunch of general lists in use out of which few need data input from users , from time to time. Just to highlight those lists, is it possible to highlight their name in color for the benefit of the users? If that is not possible, then can we group those lists separately within the General list ? Thanks Regards…
-
Data split possibility while loading into Data hub based on region or company code?
Team , We have integrated multiple data objects from SAP to anaplan data hub for one region . We have set up filters and parameters in our middleware system(CPI) to filter data for the region and the data loads into data hub . Now in order to integrate the same data objects for another region i would like to use the CPI…
-
How to sum checbox checked?
Hi All, I have maybe a simple doubt, how do it sum the checked options ? I need to have one line item showing : 3 Regards, Julio Baudino
-
Last Occurrence Type question
Hi there, I am looking to get the latest product code based on two identifiers, one is called BVFSKU and the other is Vintage: Module one is called Latest FERT - module to pull the data in to and based on the BVFSKU list Module two is called Masterdata - module containing all of the data needed and based on a list called…
-
Model Map - Show Filters dependencies
As a Model Builder, I need to see the dependencies between calculation, input or reprting modules and filters modules when filters are used. The same could be useful for DCA as well ideally with different colours than the calculations and with the possibility to display / hide those links I need this because : - Anaplan…
-
1
1
-
Level 3 Sprint 3 DAT04 Import issues
Hello I'm having issues importing data into the the DAT04 module form the spoke model (Data Hub). I raised a question about a similar issue i was having in Sprint 2 and got it to work but now I'm having the same issues for the second import at the start of Sprint 3! Can anyone confirm where I'm going wrong?... Thanks
-
Inventory plan in weeks - can I add more weeks?
Hi there! In my demand planning model I've got the intake plan in weeks that is currently showing weeks from week 31 to week 3/2021. Can I somehow let Anaplan show more weeks than until week 3/2021? I'm a beginner and I don't have a lot of experience with Anaplan yet. I took this model over and unfortunately I don't…
-
Default subset setting
Suggest to add ability for model builder to change the default setting for list subsets. I.e. add option to select whether a subset setting should be true or false for any new list items added. This will make it easier and more flexible to work with subsets, and help avoid having to create a dummy module and action to…
-
Level 2 Model builder Sprint 1- SYS05 Region Details module:
Hi, while creating this I found out that we have to use PARENT formula to reference the data. I have been trying it but no success. Can anyone help me? Thank You, Sweta
-
Fetching information from module in Anaplan
Hi All, I have a contract master module dimensioned by Contract. Each contract based on Vendor, Customer, Brand. I do not want make these 3 as dimensions as it would be a big sized module. In the target module, which is dimensioned by Customer --> the user should select Org 2, Brand details and End Date for the contract…
-
Level 2 SYS06 Import
Hello. I am having trouble importing the country data. I have tried multiple times to no avail. Any assistance would be appreciated.