-
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分、といったことができてくれば、私たちユーザー側にとってメリットが出てくるように思います。…
-
"Level Mismatch on Common Dimension" Error when Changing Parent of List
Originally we had A1 Expense Group, A2 Expense Category, and A3 Expense Account. We added A3 Subcategory and changed the naming of A3 Expense Account to A4 Expense Account. We have been unable to change the Parent of A4 Expense Account to be A3 Expense Subcategory. Attempting to change this gives the error "Level Mismatch…
-
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…
-
[Select: Time. All Periods] works for Model calendar and Time ranges
Hi All, [Select: Time. All Periods] works for Model calendar and Time ranges? Somehow, its working for Model Calendar but not for Time Ranges. Do we have any similar function for Time Ranges? Thanks AB
-
[Guide] Multi Level filter selection on composite hierarchy
If you are using a multi level composite hierarchy as your main reporting list (as you should vs ragged), you have encountered the need to filter it and display many levels of it in many different dashboards. Recently re-discovered a solution that I find quite handy and decided to share it here. Here's the result. As you…
-
I want to appear for Level 1 model building certification
Hi, I am unable to appear for Level 1 model building certification
-
Import is zeroing out a field that it shouldn't be
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I run into is when I run a second import. looking at the data im importing, there is no line going to CC 3602 and GL 65566,…
-
Level 3 sprint 2 - 1.3 data hub
1.3 Check Your Build As you complete the model building activities for Process 2 Assigning Accounts to Territories, User Stories 2 1 to 2 5), you do not need to manually assign the accounts to a territory. You will be provided a data file to check your model in the Check Your Build section for User Story 2 5 Hi Please…
-
Excel add-in: breaking the connection's cell range
Hi Anaplan Community, I have a question regarding the Excel add-in. I was reading about refresh conflicts on this Anapedia page. If you break a connection's cell range, it may not refresh properly. To include a cell range in a Refresh, keep the cell range together at all times, rather than break or split it. You can insert…
-
Cloud Works integration
I apologies in advance if this idea has already been posted🙂. In Cloud works if we delete any integration by mistake is there any solution or process for reverting it back again or to see what we have deleted and revert it back .
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hi All, good evening, I am doing the activity but did not get what we are asked for. First, what is a stock exception count? How to add it on an user page? And, is there any faster way to have the context selectors than sync diff charts or tables ? Thank you in advance for your help BR Arthur Robbe
-
Anaplan API to pull metadata at Module Level only
Hi all, I want to retrieve metadata from a model at the Module Level ONLY. Reason being is I have DataTags identifying which modules are Critical, Medium, or Low and would like to parse through this data. Currently utilizing this api: https://anaplan.docs.apiary.io/#RetrieveIDNamesModuleModel but only lists the model ID…