-
Add KPIs as line items and steps to define its calculations. Can an admin user do it ?
There is a requirement where I need to give user/admin a feasibility to Add KPIs, define calculation steps. How can it be done ? Any suggestions? As per my understanding, if KPIs are my list items, then we cannot retain the calculations. KPIs need to be line items.
-
Integrate Anaplan in Power BI
Hi community, Have you guys have any experience integrating Anaplan data model into Power BI? If you do, please share. Our company is planning to integrate Anaplan data soon, and I am just researching for a proof of concept.
-
Current Page Filter of Export Action
My customer has 18 projects to manage with Anaplan. I created an export action with "all pages" settings for my customers' backup purposes. One excel sheet, one project. Because it's difficult to save all past data in Anaplan, they need an export button to download all necessary data. Even though each 18 project needs to…
-
Generating the sequential number with formula
Hello everyone . I have a module with 2 dimensions and only one line item . I want to generate the sequential numbers with formula like the numbers shown in the picture. I would be glad if someone could help me with this. Thanks
-
New UX Navigational Bug
This week, I noticed a bug when navigating the new UX. Previously you could click on the app to return to the App's table of contents. This week it would simply refresh the current page. Potential Fix: If this bug isn't able to be fixed maybe it makes sense adding a new Return symbol along the title actions(see screenshot…
-
Why does my model gets logged out after 10 mins of inactivity
If I am inactive for 10 mins or more, my model gets logged out, I mean I am working on 5 different tabs, it should atleast be active for an hour. Is there any way to fix the timeout in the model??
-
Integrating AI with Anaplan to summarize table formatted data
Author: Henrikki Lehtola, Certified Solution Architect and Anaplan Consultant at twoday Finland. It's undeniable that artificial intelligence has revolutionized the way businesses operate. An example of this revolution is ChatGPT, a cutting-edge language model developed by OpenAI, that has the ability to understand…
-
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…
-
Mapping Issue for CC mapping to Driver List
Hi All, I'm having issue mapping Cost centre and a Driver List. Conditions on the Mapping are :- Driver List items to be mapped to all the Cost Centre Some Driver List item to be mapped to some of the Cost Centre What would be the best practice to do the mapping? How can the mapping be done. Below is the screenshot for…
-
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?
-
Tracking import date
Hello, I'm having a little difficulty with something in Anaplan. I want to set up a system (module) where every time the end user try to import a new file in a page, we can note down the date it happened. We have different files, and I'd like to keep track of the last date data was brought in for each file separately. i…
-
Cannot Lookup nor Firstnonblank, how can I solve this?
Hi All, I have been trying to come up with a solution to this problem; I need to let the "belong to fab category?" boolean be checked whenever a cost element list item belong to that particular fab category (e.g. "direct labor") Now, the user has been already giving me this information in another module: However, the list…
-
Numbered list display name
Hello, i have this issue: the first picture is what im trying to achieve, the second picture is what i have now. i dont understand why the numbered list doesnt take the display name property as its display value, instead whenever im adding a new item (through a form) im having this #.... Any idea? Thanks a lot 🙂
-
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…
-
Distribution Center Summary UX Page
Hi all, I have a few questions on the UX expereince dashboard How do i replicate the filter exactly like the example? I think there are no SKUs in the exception summary module (first table - New York/San Francisco / US). How does the filter broadcasted to there How do i have a summary value like it shows there for US? it's…
-
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.…