-
How to retrieve the mapping information of import action ?
Hello everyone, I have a task to check in all my import files, which columns are used (that is to say, mapped to a Linitem in Anaplan), which are not. To do so, I need have mapping information for the import actions (all at least which columns are mapped), any idea to do this? Many thanks !
-
Snapshot Challenge with #list
My scenario today, Integration runs everyday and clear the below numbered list with data. Since the build has been done without the code i'm struggling to create the code with unique combination. My objective is : I want to copy the current data before the delete process will execute. and compare it against the data that…
-
Configure Default Number format for an Anaplan Model
As a Model Builder, I would like to select a Number format for an entire model ("Global Default Number Format" ?). This could be very helpful for us to save time. This can work like the selection of the "Global Default Gride Style" in the Dashboard Settings.
-
Page Builder Access
Hi, I’ve came across an issue where users don’t have a page builder access but still can create pages going into the App. Any idea how to restrict them from building pages and disabling the Create Page option. Thanks!
-
Welcome email to no access people.
We moved a model to new workspace, so we have exported user report from previous workspace where no access people also there and added them to new workspace ( As we are not sure that revoked access will change in future). When we added them no access people also received welcome email, if they are not having access why…
-
Shorthand Typing for Thousands, Millions and Billions Input
As a read/write user of an app, I want to type large numbers with as little keyboard strokes possible, so that I am sure my input is accurate (limit finger errors) and that I save time and get through my workload efficiently. I'll know this is successful when I can type k for thousands, m for millions and b for billions…
-
Model design process
Can anyone help in guiding me whether my order of front-to-back model design process? 1. Document the business process 2. Determine the modules needed in the model 3. Identify the dimensions needed for each module 4. Design the user experience 5. Map the user and data workflow
-
Best Possible solution - Master data changes
Hi, I would like discover best possible solution. The integration happening from SAP to Anaplan (daily basis). The issue is that whenever there is a change in the master data , it is impacting the final #s of budget / actuals / forecast which is obvious. How do you overcome this scenario? Like budget needs to be locked…
-
Conditional Formatting Help
Hi All, Checking the possibility of conditional formatting for FY 24 -GAP as shown below. I don't want the BP or Fcst to be formatted. 2. Is it possible to extend the Color formatting to only certain line items label (like net revenue, GM and GM %) needs color formatting 3. Is it possible to have spacing between Forecast…
-
Summary method for time
I have a reporting module that shows me gross and net revenue totals by month, with line items for each member of a hierarchy as well as the period. I can select each period to see each month's data, but I'm wondering if there's a summary method I would need to be able to see all of the months when I have the whole fiscal…
-
Level 3 TAR03 Country Account Calculation- is my Factor logic and values correct? Please help
I've been stuck on this part for some time now. I have followed the instructions carefully and when I calculate the Factor line item in TAR03 I am getting negative values. I did a SUM by Country on the Target line item in TAR03. Are these negative values correct or is something wrong in my TAR02 line items? I'm also not…
-
Level 3 Use a published line item on the Account Assignment UX for the comment
Hello, I am unsure how to link the comment to the account that I assigned. It seems like I need to select the account first, and then provide comment for that particular account? Not sure how we can achieve it using a published line item.
-
I reorder to columns in the model but they don't display in the same order in the UX page
Hello Everybody , I hope you're well . I reorder my columns in the model but they doeson't change their order in the UX page ! Can someone please help me with this ? Thanks in advance.
-
finished
.
-
Planning in high gear: Accelerating manufacturing companies to success
Author: Daniel Dunleavy, Certified Master Anaplanner and Manager at Lionpoint Group. Manufacturing is the lifeblood of the US economy. In 2022, it generated $2.1 trillion of revenue, and would have ranked it as the world’s ninth largest economy(1). The sector also plays a major role in promoting growth around the world.…
-
Finding duplicate combination/inputs in different dimension
I have module dimensioned by TRID(1-100), Business Type(Type 1, Type2, etc.) and Region(EMEA,APAC,NA,LATAM). This module is used to define rules for each business type and Region. For example: So, these are the inputs/rules for each region . In this example For EMEA we have 3 rules Rule 1. Segment = A Partner = C Rule 2.…
-
Highlight More Clearly Selected Rows/Columns Syncing Between Cards
-
Transfoming Numbers
Hello, I am trying to get the figures from Eur in KEur. The figures in Eur they are in a Module and if I just apply the classic formula, I will increase the size of my Module as I need them both : in Keur and in Eur (I don't want that).The figures in KEur I need to show them in the UX, so I am searching for a way to show…
-
Reporting/ Hierarchies/ Modules
Afternoon, I wonder if somebody could help. Issue: We currently have our volume planning pages (& subsequent summaries) set up in the hierarchy SHOP > CUSTOMER > PRODUCT (E.g., Shop 1, showing customer A with 100 products, made up of 70 of product Y, 30 of product X) We have been requested to create a report customer first…
-
Missing data sources for UX Cards
When the data source gets deleted for a card in a UX page; one see's below There is no notification in Anaplan that the data source is linked to a card in a UX page. My idea: A message that shows all the cards the data source is connected to, so the model builder is aware of the full implications of deleting a data source.…
-
Data Display in a UX page
Hello everyone, I have a table displayed on a UX page (a worksheet) containing multiple line items in the columns and a list of months also as a column (where each month is a child of a quarter, which is a child of a year). I need to address two challenges: Filtering Data by Months or Quarters: I aim to enable users to…
-
Revenue Distribution Help
Hello all , I am trying to find the best way to distribute forecasted revenue across multiple periods based on a distribution chart (so to say). I will attach screen shots to better explain. Each month has a forecasted value: Each month's forecasted revenue will be allocated based on this chart: Period 1 would correspond…
-
NUX Filter
Hi Anaplan Folks, I have one question regarding NUX.. I have 2 Dimensioned Module (Employee and Time) Where employee in rows and time in column in NUX.. There is another module with same dimension which is used for creating filter Now I have to filter employee wrt time based on Boolean line item When I am trying to add…
-
Search Icon missing in the beta version of new module inventory
Hello Everyone, I see that in the beta version of new module inventory, there are two issues: 1) The Search icon is missing, which is there in the earlier version. 2) When we use the find option (Ctrl +F), it only searches the module names present in the current screen and not from the entire list of modules. Attached the…
-
Aggregation Functions Other Than SUM
There are several types of functions in Anaplan: aggregation, numeric, financial, time and date, logical, text, call center planning, and miscellaneous functions. As a model contributor, you are probably already aware of the SUM function in Anaplan, which is an aggregation function, but how many other aggregation functions…
-
Home Page Layout Suggestion
As we guide users through the Home Page Layout, I would like to suggest the below order as I believe would help with easy access to Apps. Current Layout is very confusing to users new to Anaplan. Display Order on Home Page: Display Order on Favorites Panel: Rationale 1. Apps 1. Apps Most used by end /business users, and…
-
Referenced by feature for DCA Driver Line items
When you choose a line item as read or write access driver, there's no way to know that the line item is actually being used besides knowing/searching for it as an active driver in line item information. Can we have a 'referenced by' feature for when a line item is an active driver?
-
Including Text within a Number Formatted Line Item?
Our client requests to see "no MTA" when MTA= 0 and Warehouse <> 0. However, instead of 'no MTA', I'm getting 'NaN'. Is it possible to include text within a number formatted line item? Formula - Final MTA = IF MTA = 0 AND Warehouse <> 0 THEN VALUE("No MTA") ELSE MTA
-
Report Page : link to a slide
Hello ! In the new report page, It could be very interesting if we could choose between "link to a page" as existing or "link to a slide" of the same document. For exemple, we could create a summary slide, with direct link by title
-
【2024年3月】プラットフォームアップデート
New UXの機能アップデート ・チャートのドリルダウン機能 ・モデルの切り替え機能の改善 ・エンドユーザーによるShow/Hide機能のエンハンスメント マネジメントレポート ・カスケードスライド機能の追加 ・スライドの非表示機能の追加 プランニング＆モデリング ・クラシックモデルエクスペリエンスへの切り戻し機能の廃止 ・ベータ版新モデルビューのリリース ・フォーミュラ編集時のAnapediaのポップアップ