-
Import of partial list
Hi All, Is there any way i can import a part of list into a model from a huge list from another model?
-
Linking a set date to a specific time range
I spend the last 2 days trying to dynamically linked a specific date (specified by a user) I created a module to have visible the versions, country and initiatives (as my lists) and of course the line cost items and calculate the monthly charge per cost line item per costing type based on the elapse time between start and…
-
API Usage Limits
Does anyone know what the Usage Limits are for the Anaplan APIs? Also, is there any max of concurrent calls for the available APIs?
-
Add a "Close all Other Tabs" option to the right click menu
When building in Anaplan, it is common to find a LOT of tabs open. Currently right-clicking on a tab in Anaplan a user is presented with the "Undock, Close, Close All" options. It would be really helpful to have an option to "Close All Other Tabs", which would close all, except it would leave open the one I currently have…
-
Optimizer on rearranging Applies To for optimal performance
In our current models we have been struggling with performance. 1 big impact is the arranging of applies to. It would be great if we have an optimizer that could determine the optimal Applies to for the performance of a given model. This is based a certain constraints from what i understand 1: Size of given list 2: Arrange…
-
Right-click to Add / Delete line items in a module
Excel's handling of adding / removing rows is very natural feeling. Sure you can go into the ribbon bar and find the button, but that's much slower and breaks one's workflow more easily than simply right-clicking on a row and selecting "Insert" or "Delete" In Anaplan, adding / removing a line item item are ONLY available…
-
Dependent Dropdowns - Many to Many
Is there a way to enable a many-to-many relationship on dependent dropdowns? If so, how do you do this? To provide some context, I have two lists: * Departments * Employees Employees can belong to many departments. (Currently have a module which assigns employees to departments using two dimensions, employees and…
-
Delete multiple items/rows from list.(more than 5000)
Hello Members, I wanted to delete more than 5000 rows(nearly all) from an independent numbered list but at the same time wants to save the list and its properties. If we delete any items/row from the list containing more than 5000 rows, it says to select and delete and by this only one is getting selected and not more than…
-
Advanced Search: Allow use of Boolean Operators etc. in model search
I use the search functionality in Anaplan a lot because otherwise it's difficult to find things. It would be helpful to use operators (like in a google search) to find things. Here's an example: Pretend I have a dashboard named "David's XYZ Extravagant Dashboard - Cost Sheet" When searching, if I miss a single character…
-
Option to allow the system to automatically set the datatype for a line item
It would be really helpful to me when building complex formulas if I could build it up in pieces without creating lots of line items to do so. Ideally I could build it in pieces without getting plagued with "wrong data type" errors. I'd like the option to let the system adjust the datatype for me instead of just rejecting…
-
displaying numbers instead of names
I don't no why it has been changed suddenly , i didn't make any changes. Can you say me what is the problem? @DavidSmith
-
Converting data between line items with different lists
An important factor of Anaplan is transforming data between dimensions of modules and line items. For example, if I wanted to convert my sales amounts, which are currently stored by employee and product, to a summarized level of sales region and product, I’d need to do a conversion to summarize the data assuming sales…
-
Lookup on Parent Elements
Got the idea I'm trying from here: https://community.anaplan.com/t5/Anaplan-Discussions/Lookup-on-Parent-elements/m-p/1478#M2397. But, we needed to change it up a bit as I need it to be user specific but it's not working. I created a very simplified version of what we are trying to do on a larger scale. I started with a…
-
Filter on the basis of selective access
Hi Team, In a module there is a list formatted line item(List is having selective access). Suppose the list has the members L1,L2,L3,L4,L5.... And in the module at list formatted line item records having above list members. I want to filter the data on the basis of selective access. A user having access on L1, L2,L3 can…
-
Sumif quantity between two dates without time dimension
Here is my problem, I have two different modules without timescale or dimension. One module has quantity and dates. Second module has start date and end date and I would like to sumif within the range of the start and end dates. Please guide me if there is a way to solve this.
-
Bespoke 4-4-5 / 4-5-4 Calendar
Hi, My client want to recreate their bespoke calendar in Anaplan. It is two quarters of 5-4-4, followed by one quarter of 4-5-4 and another quarter of 5-4-4. See below: Does anyone know if this is possible or is dummy time the best option here? Many thanks, Matt
-
Input at multiple levels and view the Roll-up
Hey Experts! Well, this is something really 'Out of the Box' ask from one of our requirements. And upon first look, I really think that It's kinda out of scope of anaplan. Here's the ask: So if you have a look at the below snap, we tried to replicate a part of our existing Sales hierarchy : Let's say that in one of our…
-
SELECT Function
Hi, Please see details in the attachment. Regards,
-
Parent Child Mapping Error
Hi, I'm trying to load master data in the system but in the files which I trying to load have erroneous records like one child has multiple parents. So is there any work around in which I can identify those combinations in a staging module for error check in anaplan.
-
Option to insert action before or after
Currently when I create an actions from within the Actions tab I only have the option to add this at the Start or End of the list of actions. It would be very useful to be able to select an existing action and use the 'Before' or 'After' functionality that exists when creating module or lists. This would save a lot of time…
-
When to use Line item VS List ?
Hi Guys Is there an approach you guys use when deciding on line item vs list ? for eg. I am loading three different kinds of volume data Volume type 1 Volume type 2 Volume type 3 Data is loaded by month Option 1 Create a module with 3 line item and time dimension Time Line item Volume type 1 Line item Volume type 2 Line…
-
Importing a spreadsheet into a blueprint view: ability to map to column headers
An awesome function that's so close to being functional is importing a spreadsheet or another module/view into a blueprint view. Right now, unless I'm doing something wrong, I can only map things to Line Item, Code, and Parent. It would be awesome to be able to map everything that's in the Blueprint view column headers and…
-
Apply module defaults for timescales
I would like the option to use the "-" setting for time settings in the module blueprint, as per the Applies to Since I rarely use subsidiary views, if I need to change the time from, say week to month, I then have to apply this change to all line items, whereas using a default would save time
-
Day level calendar setting
Is it possible to have a 'day' level setting in the calendar type. We need to plan at a greater level of time sensitivity than is currently available. At present, we use Anaplan for weekly and monthly - it would be great if we could do the same for daily too.
-
Section 6: Region Goal Set- Projected Goal
This seems to be a reoccurring topic. I also am only returning an answer of 0. My equation is Region Percent * Geo Goal Set.Projected Goal[LOOKUP: Parent]. I have also ensured my Forecast version is current as well.
-
Creating views/"child-modules" with a calculation layer?
I have a master warehouse budget model which has several modules but let's consider the following modules for example: Shipments, Freight Charges, Headcount, Inventory etc. All are inter-linked by formulas and the setup is complete. I now wish to create child warehouse budgets with the entire set of modules as the master…
-
The Truth about Sparsity
In case you missed these from the home page: https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-1/ba-p/44493 https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-2/ba-p/44736 David
-
Formula
Hi Experts, I have a requirement and i am confusing how to resolve this. First Module Row Axis:Product Column Axis:Line Items Second Module Row Axis:Flat Product Column Axis:Line Items Both Product and Flat Product have same members. I am trying to multiply First Module line item * Second Module line item. How to write…
-
Fully connected planning for contact centres
Contact centres regularly use expensive workforce management solutions that are inflexible and difficult to work with. These solutions focus on managing call handler schedules (ie what they're doing at each point in the day) against customer fulfilment (how quickly they're getting to support that customer). These solutions…
-
data import query
Hi @DavidSmith , I had one more query . For instance, A module consists of 6 line items, Is it possible to importing the data into module for each line item separately( as of new set of data into each line item), If possible then importing of data is of same way of uploading.