-
Get the Duplicate records based on different combination checks in a module
I have a scenario where I need to highlight the duplicate records based on different line items combination check. Below is the use case. I have a module with District and Territory combination code list. Then I have line items to populate Territory, District, Country and Category names. I want now to create a Check…
-
Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
Hi.. for some reason I don't think Beginning Inventory is pullin the correct data from DAT01.Beginning Inventory. Same case for Forecast Demand line item. I used the formula "IF NOT Override? THEN Initial Demand Forecast ELSE Override Forecast" for Final Forecast line item in DEM03 Demand Forecast( and "DEM03 Demand…
-
Anaplan equivalent of the "Product" Function
I would like to use a formula that calculates the product of a series of items.
-
Workspace
Hi Community, Anyone have idea about 90 days free workspace. I mean what about after 90 days. Is it chargeable or it will discontinues after 90 days
-
Anaplan Image Library - Image not showing for Virtual Desktop Users
Hi Anaplanners, I'm having an issue where images in the Anaplan Image Library won't show for virtual desktop users (services like Citrix). Are there any workarounds? Is this a known issue? Thanks in advance!
-
FINDITEM on Numbered List Without Code
Is it possible to do a FINDITEM on a numbered list without using the code field? The numbered list restriction exists because I need non-admin end users to easily add to the list (e.g. by adding a 'Create' action). The code restriction exists because non-admin end users will be adding to the list, and hence will not be…
-
Add Change in Model Size to Comparison Reports
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Currently, the process for documenting model size must be done manually. While this is a simple enough task, it would be much easier…
-
Introduction of Dashboard in-cell formula calculations
Could you consider introduction of Front-End Dashboard in-cell formulas for calculations like in excel
-
FINDITEM on numbered list ( display name )
Hello, this is my problem. I import a file in my STG03 module, dimensioned by the STG03 contrat list. This list has a property "Tiers" which contains the tiers names, in TEXT. I also have a Tiers module, dimensioned by a Tiers numbered list with code, and display name which are the tiers names. I want to turn the TEXT line…
-
Level 2 Sprint 3 3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
Hi….I don't see any values in the Forecast Demand. I am struck. Help!! Thanks.
-
【質問】Workflowの「完了チェックを有効化」の機能について
こんにちは。 Workflowでタスクの担当者をモジュールから選択した場合に「完了チェックを有効化」という設定がありますが、ユースケースが分かりません。 階層タスクやグループタスクを使ったワークフローで、モジュール内に完了チェック用のラインアイテムを作り設定を有効にしてみましたが、フロー開始から完了の前後で何も変化がありませんでした。 完了チェックを有効にして、ラインアイテムがtrueになるのはどういったケースでしょうか？
-
Today() Function
I'm wondering why in Anaplan we can only have to input current period in Time. As we're using Anaplan as Supply Chain planification tools and we work really at planning on days level. So it's necessary for us to determine "today"'s date. The solution we use now is to launch an automatic import and update the "Today" item.…
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hello, I am working on this exercise, and I am stuck. This is the view I have and I am trying to do the following. The UX page should include: Region, Product Family, and Time context selectors. Stock Exception count by Country and Region at monthly, half-year, and year time periods. Stock Exception count by Product Family…
-
How to Add Child members(More than one member in one go) based on User input
I am working on a use case where basis on input from user, child list will have required number of list items. For E.g.- User Input =3, 3 entries are created under L2. I am able to add multiple rows in one go using below logic. But stuck in a scenario, where we have existing list member already added & want to add more…
-
Does having multiple models in a single workspace (standard or hypermodel) affects performance?
Hi All, I have a query where currently we have 3 models in 3 different workspaces(standard). In all the 3 models we have intergrations running at different times(5-6 times a day for each model) to update Actuals/Forecast from other sources. We are looking into getting a hypermodel workspace for future enhancements &…
-
How can I allow users to override a filter and display selected accounts in an input module?
I have a module where users need to input data for accounts. Currently, I hide accounts without any values using a filter. However, I want to allow users to select specific accounts in a side module, and this selection should override the filter for those accounts, making them appear in the input module for data entry.…
-
REQUEST: Allow a Line Item to have a new, UX-only, name when using it in a Graph.
It would be lovely to be able to give a Line Item a new, UX-only, name when using it in a Graph. The same way we can rename a Line Item on a Field Card. I could see this rename ability either in the ‘Series’ section where you can recolor the column OR in ‘View Designer’ under ‘Reorder’
-
Rename Line items - NUX
We need the ability to rename the line items within the New UX pages. At the present time the only way to rename the line items through the source module.
-
How to calculate project end month & project start month based on data.
Hi, I am trying to calculate last month & start month basis on DAT01 TestData. For E.g.: For list Item A: Start Month should be Nov 24 & end month as last data value. Source Module:DAT01 TestData Target Module: CAL01 Start & End Month
-
Use Generative AI to summarise commentary from bottom of hierarchy upwards to top of hierarchy
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Different roles enter and consume "contextual" data (commentary) at different levels of a product / customer hierarchy. It is the…
-
Snowflake Integration : Anaplan Connect with Private key
Hi All Anaplan connect is unable to extract private key while making a JDBC connection to snowflake. Error says “Try setting the JVM argument: -Dnet.snowflake.jdbc.enableBouncyCastle=TRUE” I believe I am using the supported version of Java (v8) & the latest version of Anaplan connect(4.2.1). I have converted.p8 to .pem…
-
How to create multiple actions with same source type and source target type?
How to create two actions with same source object type and target object type without creating new saved view and the two actions has a different mapping in line items?
-
Using List Properties
Hi All, Why is it best practice to avoid using list properties? As a central location to hold all the data relevant to that list that does not require the user to update it seems like a perfect option. I am referring to properties such as all items of the hierarchy and permanent mappings that will never change. My question…
-
Saved view different in Dev & Deployed - same revision tag
Hello model builders! I'm running into something I don't understand; it appears to be a bug though I'm not sure. We've got a specific saved view that does not match between our dev. & prod. models. I've tried to override the saved view, then pushed a new revision tag (it contained no changes). Dev. Model Saved View:…
-
I need to change Model Calendar Time settings 4 4 5 Structure.
Currently the system is allowing me to use Last Sunday near to the end of month. Ideally my requirement is I need third Sunday / Second Last Sunday near to the end of the month. For Ex: 28th Oct 2024 to 26th Oct 2025, is Current fiscal year which came because of the the end of fiscal year selection - Last Sunday near to…
-
Introduce scrollbar arrows
Can you please introduce scroll Arrows at the ends of the vertical and horizontal scrollbars for easier navigation across the dashboards (in similar to excel style).
-
Text Concatenation | Model Optimization Team series
Hello! Welcome to the Model Optimization team's monthly blog post. This is an eight-part series, following the topics we see occurring most frequently in slow customer models. Our aim is to inform and guide how to build with best practice intentions for these model building topics. Each month, two of our analysts will take…
-
Managing number formatting between countries
Hi everyone, I'm looking for advice on how to dynamically change number formatting in both the Anaplan model and UX based on the region or country. We have a development model that will be deployed across two countries, but they use different formats for decimals and thousands separators. For example: Canada uses a comma…
-
Number Formatting Precision / Stop dividing by 1000
I would like to propose a feature to instead of dividing by 1,000 to show items in thousands or 1,000,000 to show numbers in millions, that this is handled by the number formatting. This is a little used feature in excel where you can apply a format to a cell with the value $32,500 to display as $32.5. In this case the…
-
What is the typical Workspace size for a medium size Anaplan project not complex and not simple?