-
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…
-
[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…
-
Initial Page based on Selective Access
When publishing a module on a dashboard you can specify an Initial Page, an item from Page Selector that will be selected once you reopen a dashboard. For reporting dashboards, I normally put it on Total level (Total Zones). If Selective access is enabled for the Zone list, and a user has access to a specific Zone, the…
-
Process Filter in Role->Action in User Access
It would be usefull if I could filter to one particular selected process can configure all actions within that process. Yet i can only search action by action and set it up slowly Also how often get one action forgotten because its just too many of them. This would be prevented if i can see the (filtered only) whole list…
-
SYS07 Distribution Center Details | Default Shipping empty
Hello everyone, I’m stuck because the column 'Default Shipping' in the Supply Chain Model is not populated after I run the import from SYS07 Location Details —> Import Distribution Center Details saved view (Data Hub Model). Can anyone help me please? Thank you
-
How to find the average of the same month for different years?
I have 5 years of data. I need to find the average of the same month for the 5 years. For example, (Jan 19+jan 20+ jan 21+ jan 22 + jan 23) /5. Similarly i need to find for feb, march, April… I used month and model calendar for the time dimension. How do i develop this in anaplan? thank you
-
Datatype mapping used for aggregation doesn't match any dimension of the source?
I am trying to pulling billings from a calc modules, the source and target modules are both dimensioned by country but I keep getting this error. Note: I am trying to pull in billings from CALC02 which is sourced from CALC01. CALC01 is pulling from a flat data module. Please advise…
-
What to do with highly sensitive data?
If a customer has highly sensitive data and really needs the most controls from an access standpoint, does Anaplan recommend…. The data lives in a model it's own workspace The data lives in a model in it's own tenant that only has the data.
-
Should version be in the unique ID when importing into a spoke?
I am looking to import these dimensions below. I am wondering what should be included in a unique ID? -Version -Time -Product -Country I think Unique ID in this case is Product and Country, but can someone confirm?
-
When exporting to other systems, is it better from Spoke or from Data Hub
I feel I get conflicting answers when I try to research this question. In the Anaplan Model Builder training, they say export from the Data Hub to other models. Likely because model to model import is less time, and this will make the spoke have less downtime. However, in forums, I see people saying either one is okay. If…