-
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.
-
How can we use OAuth integration with Cloudworks and BQ
We are evaluating Cloudworks to integrate Anaplan with Google BQ. Our security team advised that they prefer OAuth-based integration. I could not find documents on how Cloudworks can use OAuth. Can Cloudworks use OAuth ? If yes, where can I get material to understand how to use Oauth with Google and Anaplan using Cloudwoks
-
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.
-
Session-Time Out period reduced as part of new login screen roll-out?
I'm aware Anaplan has rolled out a new login screen with automatic detection of SSO. As part of this security release has the session time-out duration reduced by Anaplan? Because users in my org. report that they're being logged out more frequently and constantly as soon as they navigate to a different window or program .…
-
Anaplan Bulk API Exports (Line Splitting on last row of chunk)
Exporting a file that ends up having over 100 chunks. The first and last rows of the files are split across different chunks. Is there a a way to prevent this?
-
Build a heatmap
Hello Anaplanners, I am trying to create a heatmap in UX. Conditional formats should be applied across this table with Red for low numbers and green for highest. Has anyone built something like this before? Any tips on how to get there? Note: My big roadblock is that each row is a separate line item. But, I could lobby to…
-
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.…
-
Automated Email Notification Capability
I currently have timetables built out in Anaplan with designated users to each deliverable with due-date. I would like to have the functionality to send automated rmeinder emails to users when the due date is getting closr and teh deliverabl has not been completed
-
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.…
-
How I Built It: Number format converter (thousands and millions)
Hello Anaplanner Community! I’m excited to participate in another ‘How I Built It’ video with a Number Format Converter (thousands and millions) tutorial. This video walks you through how to dynamically update UX grid number formats on all tables and charts. This enables users to have different number formats enabled for…
-
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…
-
TIMESUM from a Module with time dimension to a Module with a fakeweek dimension.
Good afternoon, I am trying to map the data in day format to a fake week dimension using a timesum. I have a start and end period in DATE format but the formula only gives me a result when this two are the same. This is the formula: This is the source module: With the data imported to day. And this is where I map each week…
-
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…
-
using the cumulate function
Hi all, I am trying to use the CUMULATE function to cumulate actuals (number formatted line item) over a subset of periods 'SS Periods Current year' (a subset of custom list, not Anaplan time). I first thought that I could not cumulate because I was using a subset, but even replacing the subset with the full list did not…
-
How to add a line item as a page selector
I have a list of brands which are owned brands and private label brands, for now they are in a single list. But now on my ux page I want to make a filter as only Owned brands and Private label brands. Like if I only want to see owned brands or only private label brands. I have created a list shown as below, I also linked…
-
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…
-
How to Achieve in pre-built Anaplan Eco-System , Hierarchy into to flat list & Replacement
Hi All, Currently the Anaplan eco-systems has multiple workspaces and multiple models[8 workspaces ~55 GB], now there is a proposed hierarchy change(as some models are quite complex and have Dependency on that flat list to create further Folded Lists for Reporting) 1. The List to be eliminated is a Flat List 2.Against that…
-
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…
-
Edit Export Action
User should be able to edit Export Action just like Import Action in case of addition, deletion of line items to the saved addition/removal of filter to the saved view which is being used in Export Action.
-
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