-
hii
-
How to flag SKUs based on the lowest revenue
Hi, I have a module Target Setting with 3 dimensions: Brand, Category, Time. Users make an % input to indicate how much each combination should increase Revenue for the next Year. Then, the Target SKU Reduction line item is calculated within the same module to inform how many SKUs should be discontinued to meet the target…
-
Show process Id into actions window
it's would be useful to display process Id into actions window (in a dedicated column)
-
Is there a way to reset the List Ids to reorder it correctly?
Hello everyone, I am building a date range filter to allow a use to select weeks and then have it filter to the days belonging to each week. I did this by having a report days being a child of Report weeks and using an Time calc to set up the range. It is working like I want by showing the correct list items. But they are…
-
Time Filters and Time Context Selectors
Hi, My page has a time context selector to filter a report and the user can select half years or full years if they want a full year total. I also have a table of supporting editable data that the user wants to filter by half. It is frustrating for them as they need to select the time from the context selector and then the…
-
Complex GL Account Mapping to Cost Centre for Allocation
Hi Anaplaners, I want to mapp certain GLs to CCs and vice versa. Additionally I want to map certain cost centre to all GL Account and vice versa. Based on the mapping I would input an Allocation % for those mapped GL & CC. The mapping is done on the lowest levels of the hierarchy. It will also have the Parent of the GL…
-
New School Year Brings New Challenges for U.S. Universities
Anticipation is in the air, and perhaps, even a hint of cooler weather that signifies fall is coming. Recent high school graduates are eager to begin their higher education journey, and many continuing students are excited to see their classmates and professors in person after more than a year of online study and to take…
-
Higher Ed: Planning for the Future in a Time of Constant Change
It has now been more than a year since the coronavirus pandemic began wreaking havoc on all segments of U.S. business and society. Some sectors and organizations have learned how to adapt to the vast changes in how we do business and go about our daily lives while we all await a return to some semblance of normalcy.…
-
Transactional APIs - Part 2: Use Cases
Introduction Following use cases will be presented in this section: How to retrieve id for a given dimension/list & list member from its name or code How to retrieve allocated & consumed space for a Workspace & Model Workspace Sizing Use case Model Memory Usage Use case How to retrieve permitted number of Items & Index…
-
Set specific Time Granularity for Gantt Charts in NUX
Hi Team, I bring an easy -but yet a tad annoying- request for you. Issue: It seems like Gantt Charts in the NUX automatically adjust the granularity of the time "dimension" based on the dates in the cells of the source module, as shown below: As a result, the Gantt Charts on your boards may change significantly (what is…
-
pulling data from one module to another for a particular period.
Hello Folks, I have a question regarding pulling data from one module to another for a particular period. Please find the details here: Source Module Lists: Time FY22 - FY25 (Months), Custom versions and Products Target Module Lists: Time FY22 - FY25(Quarters), Custom Versions and Products. The issue here is, I have 8…
-
Summing a line item with a formula summary method
Hi I have a module that is calculating correctly for each line item when I apply the Formula summary method as its based on the dimensions listed in the context selectors. I need to return the sum of this line item (highlighted in yellow) in another module but it obviously returns zero. I am sure I am missing something…
-
New UX: Gantt Chart Filters for Time and Lists
For the New UX, I want to ability to synchronize my rows (which are usually hierarchy lists in the model) so when I select a parent list, I only see the applicable values in my Gantt Chart. In addition, I want the ability to filter my timescale (formatted in the columns based on the Gantt Chart requirements) to the start…
-
New UX Gantt Chart Time Period Issue & Improvement
Hello! * It would be great to add features to the New UX Gantt to* show only weekdays when presenting weekly level roadmap. * format the text style on row and column headers * Issue / defect on "Week 7" as it appears twice
-
Sorting group options - New UX
Did we lose the group sorting option (before/after/start/end) in the new UX [screenshots below] Anyone using any workaround? Classic UX: NEW UX:
-
How do I import only 1 occurrence without errors?
I have a DATA module with a line item named "Scenarios." I need to import this line item into a list also named Scenarios list. The data module is dimensionalized by a different list so I cannot use the isfirstoccurence() formula. What's the best practice when it comes to importing this line item into a list as to not have…
-
Show calculation time directly in model
Would be very beneficial for the model builder to see the calculation time (e.g. from model open) of the individual line items with formulas. The current cell count is a great help when it comes to optimizing the model and identifying how to reduce the size hereof. However, the calculation time of the different line items…
-
How to get Range of Values between two Booleans that are time formatted?
When the user select Two Boolean Check the range is defined so I want to get the range of values respective months.
-
Anaplan Time Range Limitation
I was very surprised recently when I discovered a limitation to Anaplan's permitted time range. It may surprise others to know that Anaplan is limited to supporting only 70 Years (20 past and 50 future) and the maximum number of years possible is 90 (using a time range set, as of writing, to 1981 with 90 periods). I did…
-
Avoiding circular reference using daily workaround to simulate PREVIOUSITEM() function
I'm working on a tops down attrition allocation model. We want to be able to input an annual attrition number and allocate that down to the lowest level (Month, Country, Segment, Attrition Type, and Tenure). Given that attritions have to be whole numbers I've been using MOD() to carry forward the probability of an…
-
How to pull the data from module to list
Is it possible to get the data from module to list? I need to pull the SYS C4.Code to Sales list in order for me to use in lookup for SYS Sales.New Region.
-
Refresh data hub to Spoke model
Hello, I have two lists on my Datahub. On the Spoke Model, I import these lists through a saved view, and on Apps I have a spoke model refresh page that should import me the changes made on the Datahub app. On the Data Hub App: I can add a line to the list and I can delete it. The problem is that when I refresh my spoke…
-
Dashboard to show occupied space by building blocks
Anaplan must have an option to show actual occupied space in MBs by objects e.g. line-items (rolled up by modules), list items, versions etc. This is area which needs extra calcs OR sometimes builders (including SA) struggle to find the reason of actual model size.. A leap in this direction will help the builder community…
-
List to module, most efficient way?
Hi Do anyone know what the best way to link a module to a list is? Cause in our models we keep databases in lists, to be able to keep track of the history. The end useres are uploading a data file, which is then stored in the list, with needed column data saved as properties. My question then goes on what is the best way…
-
I need to add new item to Tree View (General List)
There is no option to enter a name to 4060 item line. Can someone help please?
-
Data in List Properties Clearing Mysteriously
Has anyone ever had mysterious issues with a very large set of Model to Model actions in one big process? We have issue where data is being cleared out of list properties and it's totally mysterious as to why (have double checked 100 things, all the imports, the data sources, the saved views etc. there is literally nothing…
-
Select the level or levels at which the summary can be applied in
When dealing with an extensive hierarchical list and aiming to generate a summary, it would be advantageous to have the flexibility to select the desired summary level (or choose all levels) This flexibility can greatly optimize the process.
-
Community Perspective: Introducing PlanaPY - A Python library for simplified Anaplan API integration
Author: Erik Schau, Senior Business Analyst, The Duckhorn Portfolio. Introduction As data-driven decision-making becomes increasingly essential for businesses, the demand for seamless integration with enterprise planning platforms is on the rise. Anaplan offers powerful APIs for developers to interact with its platform,…
-
Top 25 Anaplan features released in 2023
Author: Misbah Ansari is a Certified Master Anaplanner, Anaplan Community Boss, and CEO/Founder at Miz Logix. Within this fast-pacing world it is important for technologies to move even more faster. Anaplan — being a leader in the Connected Planning world — released a plethora of changes and/or updates in 2023 to almost…
-
link text-formatted line item
Hi All, I have a question from a partner.., Can you please confirm that it is not possible to link to a file destination in Anaplan using a link text-formatted line item. The link text-formatted line-item defaults to http// and the file destination our client uses has a different prefix using backslashes (\\). The links…