-
Bring info from another module
Hi everyone, i´m having some issues here trying to bring information from a module with different dimensions. Data should flow from a line item called Style function plan to the target, any suggestion here? Here are the dimensions: Source: P4 Department (rolls up to p4), Checkpoint meetings, Combined Climate, Sub C3: LY,…
-
Invalid Name
Hello Experts, Greetings for the day!! I am trying to import data from data hub into spoke model. While I am importing I am facing one error "Invalid Name". I have checked both data hub and spoke model same list item is present in both models and there is no mapping issue. Could you please help me with this issue..…
-
How to extract Previous Column Ending Balance as Current Opening Balance (without time dimension)
I want to track the Opening balance, drawdown, and ending balance for the following specific dates. I created the following dates in General List. Then I created the following module to track the balance, which there is a line item called Beginning balance which is the previous value of the Ending Balance. Draw/Repayment…
-
Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
-
ALL with LOOKUP . Does it impact performance like SUM with LOOKUP
Dear Anaplan Community, We know that SUM and LOOKUP shouldn't be used in the same formula, as this can negatively impact model performance. However, I’m wondering whether using ALL with LOOKUP is also considered a violation of the Planual, and whether it affects performance similarly to SUM. To me, the logical answer is…
-
別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいです コンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
-
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
-
Can we apply DCA on one line item for the different accounts?
To be more specific, I have only one Boolean line item called "submit?" with a different accounts. At a time, I need to check only one account Boolean and other accounts boolean needs to be disabled. Can we achieve this with DCA? Any help much appreciated!
-
実際の生産日の割り当て
必要数データに、実際の生産日が割当たるようにしたいんです。累計とかをうまく使いたいのですが、、 必要数モジュール No 品目 日付 数量 生産日付 #1 A 10月1日 100 9月2日 #2 A 10月2日 200 9月2日 #3 A 10月3日 300 9月3日 #4 A 10月4日 200 9月4日 #5 A 10月5日 100 9月5日 ↓ ↑ ↓ ↑ 生産モジュール 9月2日 9月3日 9月4日 9月5日 A 500 100 200 100
-
How do I create a dynamic picklist upon Boolean selection?
I want to create a dynamic picklist, where I will check boolean from a line item, only true values will allow me to select list items else on default it wont show anything. For example: Assume a scenario where I want to assign at least 1 employee who is present in my office to become the pantry inspector & review the…
-
What's the impact of using SA for a child list for getting filtered list items in dropdown?
I have a 3-level hierarchy, where the parent top 2 parent list is selective access enabled. I want the bottom-most list to also have filtered dropdown based on its parent's selective accesses. One way I was able to do it is by enabling selective access for the child list and enable Selective Access Boolean in the Line-Item…
-
Create a Data Hub from scratch.
I'm new to Anaplan and would like to understand how to create a Data Hub from scratch. What are the best practices I should follow, and what are the key steps involved in building a Data Hub model? If there are any official documents, learning materials, or links that can guide me through the process, I would really…
-
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…
-
On demand Model building courses - check my work
Good afternoon, Is there any place in anapedia where I could check my work? If it does not exist yet, may I suggest to create this area somewhere in the plat-form? With all my respect, it is a non-sense not being able to check if the line items written are correct or not and stay stucked in the middle of a course. About to…
-
Can we use filters in 2 tables?
Using filters can we show resluts in 2 tables? eg: Grid table and chart table? If yes, then Grid table has list employees in geo level with status of approvals. But in chart I want to show geo level total % and total count in geo level for all employees.
-
BooleanがTrueである最終日を取得したい
ディメンション：日付、生産ライン ラインアイテム：Boolean 上記モジュールにおいてBooleanラインアイテムがTrueとなっている最終日付を取得する方法を教えてください
-
I want an understanding of time offset for text value
I am trying to create a module where I need to add a text value in IST and the same will populate in PST and GMT timing. I have created a module with DAY time dimension and with a list defining 00:00 hours to 23:00 hours and added 3 line items (IST, PST and GMT) Now I have added a formula in GMT IF ISNOTBLANK(IST) THEN…
-
Identify Decimal Records
Hey Team, I have a small doubt. User has entered some records in a module out of which some of them are decimal records like 1.5 or 2.5 and some are 1 or 2. Here I need to identify those records which have decimal in them? Also, I was thinking it to make 1.5 as 1, 2.5 as 2 and leave 1 and 2 as it is since it is not…
-
Filter a list by a selector
I have a page that has a list of sellers and a list of accounts. The list of accounts module has a line item of the seller. Is there a way to set up a filter with the accounts card to filter out accounts when I select a specific seller?
-
Quick Sum only providing the sum of the previous selection (App UX Grid)
Noticed an issue with the Quick Sum on a grid in the App UX where the quick sum seems to be showing me the previous selection in the quick sum field. Example: Dec 2025 <> Jan 2026 $100 <> $25 $100 <> $50 I select the 2 rows in Dec 2025 and will not get a total. then select the 2 rows in Jan 2026 and the Sum shows $200 (Dec…