-
Can we send email to users who are using gmail using browser .
Hi , My User is not using outlook and they use gmail through browser only .So is there any way we can configure in Anaplan MAILTO function to send email to gmail account . Thanks .
-
Getting a comments (editable text line item) at summarized level
Hi, In a primary module, there are some summary line items (like D = A+B+C) where 'D' is the summary line item. I am using these line items as a line item subset in another secondary module as a list and pivoted as rows. Now the requirement is to enter a comment against each of these summary line item. Could someone please…
-
Timeline Chart Date Range based on Line Items
When you create a Timeline Chart you can set the time range (Axis Start and End Dates) for the display however this can only be entered manually and is not linked to any underlying data. I would like to be able to link this Axis Date Range to date formatted line items in a module in the same way that the bars start and end…
-
How to restrict access on line item which is list format
Hi , I have a module with number list as dimension and Country as line item . I want to restrict access of country to users (Cant use Selective access ) .For example ,one user has access to 2 countries ,then that user should see only 2 countries in drop down and should not see other countries if user from other country has…
-
Getting Invalid error in Logic
IF 'Headcount Capacity 2' 'Seatings.Less than 50 seats' THEN 'S' ELSE IF 'Headcount Capacity 2' 'Seatings.50-200 seats' THEN 'M' ELSE IF 'Headcount Capacity 2' 'Seatings.201 - 500 seats' THEN 'L' ELSE IF 'Headcount Capacity 2' 'Seatings.More than 501 seats' THEN 'XL' ELSE 'Headcount Capacity 2' This is refernce to…
-
IsLastOccurrence
We have Native IsFirstOccurrence functionality which helps us in a number of ways while modelling. I think having IsLastOccurrence will also be equally helpful in Anaplan.
-
Forward Weeks of Cover or Forward Weeks of Supply
Thought I would post this here as a method to calculate Forward Cover or Forward Weeks of Supply. A year ago @AnaplanIdeas posted an idea for this which is great. I'd like to expand on this idea and also incorporate @nathan_rudman backward-looking suggestion. Summary: In the supply chain horizontal you may be asked to…
-
Data Import from excel
How do I import an excel data grid with no unique ID and no unique combination of property? Note: Customer is looking for keeping anaplan as system of records and wish to generate a unique ID within Anaplan, but key thing is it has to be a import/ not insert using dashboard. Thanks Arun
-
Insert Line items – Format settings
The reason behind the ask is because Anaplan is not letting the model builder even to add dummy line items (Divider with None as a format) if the model exceeds the size as it takes the 'number' as default. I hope to resolve this concern, probably Anaplan can let the developer choose the format of the line item before…
-
Anaplan's New User Experience Designed for Optimal Planning
Have you heard? Anaplan’s user experience is evolving. With a laser focus on the customer journey, Anaplan's New User Experience (NUX) is designed to make users’ lives easier by helping their business to run more smoothly and catering to better planning and decision making. The NUX is currently available in the platform.…
-
Time Filter applies to specific month
Hi, I'm trying to create a time filter that will only ever return current month and December 2020. I've managed to create a filter for both using separate line items, struggling to combine and allow users to view. Any suggestions? Thanks.
-
Circular Reference when using a line item as input
I have a formula that needs to look a specific number of months back. The formula works when I type in the number of months as a hard code in the formula, but not when a use an line item containing the number of months. A screenshot is below. The Maturing Balance formula works. The Retained formula is the Maturing Balance…
-
Level 1 Model Building : Margin and Margin % in Rep02 Size Margin Report
Hello, I am reviewing REP02 Size Margin Report and having issues. The Margin and Margin % are not populating. Is there a reason this would be happening. Is it not supposed to populate? I have put in the formulas and the sums properly (see attached image).
-
Custom Time Dimension / Supply Planning on a daily basis
Hi, For a client of us we're looking into setting up a Supply Planning model where planners have the ability to plan with a telescopic view. Meaning they're able to simultaneously plan on a daily & weekly basis. Ideally we would work with the standard time but as weekends can not be taken into account we're looking into…
-
Sum Transactions Based on Properties Between Two Dates (Days, Weeks, Months)
An often requested output of a trade promotions use case is to understand sales between two specific dates— be it days, weeks, or months. The solution below has one dimension in it but would work equally well with additional dimensions, such as customer or supplier. Having loaded in the transaction detail following this…
-
Last Occurence
If line item is list formatted and if list item choosen is repeating , then how to get the last ocurrence of every list item?
-
Dependent dropdown
I have one dimension "Employee" and want to assign two products A and B. Product A and Product B are two line items formatted as Product List. It is perfectly fine if employee is assigned the first product however, when the employee is assigned product B, then product A should not be visible in the dropdown as the employee…
-
Enter Saved View on Saved View Creation/Save
When creating saved views, it would be great if Anaplan enters the saved view immediately after creation. Currently, anaplan returns to the default view of the module. This can be a bit annoying if you need to make a quick change to the view, such as adding a filter or showing/hiding columns.
-
Date Conversion
Hi Guys, I have a simple one to ask. I am loading a Period with a Text format to a Year and Month with a Number format. Example: I loaded a date of Jan 13 to a Period column. Then I need to convert it to Month 1 and Year 2013. I tried loading it as Time period which is the right way but for some reason it is not loading…
-
Variance Analysis between versions without using select
Hi, I am trying to create a variance Analysis for users so they can compare price & volume between to Anaplan versions (i.e Budget & Forecast, Budget & Actuals). This idea is for user to select Version 1 and Version 2 to decide which versions they want to compare. Similar to: Select V1 : XX (i.e Budget) Select V2: YY (i.e…
-
Set default file to everyone
Would be really handy if Anaplan did either one of the following actions for import data sources: * Set the default file type as everyone or; * Permanently saves files regardless of default file type selected. This would really assist in debugging and remapping import files.
-
How to calculate cumulative results
Hi,everyone. I would like to calculate the cumulative result of a line item. I think I should use the TIMESUM function, but I don't understand how to use it. I want to get the cumulative result from the date of FROM to the date of TO. Could you tell me the best solution? Best regards. Taku
-
Dashboard View Error
Hi , we sre all getting this error on some dashboards, and can noit work out how to stop it Any suggestions please? thanks
-
Display the Latest Revision Tag for a Model in the Manage Models Dialogue
When you have multiple versions of a development model it is not easy to see whether the model is up to date without either opening it or trying to run a Compare and Synchronise. It would be helpful to display the last revision tag of any deployed model on the Models dialogue so as to avoid this.
-
Ability to add .txt file to a Revision Tag
I think it would be beneficial to have the ability to upload attachments to a revision tag as supporting information for a development change. It would not need to be any more complicated than uploading a .txt file against each revision tag. Currently, we have the ability to add a title and description for each revision…
-
Blueprint View of Saved View
When a saved view is open, it would be really useful to have the option to open the blueprint and only show the line items in the view, rather than the full blueprint. In modules with a lot of line items, when the view has only a small selection of them, it is time consuming to find the respective line items
-
nth occurrence text function - finds nth time a character occurs in a string
I would like the ability to use a function that allows me to search for the nth time a character or string of characters occurs in a concatenated key. Currently, we import text string keys from source systems and derive business information from these strings. For instance, we might have the transaction key…
-
Anaplan to be supported in Microsoft Edge browser
I hope Anaplan could be supported in MS Edge other than IE 11 or chrome/firefox and safari. We are using edgeand we experience some issues even with just doing data entry on a field with percentage format.
-
QUARTERVALUE Function
Hi team, I've got 2 simple modules with 2 dimensions, Accounts & Time. The source module has the Model Calender with Month as the Time Scale. The target Module has a Custom Time Range with Quarter Totals selected & has Quarters set as the Time Scale. Both Summaries are set to Sum When I reference the source module using…
-
Referencing Batches of Same SKU to calculation QTY of expiring materials
Hi All, I've been racking my brain over this one and I can't think of a good solution. I want to calculate the amount of inventory that will go expired for a given batch of materials, but as we cannot reference another rows easily like I can in Excel, I can't think of a good way to do it. Here are my basic assumptions and…