Hi, I am trying to build a module which needs to take the cumulated value of a line item from the previous month and reuse it in the current month. This is not circular as the time offset means it is…
Good day to everyone! I am making my first steps in Anaplan environment. Here is my current challenge: I have a Module that consists of a List of Asset ID's (about 5000 records) and 12 Line Items in L…
Hi I need help with the following I need to take a value from a past date if a line item with a list format matches with another one, i Mean for example as you can see in the attached image. I have t…
We are having trouble restricting access for a model builder. Is there any way to restrict access to sensitive data? We have experimented with setting access level to NONE for the specific modules. Ho…
Hi All I currently have a Composite Hierarchy with 3 levels. Cost Centre Division -> Cost Centre Department -> Cost Centre Code I want to insert an additional level in the middle called Cost Centre Gr…
Users have the ability to run an import while using their own documents, but there is no way to run a process with their own document? I have a few modules that need to be populated with data coming f…
I have a simple sources and uses of cash model (in a single module) that reflects different legal entities, each which consists of multiple countries. I have some line items pertaining to intercompany…
A useful trick for showing line item data across more than 1 time period. As you can see from the module grid view, the first line item pulls in 2013 Sales, then the next 2 use the lag formula functio…
Can you please suggest a way to find out maximum value of a line item across time period? So for example My module has 2 dimensions Partner Name and Time. I have to find ma bookings for that partner i…
Hi! I’m trying to use the Breakback function in a LI that’s Formula Scope: Actual. So, my Switchover’s in Jun 14, and I’m in the Fcst Version. It doesn’t do Breakback for Q2, just adds the units that …
Is there a way to may inputs really stick out when a user is looking a module? I would like for people using my dashboards to be see the diffference betweeen calculated fields and inputs i.e. shading,…
I have a module that is products (div, dept, class) x locations (channel, store) x time (week). I have a line item PRD_PARENT. I want to know the parent product at all times. lowest level product list…
Hi, While creating a list i came across parent in the grid view and parent hierarchy that appears in the subset tab of a list. What is the difference between the two? Can I get an example. Thanks.
Hi, I have a line item 'country' based on which my account module is developed. These accounts are mapped to countries. I need to find out the count of accounts from each country. In the sample below,…
Question: Is there a way to retrieve a year-to-date value for the applicable year when our module spans more than 1 reportig year? If we use the "Year To Date Summary" checkbox on the setting tab unde…
Main Idea is to have employee multi choose in module on dashboard by checkboxes. Is there in anaplan possibility to implement this? I created a workaround, (see file as example), but i have to manual …
Hi all. I created subset “Active” for Employees list Then created module Plan Sales, using subset "Active" from Employees List and published to dashboard both Employees list and Module Plan sales to e…
I know how to use the select function to select a time period e.g. SELECT [TIME. 'FY13']. However, I need to split my data by half years. Is there any way of selecting a half year or a group of months…
We are looking for a way to assign decile values to transactions where the order of a measure in a module determines its ranking. We cannot use the RANK() function (without a subset workaround) as the…
Hi, if I refer to a list and receive duplicated rows - is there any way to get rid of them by export or in a module itself? Example: List: Account SalesOrg Segment xx BCS Commercial xx ISS Commercial …
Hi, I was building a Budget Model with a customer of mine who already had a Forecasting model. A lot of Business Rules are different between Forecasting and Budgeting processes, but a lot of them are …
The goal is to create module like it was designed in Excel. List Product has Property Category and many other properties. Module is made up of Product list , Line Items and Time. How can i get desired…
Hi I would like to change subsidiary view to regular columns (so that I can see the data per columns in the module without having to click on the eye).How do I do it technically? Greetings Dorota
Hi, There is no Last Value function in Anaplan (Adaytum had one BiF @Last), thus I have tried to modelize something because I was needied this Last Value feature for a customer of mine. The business n…
