-
Creat a grid spanning multiple modules
I want to merge together two modules with a shared axis to create one grid. Business reason for wanting the request: So that I don't need to put multiple grids next to each other to create the tabular view I want.
-
Please help to see why this formula returns 1 instead of 0?
IFTRIM(Deliverable Item) <> TRIM('DAT.040 Approved Deliverables'.Deliverable Item[LOOKUP: 'SYS.910 Other Settings'.Audit Version Lookup])THEN 1ELSE 0 Deliverable Item is ：Channel Data Mgmt Platform: Pre-study to build one single harmonized platform for all our Partner data, expanding our capability to deliver data driven…
-
Excel Add-in
The Excel Add-in for Anaplan is a key feature of the system, although all organisations would like to steer away from using this sometimes this is the easiest solution to a problem. I have used similar systems to Anaplan, Hyperion, Board, Cognos and TM1 and find this area very inflexible and lacking compared to its…
-
Combination Chart for Percentage and Absolute Value for Different Version comparison
I am working with line items in the columns and versions in the rows for scenario analysis. It would be beneficial to display both the percentage and the absolute value of a particular data point next to each other for different versions. For example, when we're comparing actuals and forecasts or different budget versions,…
-
Run Action Concurrency
Hi, I want to check the action concurrency. If several users run the action, Action which first user run will run? The second user's will not run?
-
Using Python 3 with the Anaplan API
* Getting Started * Authentication * Getting the Information Needed for Each Script * Uploads * Multiple Chunk Uploads * Single Chunk Upload * Imports * Exports * Actions * Processes * Downloading a File * Deleting a File * Standalone Requests Code and Their Required Headers * Get Workspaces List * Get Models List * Get…
-
Filter multiple dimensions as rows
Hi team, Im working on a rolling forecast module and have the following dimensions Versions (page), Time (columns) and Cost Centre, Gl and line items as rows. one of the line items is an input called temporary variance and a requirements is that across all time that the temporary variance sums to 0. My problem is, I cannot…
-
Top five most useful recent updates and features
Author: Kathleen Sullivan, Certified Master Anaplanner, Solution Architect, and Manager at Cervello. Anaplan is constantly releasing new features to the modeling experience and to the user experience. These spark so much excitement for all Anaplan users because it increases usability for everyone, administrators, model…
-
How to allow a dashboard to be filtered by many users independently and simultaneously?
We have a small list of users who have access to the same dashboard, but can only view their divisions. We built a separate card on the dashboard that allows them to select and de-select multiple items in a select dimension list. We find that when users select or de-select these items, it is changing the data on other…
-
Anaplan links to open Anaplan App when used on Mobile Device
Many Anaplan users request being able to link directly to pages in the app. Even when opening a link on a device with the app installed, it will go to the browser version. It makes users much less likely to adopt Anaplan in cases where they prefer the app and need to share links for specific pages. It would be very…
-
How to convert an annual amount to a monthly amount
I have 2 modules, both dimensionalized by the same list and time (1 is by year and the other by month). I need to take the annual amount in module 1 and spread it over the monthly amount. I've tried spread(Annual Amount, 12) but I'm not able to get anything to populate in the monthly spread module. Any guidance would by…
-
Volume Import - Import keeps failing - Please help
Here's my Source to Target Data Time: I’m using YYYYMM Product Code & Location Code are fine. Fixed line item, I selected “Volumes”. Error Message: I don’t understand why it doesn’t accept the time format.
-
Dimension Help for Equity Waterfall
I am new to Anaplan and am currently doing a project for fun. I am trying to recreate a equity waterfall that is commonly used in Private Equity. I am currently stuck on an issue on setting up dimensions that will be used for the waterfall calculation. Attached are screen shots of what I am trying to recreate in Anaplan.…
-
Data Integration Challenge: Seeking Guidance on Anaplan Platform
Hello, I am currently working on a project that involves integrating external data sources into the Anaplan platform. recently I completed splunk certification and I am facing challenges with efficiently importing and synchronizing large datasets. Here are a few key points to consider: Data Volume: The datasets I'm dealing…
-
Lesson 8 : Revenue and Margin Modules
Anybody can help me? i already entered the formula, but the number doesn't appeared when i view the product family page. but if if i checked at the products module it already aligned with the product family as a parent. i will be thankful if anybody may help me. Thanks
-
How to obtain annual forecasts?
I'd want to have an annual projection, but Plan IQ only allows for monthly/daily/weekly . Is it feasible to obtain a yearly forecast?
-
Forecast without PlanIQ
Is there an alternative to deliver anual forecasts in Anaplan without PlanIQ?
-
CoE Connect - Newsletter October 2023
Welcome to the October edition of CoE Connect, where you'll find the latest news and insights from the Center of Excellence Program! We hope you'll find this informative and helpful, and we're always eager to hear your feedback or suggestions. Thank you for being an essential member of our CoE community — let's continue to…
-
Workflow Feature Anaplan
Hi All, I was testing out the Workflow feature in Anaplan, could I get some help on how to use the machine task (data write feature) and hierarchy task? Do we have any documentations on how to use the different tasks in workflow. Is there a way we can show that a workflow or a task has been completed in the NUX? For…
-
9.2.6 lesson
I am working on 9.2.6. I have updated and checked all formulas but Revenue, COS, Margin and Margin % do not match with what solution is shown in exercise. Can anyone please help?
-
Anaplan API | Add list items to a numbered list by combination of properties as a unique identifier
Dears, I am currently writing an API call to add a list item to a numbered list. Here, i would like to use a combination of properties as a unique identifier, not the regular code. Which has to be specified in the request body. Unfortunately, I haven't found any guidance in the documentation on how to do that (). Does…
-
Request for Workspace access
Hi Team, I had requested for getting access to 90 days free access to Anaplan workspace just a day ago. Can you let me know until when I will get the access. Regards, Dipak Sah
-
Saved Export Actions
For saved exports from Anaplan, how does the export remember what to export? I'm used to creating a saved view to represent the export, however, if a saved view is not created and potentially certain list members and/or line items were hidden/visible when the export was created, is that what Anaplan remembers for that…
-
【2023年9月】プラットフォームアップデート
New UXの機能アップデート Formアクションにおけるバリデーションの追加 ナビゲーションリンクアクションボタンの追加 Cell Historyのエンドユーザー無効化 通知機能の強化 ワークフロー/ワークフロー for Mobile
-
Maintain Formatting in Data Export
When exporting data from Anaplan to Excel, it would be great to have the option to maintain certain formatting options such as wrapped text and conditional formatting.
-
Need help to avoid hardcoding SELECT
Hello, Need some guidance on how I can avoid hardcoding. Let say I have a module A that applies to Country and Product (Coke and Pepsi) and line item as sales I have another module B that applies to country and I want to create two line items Sales - Coke and Sales - Pepsi which I then want to compare variance. This is the…
-
Context Selector: Selecting Multiple Items at once
It would be very helpful, if you could select different items from a context selector at once and Anaplan should show an aggregate value of the selected items (e.g. Years: being able to selct multiple years at once in a grid would enable for instance in reporting to show 2023 and 2024 and the difference between the years.…
-
Search option in manage models pane
As a model builder its difficult to look for a particular archived model as there is no search option. And also when we click on archived models its a mix of standard & archived. For example we have more than 100+ models(archived+standard) in our workspace. In such cases its too difficult to search for an archived model…
-
In tab 7.08 I would like and additional column between actual total cost and planned cost on tab 7.0
-
3.3.12 Activity: Create Product Replenishment UX Page
Couple of questions based on my current UX Page and the screenshot from training * Is there any way to shift the context selectors on the top? i.e. if I want to have Time on left and Product on right instead of how it currently is. * Why are the Booleans in the INV01 grid not editable like they are in the material's…