-
実際の生産日の割り当て
必要数データに、実際の生産日が割当たるようにしたいんです。累計とかをうまく使いたいのですが、、 必要数モジュール 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…
-
How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
-
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
-
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…
-
Data staging list and module - Manage Inactive items not included in import file
I'm currently working on a development where I need to update and validate data through an import process. Here's the scenario: I have a module that tracks active locations, and data is imported into this module from a file. Initially, there are 10 active locations included in the file and imported successfully. However,…
-
L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
-
Filter on quarter time period in an input field
Hello, I have created a quarter time field on a ux page. I can select all quarters in that field. I now want to be able to only select the Q2 and Q4 quarters for that input field on the ux page. How? Thanks! Kind regards!
-
How to sum total only required quarters
Hi Community, there is requirement for below where module is dimensioned on Versions and versions are page selectors It should be adding Q3 + Q4, but FY25 shows Q1+Q2+Q3+Q4 Requesting for your inputs on this can be setup I know filters has to be built around missing out on logic Thank you
-
Invalid Parent - Combined List
Hello Anaplan Community, I have a product hierarchy with 5 levels . For a client requirement, I need to transform this product hierarchy into a combined list , to be able to select different levels of the hierarchy in a line item (drop down list) For this, I tried to create different saved views where I have for example :…