-
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…
-
Ability to exclude zero values from AVERAGE calculation
A common requirement we see on customer implementations is to be able to calculate the average of a set of values but exclude zero values. For example if we have the following set of values (10,0,0,8,0), the average excluding zeros would be (10+8)/2 = 9. The current AVERAGE function cannot exclude zeroes and so gives an…
-
Time Ranges Notes
I would like to have Notes available to be able to record comments against a Time Range so as to give more clarity as to what the Time Range is used for and whether it needs to be rolled forward at a Year End as in some cases there may be no need to change the start year of the time range for instance but without knowledge…
-
User list used as a dimension, allow to create a subset to reduce module size
I would like to use the user list as a dimension so users are not overwriting each others settings, but the module with the data the settings select is big and so is my user list, so this adds a lot of unnecessary model size. Can't there be the ability to create subsets of the user list when used as a dimension, like for…
-
Automatically re-open modules after a session timed out
Hello All, As a new model builder I have experienced some frustration with tracing back where I was at if my session times out. This is especially true during the development stages and the solution is moving fairly dynamically and several developers are working on it. It would be a nice improvement if Anaplan could cache…
-
Quick way to open referenced Line Item or List Property
It would be great to have a quick way to open a referenced Line Item or List Property from an existing formula. It can be very tedious & time consuming to hunt through the modules & lists, then again through the line items & properties to locate the reference, especially when there are multiple levels of references to…
-
How can we get the Page history and reverting its changes if desired, like as we do for Modules
Recently i unknowingly deleted the conditional formatting(CF) line item from the underlying module due to this, The CF on the page which is referring to that CF line item is also got deleted. Now, i want to have that CF back on my page. I tried Anaplan's History where i reverted back the module to get back the CF line item…
-
Can i have 'Create Action' under a 'Process' which includes other Actions (Import/Export Actions).
I am trying to create a process for the user where he can create a record to a numbered list using 'Create Action' and add attributes to it in a module & keeping this process as base, I am trying to export this record & Attributes to external ERP System using 'Export Action'. Can i conclude all this in a single 'Process'…
-
Increase the size limit of notes
A description of the enhancement required: The notes on line items is 250 characters which isn’t enough. A story for why the enhancement is required (specifically, how would it aid the business process): When you write a note on a formula, you have to explain WHAT is does, WHY you did it, HOW it’s used etc etc, 250 isn’t…
-
Efficiency of the lookup formula
I have some question about how efficient the lookup formula is I have a situation where we when we have new items have the ability to give that item a mapping to another item to pull some initial data for since we don't have anything for it yet. we used a lookup instead of just repopulating the initial data so the users…
-
Users List as a basic Dimension
Hello, I ran to the several issues when I needed to calculate some values on the Top Users level. * Users list itself doesn't have Top Level and there isn't an option to add it. Therefore you can't get Total number for given line item that applies to Users List. I was trying to do some workarounds (creation of Dummy Users…
-
Add a tab for saved module views in Model Settings -> Modules
Description of enhancement: To add List of modules' views in the Model Settings menu. It would be great if it can include: View name Model name Actions’ names then view is used as a source Dashboards where used An example of the enhancement: It may be very similar with the Modules list. A story for why they want the…
-
Ability to copy a process
It would be nice to have the possibility to copy a process. This will save some time when developing, because you can easily amend a simular process instead of collecting all actions again.
-
Conditional Formatting for Field Cards in UX
I would like to propose adding the ability to apply conditional formatting to field cards in the UX. Many customers prefer the look of the field cards to a grid, especially for filling out a form, but we often have to use a grid instead to be able to apply CF for invalid entries.