-
SOS : A modeling question
Hello Everybody , I have two lists in Anaplan , let's name them countries with all the countries in it and a second list called products with all the products that a company have. I want to give the possibilty for the user if he check a country , he will see only the products in his country. So my question how we can do…
-
Summary Calculations With the User List
Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, LOOKUP, ISFIRSTOCCURRENCE, CUMULATE, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK. Lookup First, let’s look…
-
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
-
Clickable Image Links
We would like to put an image on the UX dashboard, which can be clicked on to navigate to a specific link. Is this possible to do?
-
Remove 10 million item limit from the ISFIRSTOCCURRENCE function
Brief description of the idea Remove 10 million item limit from the ISFIRSTOCCURRENCE function Expected benefit/impact Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.
-
Insert multiple Items to a list from UX
Old UX had capability to add multiple items to a list from any published module grid. This capability is missing in new UX. UX only provide option to use Form type action but only allows adding 1 list item at a time.
-
Allowing Documents (pdf, excel, word, ppt) attachments in Anaplan
It will be helpful if there is capability to attach Documents (pdf, excel, word, ppt) in Anaplan. Many planning decisions/inputs need supporting documents as attachments.
-
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
-
New Model Experience: Re-open last closed tab
Often when you are model building or analysing an issue, you close a tab (be it a dashboard or a module) and realise you should have kept it open. Often that then means having to go away and search for the object again. It would be really useful if like on internet browsers like Chrome, you had the option to re-open the…
-
Global Find & Replace
I would like the ability to perform a model wide find and replace of a word. I should have the option to include text boxes, dashboard names, module names, line item names, action names, help text, tool tips, and literally ANYWHERE else in the model this word or string occurs. It should basically behave like Excel's find…
-
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
-
Failed to retrieve field list from the selected data source. Please check your import settings and
Hi I'm received this error and it took a while to work out what it was. In the "Source Models" it was pointing to the wrong environment, this is confusing because I could still see the "Saved Views" to click on, it would bail out straight after that with the error. The complete error is: "Failed to retrieve field list from…
-
Show the last date and time a process was run on a dashboard
We have a process to import live orders, and it takes a little time to import the data, it is used up to 7 staff members, and as they are working from home a great deal they sometimes all run the process one after each other, which can be draining on the system and my mood It can be run 40 times a day and only needs to be…
-
Eliminating Sparsity
Summary: Sparse cells within an Anaplan model are cells that do not contain and are not expected to contain data. The platform still needs to allocate memory space to these cells even though they are not used. The trick is being able to identify and combat these cells in existing models as well as preventing them when…
-
Designing models that scale
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. One of the aspects which determine whether a model will meet the need of the business is how well it can scale. Whether the constraint is balancing numerous concurrent users, or having dimensions with high indices, or both and…
-
Dependent Dropdown Issue
Hi, I have built a dependent dropdown but its not functioning properly. I have a hierarchy which follows the certain order: Entity>Segment>Product Below is my segment hierarchy Below are my line items which are list formatted When I am selecting the top level of Entity, my segment dropdown is showing entity list and on…
-
how to pull values from one module to another module with no common dimension?
I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
-
Sync on Selection - Multiple dimension Cell based
I understand how synchronization on selecting a list on grid works, I am trying to see if I can make it work on multiple dimension. eg, if I have a grid with list on my row as well as column. Is it possible to select a intersection cell and be able to synchronize select both list? Any tricks for that.
-
Model Sparsity - Combination of Dimensions
I have a question about reducing sparsity in a model by using numbered lists to combine a series of dimensions. I am using ledger data that has information by supplier and by department over time. If I create a module that is dimensioned by these I end up with a huge amount of sparsity as most suppliers are just used by 1…
-
Create Demand Export Module and Create a Saved View - DEM04
Let me know, if it is right! Is the time scale right?
-
Please change the layout of blueprint view!
The New UX is great and has drastically improved the end-user experience however, the model builder experience has really lagged behind. Anaplan models should be as easy to build as they are to use. There are some really easy wins to be had that will drastically improve the experience for model builders, in this…
-
Modelling Ideas
Hi All, Is it possible it have a view like this in Anaplan? (Q1-Q4- Time range - how to fit in GAP in the same row). Revenue, GM, OPEX, EBIT will be line items and ASI,PMO,PPT will be list. Please give suggestions on how this can be implemented. Thanks in Advance.
-
Export Action
Hi Members, Can someone please guide me, how can I create an export action? As Export Action is not displaying.
-
2.3.10 Activity: Create Demand Forecast
Can anyone help what's wrong here? Not getting the required values.
-
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest
what Conditional formatting logic to be applied to only highlight highest valued cell and lowest valued cell in a given line item?
-
Anaplan error: Line item not recognized
Dear Community, I encountered an issue during the build of some of our projects and would appreciate further clarification if possible. Brief description of the case: I have two modules, A and B, that contain the same line item names "Adjustment" (module1.Adjustment, module2.Adjustment). When I tried using the same formula…
-
Dynamic Aliases for Line Items (and other objects)
We are currently experiencing considerable product complaints from key stakeholders and project owners that need dynamic aliases, and for them to be dynamic (formula driven). The closest Idea exchange in the community can be found here. Competitor tools like IBM and Oracle, have this capability. An example of a specific…
-
how can we decide the order of data while displaying them in grid in a reporting slide
so if I want to compare line item values for A,B,C,D,E but i select them in order of BCDAE for displaying in grid in the management reporting slide feature of Anaplan. How can that be worked out?
-
Creating QUARTILE function within Anaplan
This is a method of building the Excel “Quartile” function within Anaplan – it requires 11 Line items, requires that the Data dimension has a ‘top level’ value, and uses the RANK function which has an upper limit of 50 million cells. To start, create a module (or use an existing calc module) dimensioned by your base data…
-
How to re-distribute or retain a value that is linked with a product, even product is deleted?
Hi there, I've situation where the Customer wants to keep the Overhead Values associated with a product, even though the product is being deleted from the hierarchy. I think of it as a manual entry for the value to be retained to that it can be re-distributed among the rest of the products or add to the total in the end. I…