-
質問 モデルでは、$250の表示なのに、グリッドに表示させると、250 となる
デルでは、$250の表示なのに、グリッドに表示させると、250 となる。 なぜでしょうか・・・
-
Ability to add multiple values to a text filter
In as much detail as possible, describe the problem or experience related to your idea. Please include specific examples or workarounds: End users want to be able to set a filter on a text line item for more than one value without creating multiple filters. This works with list formatted line items, but not text. How often…
-
How to do Automated Testing in Anaplan?
I have a good amount of experience using Selenium for web application testing, applying it to Anaplan is a new venture for me. Therefore, I would greatly appreciate any insights or advice from those who have ventured down this path before. How effective is Selenium WebDriver in interacting with Anaplan's web interface? Are…
-
YTD Workaround?
I have an issue with the way Anaplan calculates YTD and need help figuring out a workaround. The YTD value in Anaplan includes the current week, which is NOT how I would like it or need it. i am in a weekly system and do not have actuals for the week I am in. So when comparing YTD Actuals against YTD Forecast it is always…
-
Certification
Hello, I've just got the Level 2 Model Builder Certification. I would like to ask 2 questions. First, I would like to publicly show my certification on Linkedin. For this I would need a hyperlink that would point to my certification for any person that clicks on the link in my profile. Is this possible with Anaplan and if…
-
Pavith17111993
Hello Pavitha, Could you please let me know how to access anaplan workspace? When is the next anaplan workspace application open? Best, Prasanna Venna
-
Trying to SUM revenue by account and product, getting datatype mapping error
I am trying to sum the revenue data in the "PY Account and Product Revenue" line item by account. Source and target module are both dimensioned by the same account>product combo list. I keep getting the same "Datatype mapping used for aggregation doesn't match any dimension of the result" error. Line item types are all…
-
How do i stop Summaries being sorted in a new UX grid
HI, i have a grid in the New Ux and i have data summarised by the Country in the hierarchy If i sort the data by Change the summaries get sorted amongst the data, and that is not useful. I want the summaries to remain at the top, and the other line items to be sorted. How would I do this please?
-
Ability to place context selectors Top Right/Left and Bottom Right/Left
It would be great to have the additional option of placing context selectors at the top right/left or bottom right/left of cards…this allows for the ability to decrease wasted white space if we need to show both a context selector and a title on a card. In the example below if we could have the title at the top left and…
-
OEG Best Practice: Performance issues with CUMULATE over lists
Problem statement When using CUMULATE over a list—this is when using the format CUMULATE (x, y, z)—the performance can be poor with anything that exceeds a few million cells. This is because the function is running on a single CPU thread, which differs from nearly all Anaplan functions. Anaplan gets its efficiency from…
-
Enhancing Your Anaplan Audit History Reporting with Model History Export
We are excited to announce a significant upgrade to the existing Anaplan Audit History Reporting project written in Python. This project now includes the ability to export Model History. This enhancement provides a more comprehensive view of data changes within your Anaplan models, allowing for deeper analysis and better…
-
Block the extraction to excel of a grid that will fail due to too much data.
Sometimes users in the UX, when trying to export data from a grid to Excel, will accidentally attempt an extract that has too much data to Export to Excel. We request an improvement to the platform to stop an extraction that will fail based on the user having too large a selection. In one example, a user triggered an…
-
How to Clear Data in Anaplan
Overview I came to Anaplan from different database technologies in support of Enterprise Performance Management (EPM), and it was a common activity to ensure that the forecast or plan periods were clear before planning began. These other technologies allowed you to use a scripted language (e.g. SQL) to be very specific…
-
Shifting a Boolean line item
Hey, I am trying to make a boolean filter so you only see the columns with data plus x number of empty columns. So I have the Boolean Has Data? that is true if any line item has data. So, what I want to see is the Display? Boolean to be true for the next 2 numbered list items.
-
年がTrueの場合、QuarterもTrueとしたい
ラインアイテムが二つあり、 ひとつめのラインアイテムはTimeがYearで、１つの年にチェックが入っています。 二つ目のラインアイテムでTimeをQuarterとし、ひとつめのラインアイテムを参照してそのQuarterすべてがTrueとなるような式を作りたいです。 方法を教えてください。
-
Does L2 require L1 modules/dashboards
Hi All, I completed L1 certification but as my workspace access had expired and I lost all the data and modules created in L1. I have got the workspace access back but for L2 do I need the Line items/modules/dashboards created in L1 or I can start fresh with an empty workspace? TIA, Meenaz
-
Level 2 activity 3.3.5.2B formula for Shipping line items
Hi, 1) Could anyone help I tried to build the formula for 'Shipping Method': 'SYS07 Distribution Center Details'.Default Shipping[LOOKUP:( 'SYS08 SKU Details'.Distribution Center)] and cross checked previous answers at forum that it should be right. But it still prompt invalid?I checked lists of SYS07 and SYS08 that…
-
Clear an entire module
Scenario: If I am importing data into a module and a line item no longer exists in the source file, the Clear Before Import will not clear that line item as it will only clear line items that are coming in from the file. This can lead to numbers being off. Current workaround: Create a duplicate module that is filled with…
-
Performance scenario analysis -IF early exist
Hi all , I am trying to make model not to (re)calculate in some scenarios a variable and (re)calculate only when a boolean is ticked . I did some performance scenarios analysis of calculations (counting seconds on new input ) using boolean and if statement and what i do not understand is why the calculation time after an…
-
L1 Model Building - Lesson 7 Data Mapping issue.
Hi Everyone, I am stuck at 7.2.3 Activity: Import Data into Employee Details Module. The instructions are not clear how to map E2 Employee# list ,which is a numbered list, to the .CSV file. There is Hint in the lesson which clearly says this: * HINT: The E2 Employees# list is a numbered list and each record is assigned a…
-
How to exclude a year while calculating the projection
I have a requirement where in i have to exclude the year 2020 while calculating the cy projection sales for 2024. Hence when i calculate, i choose a last 5 year period (2019-2023). However in this last 5 year period 2020 gets included. I need to calculate for all years excluding 2020. How do i do this? also for the last 5…
-
How do I get the 90-day trial workspace?
How do I get the 90-day trial workspace?
-
Error 404 when I execute the export action with api
Hi Guys! I'm facing a strange problem and I can't find a solution. I've been running export processes for a while and they've always worked, however, this process on a specific model doesn't work. First, I run API user authentication and that works normally. Second, I get the workspace id and model id Third, I execute the…
-
ログイン後のタイムアウト設定について
ログイン後、Anaplanでの操作が10分以上ないと、自動的にタイムアウトされて、再度ログインを行うことが頻発しています。 私は長らくISMSの事務局を担当していましたので、ログオフの設定は必要であり、無操作時間を短くしておくことは理解しています。 当社は予実管理をAnaplanで行っているため、他のファイルを確認して登録することをしていると、いつの間にかタイムアウト、再ログインが頻発しています。 タイムアウトの設定は、Professional Userに設定可能な権限を付与することは検討いただけますでしょうか。 最小単位1分、最大単位30分、といったことができてくれば、私たちユーザー側にとってメリットが出てくるように思います。…
-
Ability to see summary list levels indented and bold in New UX
In the old UX you could easily distinguish summary list levels from bottom levels on a page as they would be indented and bold by default. in the new UX there is only option to make all the rows bold or not bold at all but no way to distinguish easily summary levels. Would request if we can make this available to be on par…
-
changing dimension of a module once its created
I'm trying to add a column to an existing module in Anaplan, but I can't seem to find the option to do so. The only modifications I can make are to the lists, time scale, and version of the module. How can I add a new column to a module once it's already created? Any guidance would be appreciated!
-
Filter for selected native versions in saved view
Hi I would like to have a filter for native versions (i.e Current Forecast and Budget versions only) for an import view. I have set up a version system module where I can tick the boolean against the current forecast and budget version and use this filter but whenever I bulk copy current forecast to another version, the…
-
First Occurrence on module with multiple lists in "applies to"
Hello, Does anyone know if it's possible to do a firstoccurrence formula on a module with 2 lists in the 'applies to'? Thanks! Josh Brass
-
Administration in the UX: Removing Visitors
Currently, if the Admin User selects a Visitor from the list (under Administration in the UX) and then clicks Remove they are given the attached modal (see attachment). But nowhere in the modal is there a reference as to which user is about to be deleted. I suggest that the name of the user(s) be added to the modal.
-
Administration in the UX: Inviting Users
This is some feedback on the experience of using Administration within the UX. I am requesting that the User be given the option to select whether or not SSO is applied after following these steps. Log into Anaplan Click on Administration from the main menu Click on Visiting Click on 'Invite' Enter the user's email address…