-
Issue with changing Numbered List in Production to composite hierarchy
Hi everyone, I have a composite list which is set as production List in production model. It has 5 levels of hierarchy the 3 lower levels are numbered list. Due to customer request, changes need to be made to make the list a non-numbered list. I have amended it in the DEV as non numbered list but when synced to PROD it is…
-
Why for same list format line item available options are different in dashboard and NUX ?
I have a list type line item and its filter are Selective Access and Dependent. It is deployed on both tradition dashboard and NUX in same saved view. There are 3 available options(item) can be selected under this line item, and in traditional dashboard all 3 options can be "read" but only one can be selected. In NUX, all…
-
How to create Module for List
I want to migrate DBs to UX pages and in DBs there are Hierarchical DBs so to create UX pages for that Heirarchical list i have to create modules. so my question is when i am going to create module so in list there is one parent item and another one is child Item, i created one module but when i saw there is no info for…
-
Revenue from companies within the same consolidation group are not eliminated properly.
I have an issue with my Anaplan model. Revenue from companies within the same consolidation group are not eliminated properly. Can you help me troubleshoot this issue?
-
Bring a value based on summary method
Hello, I am trying to create a line item where I specify which product was sold the most by each of my sales reps. Rep and Product are lists on my model. I have a module called "Sales history" where I have the sales of each rep for each product. I want to have a module where I can select a rep and the line item (let's call…
-
Need to lookup multiple items from another module
I have a module with PO numbers 1 line per PO, with space for 4 product codes The source list is from a simple PO list, with no details, i can then get the details of shipping etc using a lookup Inbound Stock Transactions.P_Forwarder[LOOKUP: PO] etc But the source data has mutiple lines, one for each product, which i also…
-
In anaplan model testing , Is it possible to do automated testing?
What are the tools we may use to test anaplan ?
-
Previous/Lag Function Not Working
Hi, I have 2 line item and on the other line item I used a Previous() function to try and get the last actuals value to spread it in forecast but it seems to not work, I also tried LAG() and same issue. What could possibly be the issue or is there a workaround on this please? Below is the module, it is dimensioned by 2…
-
level 1 model building
Can someone please help me correct what I am doing wrong. I imported the employee.csv file but not all the columns came over into my model.
-
How to make text rollup's at top level in hierarchy as blank and visible at other levels.
Hi Everyone, I am looking for a solution for text rollup's in summary in hierarchy. I have a model with 4 levels of hierarchy. In a module , I am using L4 Product list as Dimension. There I have added a Text Format Line item called " Client name" with summary as First Non blank. It contains formula to Identify which…
-
Data Import Integration
Hello, I have a question for my understanding on data import integration. When data is being imported from a database, source, etc how does Anaplan remove duplicate data from WS02 and are there any specific requirements on the sequence of data, or does that depend on the organization? How does Anaplan remove duplicate data?
-
Why am i getting this when trying to import to a ticked production data (numbered) list?
"Deployed Mode is enabled for this model. You do not have permission to change structural data." it is ticked production data and i am just importing data to it, only 2 fields. I am the builder and have FULL access to everything I am not changing structure i am importing data
-
How to Read back from a consolidated module
Hi Experts! I have a module A using below dimensions - Sales Territory Quota Mapping list is a list with sequence numbers from P1 to P6000. there are properties like Employee (using list of EmployeeAssignment) and Employee ID in this module. And a module B like below, where I consolidated/summed the numbers by…
-
MailTo Limits in Firefox vs. Chrome
We are using the MAILTO function to generate an email to a BCC-ed list of users of action required in the model. The list of BCC recipients is lengthy (>100 email addresses), and the MAILTO function appears to work in Firefox, but not Chrome (OS = Windows, email client = Outlook). Has anyone run into similar limits? Are…
-
Rolling out orders over multiple time axis
Hey community, I need some advice in modelling. The scenario is that we receive orders, which will be partly shipped with some delay over up to 12 month. Each shipment needs up to 12 Month to be delivered. So we implemented the following: Plan monthly order volume Plan the shipment delay in relation to the order month as %…
-
How can I restrict users selection of months
How can I restrict month selection drom a dropdown? For example I would like to set a dashboard where end users can only select pre-defined months i.e. Jan 23 to Mar 23. Is there a way I can easily change this by adding (locking/unlocking option) additional months if needed. Thanks!
-
How does using DCA impact model performance?
I am working on a solution where usage of DCA might come in handy for a clean end user experience. For eg: In an input grid, there are two mandatory fields that needs to be populated before the end user can tick a boolean and run an action. OPTION 1: Using a DCA to enable or disable the boolean based on whether the input…
-
Can any tell me what is the correct answer to below formulas
-
Not Understanding Results of SELECT formula. Line Item for All List Items Set to TRUE.
Hi everyone, thanks in advance for any help! I have attached a image showing a replica of the list/module that I am working with that shows fake data. I came across an existing module in our build, I am having trouble understanding what is actually happening when one of the booleans under the "Include" line item is…
-
How to get access to Anaplan workspace to create modules to practice?
-
Filter transactional data based on user selective access?
Hi I have a module with a sales order list with multiple properties (business unit, item, cost, quantity, …). This list spans multiple countries. I'm looking for a solution to limit what account managers see based on the selective access they have been given. I have enabled this in the 'business unit' list which is one of…
-
Production capacity per month
Hi all, How can I use the Time dimension in Anaplan to calculate my factory's production capacity for a given month, taking into account the different number of shifts worked on weekdays versus weekends? I want to calculate the production capacity as follows: Production capacity = (Number of working days in the month *…
-
To use Lookup in a Flatlist
Hi All, I have a scenario, as follows: Module 1 : To get Headcount in this module Dimensions: L6 hierarchy, L6 Flat List(same hierarchy as a flat list), Cost Centre Line Item: HeadCount Time by month Module 2: Dimensions: L6 Hierarchy, Grade, Contract Type Line ITem: HeadCount Time by month I wanted to get the headcount in…
-
Working Days Calculation
Hi, I have been using the long formula for working days suggested in the Anaplan help, and it's been giving me some issues, so I created a new one It's shorter and easier to follow and thought I would share You need 5 fields* *Holidays is optional and can be removed example of calcs Hope it helps Kev
-
Dimension order within aggregation square brackets in a formula
Hello there, Out of curiosity, does the order of dimensions within square brackets (aggregation functions) have a significant impact on performance? Is it better if they follow the order in the "Applies To" section (and if so, where does Time fit into this) or does it not matter? e.g. Sales Volume = Quanitity Sold[SUM:…
-
Composite List Hierarchy not syncing to production
Hi Everyone, I am having an issue syncing a composite hierarchy from development to production. Below is the list hierarchy structure example:- GL1 Level1(structural list) GL2 Level2 (structural list) GL3 Level3 (numbered list) GL4 Level4 (numbered list) After syncing to PROD the lists items does not sync. Please does…
-
Anaplan Performance Issue
Hi All, I am facing issue in terms of Anaplan Model Performance. In my model I have a Filter Criteria Module which allows user to filter the dataset in a particular module based on the users selection. Dimensions in Filter criteria module is Z-User which allows me to provide selective access to the particular module. If I…
-
Hide one dimension in a column when there are 2 dimensions
Hi everyone, Anyone knows if it is possible to hide the time dimension without taking it out of a certain module? In this specific case I want hide the years (FY20 and FY21) but still have time as a dimension. My final objective is to have this table on a dashboard without the year indication on the columns. Just for…
-
Revision Tag: Roles -> Actions
Hello, I have a quick question in regards to revision tags. If I were check the box to grant a user access in "Roles → Actions" in DEV, would that require or qualify to use a Revision Tag in order for it to sync to PROD? Or what would be the best way to update the change, so it reflects in PROD?
-
How can we import data from one version to another version in a same module?
I have custom version list having Version 1 , Version 2 …. etc. I have a system module dimension with version list and fron there I am checking the Boolean "Copy From?" and "Copy To" based on the selection I want to import from version 1 to version 2 or vice versa. I have created the saved views but facing problem in…