-
Can any tell me what is the correct answer to below formulas
-
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
-
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…
-
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…
-
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 %…
-
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:…
-
Are there ways to hide certain line items when end user click drill to transaction?
Hi, I have a query related to drill to transaction. any input will be helpful. I have classic end user dashboard which has information related to employee. Dashboard only contains certain line items from module. but,when end user click on drill to transaction, it went to module and display all line item. I wonder is it…
-
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?
-
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…
-
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…
-
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…
-
Filter on the line with a module which have different dimension
Hi, In a module i have to filter a line with boolean line from another module but both modules have different dimension. in Target module we concatinate 3 attribute, but in source module(where the boolean is) we are using a list with only one attribute. Systen is unable to identify the line. need a formula for filtered…
-
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 *…
-
How to Use DCA to deactivate boolean selection?
Hi Community I have 2 list. List A & List B. I have created one module using list A and there are two line items Product Family (Formated as list B) and Applicable?(Boolean). I have to disbale boolean if I select Appliacble aginst other list item if I select A(Other A should be not accessible) while I can tick boolean of…
-
Cost Optimizer - LPP problem solving for supply chain optimizatino
Do wer have LPP optimizer in Anaplan in built.
-
How to reorder a list automatically?
Hello, How to reorder a list based on a property? I've got some lists that are very long. I'm only able to reorder them via the Order List action using their Display Name provided that the Display Name is a text format. What I've done so far is create a module and get the list's Display Name and sorted the module via the…
-
Setting a Date formatted line item to Blank
I am trying the following. Not sure if the issue is that the Date format items can´t be blank or something on my formula
-
Sync on dashboard
Hello All, Hope everyone is doing good! I have 2 different grids on a dahsboard and both are pointing to a common dimension, however when i select a project in one grid ( top one with one of the dimension being the project ) the bottom grid is not in sync with it ( its not chaning the project ) , I noticed that the bottom…
-
How to fill a line item recursively
Hi! I have one module where one of the line items is my inventory amount and on the columns I have a list where I put diferent fiscal years (note that I cannot use the formula PREVIOUS() because this module is not connected with Time, and I can't connect it either). So my list is composed by: FY22, FY23, FY24, FY25, FY26,…