-
source with more dimension than target
l Line items: source-target ok period: source-target ok sales group: source-target ok product group: source-target ok order type: list exists only in source - OrderTypeTotal -value should be transferred to target delivery channel: list exists only in source - DeliveryChannelTotal -value should be transferred to target…
-
When can we get 2024 Badges
-
Is it possible to Sync a Context Selector to a Field Car Line Item?
I have a grid dimensioned by country and Brand (No time). Country is visible in the grid, while Brand appears on the top right as a page selector - as the user wants to see values by country, one brand at a time. The question is: Is there a way to have a field above said grid. Formatted as brand, so that the user instead…
-
Alternatives to connect Anaplan to Tableau
Hi, We are connecting Anaplan to Tableau in one of our engagements, where Tableau is the downstream system. Currently we are refreshing Tableau data or pulling data into Tableau via Anaplan-Tableau connector (which is native to Tableau). However, as per Tableau 2023.1 release, Anaplan connector will be depricated in 1-2…
-
AM365: Visibility of which Anaplan UX cards are connected to which PowerPoint slides
Please enhance the visibility between Anaplan UX/Cards and the Related PowerPoint slides as follows. The context of this request concerns the case where one populates Anaplan grids onto a PowerPoint, and then updates the cards in each month's PowerPoint (so, refresh the cards / data via AM365). The request is for improved…
-
Eliminating Sparsity
Summary: Sparse cells within an Anaplan model are cells that do not contain and are not expected to contain data. The platform still needs to allocate memory space to these cells even though they are not used. The trick is being able to identify and combat these cells in existing models as well as preventing them when…
-
Query on Time Range
I am working on a one module where there is a time range added. After changing the financial year I changed the time range from FY23-24 to FY24-25. The cell count has become double after making this change. I checked Time range summery is same for both. Can I get a possible solution for this.
-
Export Pages as PNG files
Having the ability to export pages as PNG files not just PDF would allow us to embed them within in the email giving a more professional appearance than having an attachment, this would also make it easier for stakeholders to read the reports / pages on the go within the email rather than having to download the pdf and…
-
Designing models that scale
Author: Arun Thakar, Certified Master Anaplanner and Vice President in the banking industry. One of the aspects which determine whether a model will meet the need of the business is how well it can scale. Whether the constraint is balancing numerous concurrent users, or having dimensions with high indices, or both and…
-
Dependent Dropdown Issue
Hi, I have built a dependent dropdown but its not functioning properly. I have a hierarchy which follows the certain order: Entity>Segment>Product Below is my segment hierarchy Below are my line items which are list formatted When I am selecting the top level of Entity, my segment dropdown is showing entity list and on…
-
Delete rate button
Can someone help me out on adding a "delete rate" button on the UX side? Thanks in advance.
-
how to pull values from one module to another module with no common dimension?
I have two modules A & B where I want to use values of one line item of module A to be a part of a calculation in module B. Module A and B have no common dimensions in between them. Please help.
-
What are Blank Lookups ?
How can we use in Anaplan and Give me a scenario where can i use this Blank Lookup in Anaplan
-
Can I change the Timeout/Logout period from 30 minutes to 2 hours?
Hi team, right now an Anaplan session automatically times out if the end-user is inactive for 30 minutes. However, my users have complained that this is too short a time and too troublesome. Is there a way tenant admin can increase this time limit? Would be super helpful. Thanks Natasha
-
Database support services
I have a business and need database support services for my business. Database support services offer numerous advantages for businesses in maintaining the health, performance, and security of their database systems. For achieve these benefits, I am looking for a reliable platform where I can easily get these services.…
-
L3 Sprint 2 building the list: G4 Territory > Account#
Hi Community, I started L3 wherein we have to build G4 Territory > Account# list in Sales Planning model I followed below steps as per training Firstly, loaded the Download: Territory Data.csv into Data Hub model into Territory Flat List system and built system module below is the image attached of both list and sys module…
-
Actions/processes to be triggered by boolean line items in the model
This ideas comes from the need for many of my clients which use the classic engine to use concatenated/combination lists to overcome sparsity issues. Whenever, a new combination of dimensions used either in actuals/budget/forecast is used an action can be triggered to run which automatically creates the combination list so…
-
Anaplan Connect: Export to SQL Server
Hi, I am setting up export connections from Anaplan to SQL Server. We do this using Anaplan Connect. We have already set up around 100 export connections, but we are still facing difficulties with one specific export. In the screenshots below you can find the error log we’re facing. We use a simple query to insert the…
-
The ability to add a dynamic sub total to a grid
I would like the ability to add a dynamic subtotal to a grid, so when rows are filtered out the total is updated on the fly
-
Anaplan native user list or custom user list?
What are some of the considerations one should have when trying to decide between Anaplan native user list and custom user list?
-
How do I setup a better SSO Sign Out Journey ?
Currently we have implemented SSO using Okta with one of our Anaplan workspaces. When a user sign's out of anaplan, the user is shown a page which states "OK"- as per the attached: I want the user to go back to the Anaplan login page - how do I do this in the SSO setup ?
-
Number scaling option on the presentation table on the Management Reporting page
Please enhance the Management Reporting presentation table to support Number scaling. Often times the underlying calculation and output modules are calculated in precise units but that for the Management Reports we want to display in thousands or millions. Particularly with monetary numbers, especially when the numbers are…
-
Data hub vs Data Management System
Hello, I attended part of the last webinar in which the DMS (data management system) has been introduced. I was wondering if anyone could help me understand the difference between the two approaches, in particular on the data source side. I find it hard to understand Many thanks, Luca
-
Sync on Selection - Multiple dimension Cell based
I understand how synchronization on selecting a list on grid works, I am trying to see if I can make it work on multiple dimension. eg, if I have a grid with list on my row as well as column. Is it possible to select a intersection cell and be able to synchronize select both list? Any tricks for that.
-
NUX Map/Map Box with Shading/Scale/Heat Map
The Map Box has been a great addition to the Anaplan Platform, however, it still lacks a lot of visual functionality that is available in tools like Power BI, Tableau etc. In my case, as far as I can tell, there's no way to create any sort of visually pleasing heat map, or do any country shading that doesn't involve the…
-
OTH01 Module Import from INV05 saved view
I got expected saved view created for INV05 and was working on importing this view into OTH01 in FP&A model. Kept running into an issue where location 'Mumbai' was not found - weird issue with all other locations mapped properly. I was able to solve this by re-importing G3 Location list from Supply Chain Model into FP&A…
-
INV05 Data
For some reason my data from shipping cost is not populating. I went back and checked all the formulas from INV01 and they look accurate. What could be wrong? @JaredDolich
-
Need to figure out the formula in anaplan similar to excel
Formula for Final exploration drilling (Dryhole) in excel is - Basically IF the first line items current year value is <>0 then then sum all the previous year and if the sum of all the previous year is zero then bring the data from other module. Question is - How to look up all the previous year?? for example if the year…
-
SUM Formula Error
Hi All, (a) I have an input module dimensioned by CC & Categories & Version & Time (Quarterly) (b) I have 2nd module dimensioned by CC & GL & Version & Time (Quarterly) © I have the summary module Dimensioned by Categories & Version & Time (Monthly) (d) I have a mapping module of CC & Categories FINAL RESULT (Categories)…
-
Model Sparsity - Combination of Dimensions
I have a question about reducing sparsity in a model by using numbered lists to combine a series of dimensions. I am using ledger data that has information by supplier and by department over time. If I create a module that is dimensioned by these I end up with a huge amount of sparsity as most suppliers are just used by 1…