-
Manual Entry for Cells
Hello, I have a question in regards to manual entries in a schedule. I have a schedule below and for the three highlighted line items, users should be able to enter manual entries but they are not. Can anyone provide guidance on how I would go about unlocking these cells for line items so they can be editable?
-
Ragged and Balanced Hierarchy help. Many to Many relationship with Ragged Hierarchy.
Hi Community, I have been reviewing the knowledge around Ragged and Balanced hierarchy. I have a bit of a unique situation and need some help from the Community. Attached is a file that breaks down the flat file I have put together of a relationship between entity-owner. Each entity has an owner. That owner can also be an…
-
Restore model when its in deployed mode
hello team members, I have attached a screenshot where I am getting error to restore my model. I have archived this model and copy archive. Does deployed mode cause any effect?
-
Update Time range in dropdown to start from FY10 instead of FY15
Hello All, I have a "Time Range Question". I have a Schedule below that in the dropdown starts with FY15, but we need it adjusted to start with FY10. Would anyone know how I should go about making that change. Sidenote: In the 2nd screenshot below, our partners included a time range in order to increase the years through…
-
Ability to Add actions like data write, forms and notifications in to Existing System Process
we could combine any of the UX actions with each other and with system processes which help user to run process once instead running running using 2 seperate action button.
-
Time treated as common list on Import Action
Hi, I am loading a CSV into a module that has simple time list at month level – however the import action is treating TIME as a common list rather than allowing to do the specific time mappings as expected. Im sending below the details with all the screeenshots I believe are necessary to help understanding the issue. Here…
-
Export/Import Time Periods
Hi team, I have a situation whereby users have the option to export the data from a module, adjust the relevant cells & then import the same CSV file to the module. There is an issue with 2 line items that have Time Period as the format. When they are exported the format in the CSV is 'MMM-YY' rather than 'MMM YY' & if you…
-
Line Items referenced in Saved Views
Show the list of saved views where the line items are used as filters or are referenced in saved views. This will greatly help in traceability for the model builder.
-
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…
-
Be able to select a default summary type for a model
In the spirit of trying to keep our models size-efficient, we encourage model builders to set the summary type to "none" whenever possible in calculation modules (trying to follow the DISCO method here!). Unfortunately, when a new line item is created, the summary type always defaults to "sum" and it's very easy for model…
-
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…
-
OEG Best Practice: Best practices for module design
Introduction Hopefully, by now you've heard of the D.I.S.C.O. methodology for model and module design, but do you fully understand how to put it into practice? D.I.S.C.O. is part of the wider P.L.A.N.S. standard for Anaplan model building and falls under the L for Logical. D.I.S.C.O. provides a logical structure for one to…
-
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?
-
Hosting YouTube videos on dashboards
Hi Anaplan, It would be great if Anaplan could host youtube (or another provider) videos on dashboards. The use case is for hosting instructional videos/content to guide users. I'm sure there would be many other potential use cases for this too. Thanks, Usman
-
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!
-
L3 User Story 1.4 Steps
I am unclear about the process for creating the modules for User Story(US) 1.4. On the surface this seems to be the exact process for the previous US where we combined Accounts and Product, except now we're combining Accounts and Territories. Where I'm confused is how we process the G3T Territory data. Since a territory…
-
Block line items deletion when used in saved views or actions
As a model builder i need to not be able to delete any line item that is present in a saved view and / or used in an action in connected models. With the growing number of connected models and their imports between models as the connection, any line item deletion, move or renaming can result in breaking the models import…
-
OEG Best Practice: Reduce calculations for better performance
Reducing the number of calculations will lead to quicker calculations and improve performance. However, this doesn’t mean combining all your calculations into fewer line items, as breaking calculations into smaller parts has major benefits for performance. Learn more about this in the Formula structure for performance…
-
Create ABORT button when getting stuck with changes/formula when you made mistake.
When submitting changes to line item, and you know you did mistake. Please let us ABORT calculation by Anaplan. It will save tie and resources when building model.
-
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
-
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…
-
Source Model usecase
I have actions(imports data from different model) mapped to model which was deleted last month.But the action is still running fine without any error and updating target modules. Instead of deleted model we have new model which has same structure as old. In source model I can still see old model name and mapped too column…
-
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?
-
Number of working days in a month
Excel uses the formula function NETWORKINGDAYS to calculate the number of working days in a month How would I do this in Anaplan? Link to an input module?
-
Can a parent and child in a list have the same code?
Hello, Can a parent and child in a list have the same code?
-
How to best design your model to facilitate variance analysis.
I have a requirement to create a model that can facilitate variance analysis like Compare CY Sales, with PY Sales and show % along with doing the same for CY Sales vs Budget. What would be the ideal model design? Should I be create versions or should I create line items for CY, PY and Budget in the module and then…
-
Level 2 Model Builder- Sprint 2 DEM03
In module DEM03 there is a formula to pull forward the historic volumes data from the previous period, I have been able to do this up to the FY20 however beyond this the cells are blank. Below is my working formula which populates the forecast up to the end of FY20. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?'…