-
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…
-
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…
-
Public holidays building modules
I want to be able to display a table of public holidays by country on a dashboard. My problem is that in some countries, public holidays can change from year to year (unlike New Year's Day, which is always 01/01). The steps I've already taken: I've created a SYS10 public holidays module where I display the date and a…
-
Import Error
Hi All, I have a module dimension by Cost Center & Version, whenever I run an import I get this error below. What could be the reason and is there a workaround to solve this. Thanks.
-
Mapping modules dimensioned differently
I want to be able to pull over my Snapshots from SYS: Snapshot Lookup into my time module via lookup using my Week Number and the Code since they are both text. My lookup module isnt dimensioned by time but it shouldn't have to be, what am I missing?
-
Top Levelを持たないリストの合計値を算出する方法
Top Levelを持たないリストでSumを出力する方法を教えてほしいです。 ▼Top Levelを持つリスト ブループリントビューから「Summary」をSumにすればTop Levelに設定されているTotalが表示されます。 ▼Top Levelを持たないリスト ブループリントビューから「Summary」をSumにしてもTop LevelにTotalが設定されていないので表示されません。 別のモジュールを作成し関数を使用すれば合計値を出すことができるのであればサンプルモジュールの画像を添付してほしいです。
-
How to get display name of list member in users tab for selective access
Hi, I have exported users access list ,getting only numbers/codes in the selected list write access(Which is a number list) But I want to see display name of that list member . Please suggest me if there is any way to sort it out.
-
How to select only one Boolean line item at a time by disabling all other Boolean options?
I want the user to select only one boolean line item at a time. When the user selects one boolean, other booleans should not be selected, and once the user unchecks the selected boolean, all booleans should be available for selection.
-
Getting the end date...
Creating a model for asset life, figuring out the end date of an asset by using below infos Start date: 10/19/2019 Asset Life: 4.7 years which is 56.40 months
-
How to calculate Run rate
Hi All What is the best way to calculate a 12 month run-rate formula in Anaplan. Below is the calculation I used but am not getting the right figure. Also 0 used MOVIMSUM(Actuals, -12, -1, AVERAGE) but not getting the right figure Your input will be really helpful. Thanks. In this calculation module I referenced the…
-
Function MONTH returning 11 for the period dec
Good morning, The function MONTH is returning in our model the number 11 for the month of December, the number 12 for the month of January and number 1 for February. Anyone know why is this happening? and why december is not the 12 month and januray the 1 month? Find screenshoots attached: We have a calendar type 4-4-5 as…
-
How to set automatic refresh when filter is updated to new value
Hi All, As I was building the UX Pages and came across on roadblock wherein each time when I change country and segment in field card I had to refresh the page again to get new country and segment values. Please requesting for inputs on how to set automatic refresh when I change the filter to new country and segment Below…
-
How to calculate active days in a month???
-
Adding specific number to imported data
What's the best possible way of adding '0's to imported data? Eg: Data > Required Data 156 > 00156 23 > 00023 62797 > 62797 0 > 00000
-
Comparison Report - Flags Changes but cannot Identify What
Hi, I've made some changes to a model, and run a comparison report. The report flags I've changed some Dashboards. Not to my knowledge! Digging through them carefully they look the same, with the same content as before. Also the Comparison Report says I've made changes to a list of Saved View - again not to my knowledge,…
-
Populate Module with Data from a module with different dimensions
Hi, I'm trying to add data that has been calculated in Module A to module B. Module A: List 1 Time Line items, where one of them is: Account XPTO1 (data's format is number), Account XPTO2 and Account XPTO3 Module B: List 1 Time List 2 (where we have accounts) Line items, where one of them is: Final Value (data's format is…
-
Lookup from Different Dimension
I have Source Module like below. It has SKU as dimension and line item "Exhibition Year Season" and "Exhibition Year". Both line item are using list formatted data type. I want to lookup Exhibition Year in Target Module based on Exhibition Year Season in Source Module. So the result of target module will become like this:…
-
Failed to retrieve field list from the selected data source. Please check your import settings and
Hi I'm received this error and it took a while to work out what it was. In the "Source Models" it was pointing to the wrong environment, this is confusing because I could still see the "Saved Views" to click on, it would bail out straight after that with the error. The complete error is: "Failed to retrieve field list from…
-
Show the last date and time a process was run on a dashboard
We have a process to import live orders, and it takes a little time to import the data, it is used up to 7 staff members, and as they are working from home a great deal they sometimes all run the process one after each other, which can be draining on the system and my mood It can be run 40 times a day and only needs to be…
-
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…
-
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.
-
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
-
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?
-
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.
-
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)…