-
Analogue of SELECT CASE function
This would allow to exclude nested IF-THEN-ELSE constructions.
-
GTM certification - where to find the certification
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…
-
Dynamic Workflow Design
Hey builders! I'm tasked with designing an approval process through Workflow and doing this for the first time. This is a CapEx Request approval flow in which CapEx Projects roll up to Profit Centers. Approvers are assigned at the Profit Center level and go through several sequential stages of approvals. Below is my 2 step…
-
Need a way to identify line Items being used as Filters.
There needs to be a way to identify line items that are being used as Filter in same module or any other module, This would be totally helpful while deleting line items that are no longer required.
-
Sort Module Overview in Settings by Cell Count
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…
-
NEED HELP ON LOOKUP
Hello, Good Day! Need some professional help on how I can replicate the weeknum function from Excel to Anaplan. I am relatively new to this platform. I have a module where I should be able to get the Peak Week from a date value (Peak Date). » So it's like the Weeknum function using the 'Peak Date Mid" value. I have another…
-
Enhancement to existing Bulk API for Import Metadata
There is an existing bulk API endpoint that allows workspace admins to retrieve the full list of Import actions from a given model. This endpoint is in the format: https://api.anaplan.com/2/0/models/{{mdlID}}/imports/ where {{mdlID}} is the model GUID. This returns a JSON response, which contains an object called "imports"…
-
Level 3 Certification query
I have completed my L1 and L2 from a different organization and then moved to a new place. I have asked Anaplan team and they migrated my certificates in the new account. Before doing the Level 3, do I need to do the L1 and L2 once again in the new account? Or I can start L3 directly here.
-
How to add badges for earned certifications?
I have completed all the training and earned the Anaplan Certified Model Builder certificate but there are no badges reflecting on my profile. Please advice.
-
Lookup parent values in a non-composite (ragged) 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: enable the LOOKUP: of calculated values in a non-composite hierarchy How often is this impacting your users? frequently (every…
-
L2 Model Building - Sprint 1 - 1.4.3.1 Create SYS12 SKU Details Module
Hello, I am stuck on this: when importing the CSV file to populate the newly created above module I got an error I'm struggling with. This is the SYS12 SKU Details Module created as requested in the training exercise: this is the CSV file to import this is the message I got after importing the file It seems that the codes…
-
Anaplan Consultant Expertise Accounting knowledge
Do Anaplan Consolidation /Fluence consultants could not be accountants? How they will understand the consolidation process if they don't have the accounting and practical expertise? Thanks !!!!
-
Pivot Table
-
Pivot
Hello team, I have uploaded 2 SS, in first as you can see in pivot that there is no line item in pivot table but it is containing data and in second screenshot in blueprint view you can clearly see line item is present. Suggest me how can see line item in pivot table
-
Where do I complete L1 certification?
-
Learning Histroy Recorded on Personal Email Account
Dear Community, I joined the Community using my personal email account before my current financial analyst position. I have completed level 1 and 2 training with the account and I am now working towards obtaining the Model Builder Certification , which requires work experience certification. My question is: would it be an…
-
Issue on getting the values from the source module : Month (TIME) to Quarter (LIST) Concern
Hi, I am facing an issue in relation to getting the sales per quarter.Target Module : Account (List), Product (List), Quarter (List), Year (List) Source Module : Account (List), Product (List), Month (Time) I keep on getting zero value whenever I tried to lookup the sales from the source Module. I have already mapped the…
-
App has some pages unable to change model due to archive
Hi team, I have made a copy of a model and app and am attempting to change the source model from within the app. For some reason, every page is set to the same workspace and model, but 90% of the pages are saying the model is archived so I cannot update the source model. I have checked the original app and model and it has…
-
Workspace Size
Hi, I've some words I found in a previous post, but I'd like a fresh eyes answer, as I'm interpreting the words one way and then another way - and both interpretations seem sensible to me. I'd appreciate knowing…. a) Have we been allocated a certain workspace size, for example 80Gb, that we then fill up with models, or b)…
-
Setup Number summary to none by default
Today, when we create a new line item, the number format is the only to be with summary "Sum" by default. We like to have none by default as for all other formats.
-
How to map DAT04 Distribution Center Parameter from data hub to supply chain model
-
"Anaplan Essentials for Customers" Program Badge?
Hello, Is there a badge awarded for the completion of the "Anaplan Essentials for Customers" program? Thanks
-
Source Models mapping Vs Import Data Sources/Imports
Hi Team, When we rename the model and remapped to the same model with a new name in Model Settings-->Source Models, it is not reflecting dynamically in Import Data Sources/Imports. To see the new model name, we have to manually re-map the Import actions. It would be great if we have this feature in Anaplan- As soon as the…
-
Subset Formula in General Lists
Hi Team, Can we have an option to have "Formula" in the General Lists --> 'Subsets' section. It would be easy to control Subsets using formulae. Thanks Sathya
-
Cloudworksを用いたデータストレージサービスとのデータ連携設定手順
皆さん、こんにちは！ Anaplanカスタマーサクセスの藤﨑です。 Cloudworksを用いて各データストレージサービスとのデータ連携を設定する手順、特にデータストレージサービス側の設定手順をメインに取りまとめた資料を作成しました。 データ連携の検証を行う際にご活用ください。 ※あくまで疎通確認の意味合いでの検証手順です、本番運用時は社内セキュリティポリシーなどを踏まえた適切な設定を行ってください。 ■データ連携設定手順 〇Amazon S3側の設定 IAMユーザーの作成 アクセスキーの作成 バケットの作成 〇Azure Blob側の設定 ストレージアカウントの作成 コンテナーの作成 SASトークンの作成 〇Google…
-
I am calculating a minimum value, but I don't want the data to include zeros.
Hi, I want to calculate the minimum value but exclude all zeros. I tried previously suggested solutions, but it is still not working. Any ideas?
-
Using Anaplan to filter on Anaplan
I'm really new to Anaplan so apologies if this is a simple one. My hierarchy is set up as follows Department Hiring Role Hiring Role_Site Forecasting Task I want to be able to filter on site & department separately. However, I can't add site into the hierarchy as the same site can exist for multiple departments. I've added…
-
Year Value into a Months Module
Hello friends, Can someone please help with this. I have my number in the below source module (profit) by year. I am trying to get FY24 value (profit) into below target module (i.e. 5,999) depersonalised by month: I tried yearvalue() function and it is pulling all 0's. Can somebody please advice? Thanks Kal
-
Is it Possible to "Select Levels to Show" that are not Shown in the Default View?
I have a hierarchy like this: - L1 - L2 I would like to just show the L2s in the default view, but I would also like to give my users the ability to show just the L1s if they want. But right now, it looks like the only way for users to have this ability is if I show the L1s in the default view as well. Is there a way to…
-
Ability to select multiple models to change the mode
Hi Anaplan, It would be great if we have a feature to select multiple models in the Manage Models page to change the mode at one go. For instance, if I want to archive 20 test models created by my team mates, then it would be easy if I have an option to click a Boolean to select the models and change the mode from Standard…