Recent Discussions

Could you consider introduction of Front-End Dashboard in-cell formulas for calculations like in excel

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…

Hi….I don't see any values in the Forecast Demand. I am struck. Help!! Thanks.

こんにちは。 Workflowでタスクの担当者をモジュールから選択した場合に「完了チェックを有効化」という設定がありますが、ユースケースが分かりません。 階層タスクやグループタスクを使ったワークフローで、モジュール内に完了チェック用のラインアイテムを作り設定を有効にしてみましたが、フロー開始から完了の前後で何も変化がありませんでした。 完了チェックを有効にして、ラインアイテムがtrueになるのはどういったケースでしょうか？

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.…

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…

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…

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 &…

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.…

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’

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.

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

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…

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 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?

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…

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:…

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…

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).

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…

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…

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…

Hi Team, while calling through API for export for integration, if the file size is large, it is divided into chunks of 10MB each (e.g. if the file size is 890 MB, it will be divided into 89 chunks). As a result, we are getting incomplete record on the last row of every chunk and the rest of the records are being stored in…

Hi all, I am currently in the process of completing the Anaplan Way course. However, I encountered an issue with the quiz in Chapter 9: Center of Excellence. Unfortunately, I did not achieve the required score of 80% and am unable to retake the quiz to proceed to the next module. Could you please provide guidance on how I…

Whenever I create a new user account the Time zone is set to GMT, which is the Default time zone. I'd like to be able to configure the Default time zone for my environment to Mountain Time. This would result in new users being automatically configured to Mountain time.

In the Sales Planning model, create a DAT02 PY Revenue to CY module to carry forward the FY19 quarterly actual sales revenue to FY20 quarters For this module, using the LOOKUP function and a Time Settings system module is a more efficient formula than using OFFSET to carry the data forward a year Hello, I am trying to…

This would allow to exclude nested IF-THEN-ELSE constructions.

I have just completed the GTM - Go To Market course, but couldn't see the certification in my profile in Anaplan community. Does anyone know where I can find the certificate? Also I often see people share their Anaplan badges on LinkedIn, how they got the certification image? Do you just take a screenshot and make your own…

I was wondering if it is possible to sort the modules by their cell count in the settings. At the moment there is only the possibility to export the model overview and then sort it in Excel for example. This extra step would be saved by having a built-in sorting function. For me it is important to sort the modules by their…