-
Drive dimension selectors from undimensioned module
Hi, Is there a way to drive dimension selectors from a module that has no dimensionality? I have 2 modules: Select Dimensions no dimensionality, just line items that are formatted by dimensions entity and department, etc Income Statement dimensioned by entity and department. End-users would like to make entity and dept…
-
Query on Efficient List Creation Method
I'm seeking advice on the quickest method for creating lists in Anaplan: using the UX Page "Form action" or the backend Actions for Creating List Item. Which approach is more efficient?
-
Equation of a Trendline in a Scatter Plot
Can we somehow get the equation of the trendline from the scatter plot? We can use the equation then for further forecast.
-
How to bridge the 2 modules with different dimension?
The end goal is to capture the new region from the source module [SYS C4]. However, the source and target module [SYS Sales] have different dimension. In the source module, the code line item automatically updates whenever there is new region plotted. In the target module, the target line item is the new region - the…
-
anaplan level 2 sprint 1 activity 1.5.6.1
Hi all, I have problem while importing data into Historic Volumes Module. The csv source file contains data (image 1), but when I run importing into modules (image2&3), there's no data at all (image 4). What should I do to fix this problem? And by the way, I do not get why we select "Column Headers" for "Volumes". I got…
-
Why is there a round at the end of a number converted from text?
Hello, I am converting a text into a number to do a complex sort. It adds code from several different dimensions to create a large text. Then I convert it using value. When I do this, the final 3 digits are being rounded unnecessarily. Does anyone know how to get past this? Original text: 23921101010004270452 Converted to…
-
Refresh failed due to an unexpected error - Excel Add in reports for some of the users.
Hi, There are some Financial reports that has been created using Excel add in functionality. Some users are having issues while refreshing it and getting error message. Whereas others are fine with it. A few users are getting this error for some of the reports, but they are able to refresh other add in reports. Could…
-
How to manage Workflow-Approve/Reject
Hi, I am trying to create workflow for my project. My module has product(10 prod), customer(10 customers), channel, & version dimension Product, customer & version list has selective access enabled. I want to create workflow for single quarter, Step 1) Assigner workflow to planner , he will plan everything in top grid and…
-
February 2024 Community Member Spotlight: Alessio Pagliano
Join us in celebrating @Alessio_Pagliano as our featured Community Member Spotlight for February! Alessio's inspiring journey in the Anaplan ecosystem spans seven years, marked by notable achievements such as becoming a Certified Master Anaplanner and a Community Boss. Explore Alessio's impressive Anaplan journey and…
-
SOS : A modeling question
Hello Everybody , I have two lists in Anaplan , let's name them countries with all the countries in it and a second list called products with all the products that a company have. I want to give the possibilty for the user if he check a country , he will see only the products in his country. So my question how we can do…
-
Multiple revision tags
Hi All, We can create multiple revision tags in the dev model for specific changes & while performing sync with PROD, these revision tags gets highlighted, however if I select the latest revision tag "add6" - all changes incl. changes specified under "add4" also gets updated. I believe revision tags works cumulatively, if…
-
Summary Calculations With the User List
Even though the Users list does not have a top member assigned to it, with the release on April 24, 2021, model builders will be able to use the following summary functions with the Users List: SUM, LOOKUP, ISFIRSTOCCURRENCE, CUMULATE, ALL, ANY, AVERAGE, FIRSTNONBLANK, LASTNONBLANK, MAX, MIN, RANK. Lookup First, let’s look…
-
Convert date to time format
I want to calculate the # of days in a month without using the PERIOD function. No time scale for this module. E.g. 10/15/2015
-
Variable Rounding
It would be helpful to allow the use of variables for the rounding direction and method, instead of only permitting hard-coded value. I'm working on a use case where for a certain planning scenario, there is a need to round up for certain product/country intersections, but round down elsewhere. I have a workaround, but…
-
Left margins on rows headers
Hello everyone, Does anyone have a good trick to get the left indent on the rows in UX grids to go all the way to the left. I just can't get it to move over there, especially when I use a hierarchy. It's taking up a lot of space and makes the whole dashboard look bad. I've tried: I Show/ Hide only the level I want to see.…
-
Alternative to SELECT:TIME.ALL PERIODS?
Hi, Is there an alternative to SELECT:Time.All Periods which will allow us to query whether a line containing time contains data not equal to zero across all time periods. The target line item does not contain time. I would usually just use SELECT but I would like to get the same outcome without having to use All Periods…
-
Move Excel Worksheet with Anaplan connection to new workbook - Excel Add in
Hi, is it possible to move a worksheet with an existing Anaplan connection to a new workbook without the connection disappearing. Thank you
-
Import into DAT02 Shipping Metrics module unsuccessful: Ensure the column headers in the import file
When i am trying for 2.3.9.1 getting error as "Import into DAT02 Shipping Metrics module unsuccessful: Ensure the column headers in the import file map to the correct dimensions in your module, then run the import again."
-
3.3.5.2C Getting wrong Confirmed Purchase Order Receipt value.
Hi there, could you help me with this wrong answer? i tried everything but still getting wrong answer. Thanks & regards.
-
I need a help in formula
Country State District Percentage Allocation Values Final Value 502364 520647 521987 0.2 3417 502364 520647 523378 0.123 3868 502364 520647 527298 0.5 2659 502364 520647 524982 0.02738 2413 502364 520647 522518 0.14962 2687 502364 502670 502672 0.235 3548 502364 502670 502674 0.635 3047 502364 502670 502679 0.13 2464…
-
L3 Sprint 2 User story
Hi Everyone, I am in L3 in lesson 4.4 as per below screenshot. I have used the same csv file to import the data in Data Hub model and created the list G4Territroy>Accounts# and pushed it into spoke model (Sales Planning model). Just need one confirmation as per below SS it mentions we have to import into Sales Planning…
-
Mapping
Hello, I don't know what information to put in the mapping ?
-
How to reduce huge dimensions
Hello, I'm having a lot of issues with workspace size, with models going above 150/200gb in size and I'm not sure how to reduce it, to give some context, I have three main lists (size considering subtotals): Products (~1,5k) Countries (>100) Customers (>270) The issue is that if we apply all of them to a module what we get…
-
【2024年1月】プラットフォームアップデート
New UXの機能アップデート ・Geo-Mapping機能の強化 ・Management Reporting機能の強化 ・散布図/バブルチャートのパワートレンドラインの追加 ・カードツールバーの整理 ・削除されたアプリページの復元 ・通知アクションの受信者の増加 ・アクションボタンアイコンの配置 ・ Workflow機能の強化
-
Clickable Image Links
We would like to put an image on the UX dashboard, which can be clicked on to navigate to a specific link. Is this possible to do?
-
Remove 10 million item limit from the ISFIRSTOCCURRENCE function
Brief description of the idea Remove 10 million item limit from the ISFIRSTOCCURRENCE function Expected benefit/impact Removing this limit would allow imports to be ran into large hierarchies that are referenced in ISFIRSTOCCURRENCE formula. Currently they fail with an error message.
-
Header labels for Dimension/List columns in grids
Grids in UX don't show labels for lists in rows. It is left to user assumption based on data visible which is not ideal.
-
Insert multiple Items to a list from UX
Old UX had capability to add multiple items to a list from any published module grid. This capability is missing in new UX. UX only provide option to use Form type action but only allows adding 1 list item at a time.
-
Allowing Documents (pdf, excel, word, ppt) attachments in Anaplan
It will be helpful if there is capability to attach Documents (pdf, excel, word, ppt) in Anaplan. Many planning decisions/inputs need supporting documents as attachments.
-
UX page with cards linking to different models.
I would like to create a UX page/Board that will allow me to create cards that link to different models. e.g. I choose the grid card and link this to a module in Model A I then choose another grid card and link this to a module in Model B and so on.