-
Dynamic Cell Access by Role
I am looking for suggestions / alternative approaches for managing DCA by the user's assigned Role. Ideally, there would be an easy way to maintain this going forward. 1) I have heard a rumor that there is a trick wherein you somehow create a filtering module, then use the normal Roles>>Modules access assignments. Access…
-
Counting a Project name
I am counting the project item(List: Project name) based and generating a unique number by adding +1 to count . everything is working fine until a situation comes where i have to delete some existing projects. When i delete the project → my count reduces and the way i am creating a unique number which is by +1 to my count…
-
Copy paste formula from excel into Anaplan blueprint
Hi Anaplan community, I wanted to make a quick fix to existing formula in my Anaplan blueprint view, so I exported my blueprint view to Excel, used the find&replace functionality in excel to update all my formula at once, and then I wanted to paste back my formula in Anaplan blueprint view, but it gives me this error…
-
Import Issues
Hi All, I'm currently facing two issues related to import. I have one module (split in three tables in UX) in which the user imports data. Here's the module: The import action works perfectly well for me but not for them. Apparently, the system is considering the comas as decimal separator while they consider it as…
-
Time text format?
Hello everyone, I hope you are all doing well. I am writing today to inquire about the best formula to transform text from the format DD/MM/YYYY to DDMMYYYY. For example: 02/04/2024 should be transformed to 02042024. Thank you!
-
How to lookup currency from module based on selected filter
how can i lookup the currency rate based on filter that i selected in REP01 Long Term Loan Payable. General List: LO05 Currency Module: SYS03 Foreign Exchange Module: REP01 Long Term Loan Payable
-
Adding a list (as a page) into a pre-existing module
Hi. In one of our modules, are current pivot set up is: Pages: Version Rows: Line Items However, we need to add a list '# Customer' into Pages, to get the below pivot view: Pages: Version, #Customer Rows: Line Items Is this possible without creating an orphan/ duplicate module? TIA. Josh
-
Need count to work dynamically depending on the list size
Hi, I have a requirement where in a module i have 4 dimensions (2 as page filter, 2 in the rows), Also line items are on column. (No time as dimension) I need to have a formula where it should reflect count of the line item starting from 1 to as many as the line item count is. And this should be dynamic based on the…
-
Numbered Lists (With a parent)
Hi, I have created a numbered list (# Customer Number) successfully (with no parent, code as customer code, and name as customer code name). I'm trying to now create a numbered list as a child of customer number called '# Customer Name'. I bought in the below on the import: Parent Name Code Parent > the same code as noted…
-
General Question on Locking the Actuals
Hi All, How do you manage the master data changes? As the changes in anaplan are retrospective. Lets say there is a change in the master data and it will impact the actual numbers reported. Is there any native way to lock the numbers? Please don't recommend the snapshotting process as it will not be sustainable for my…
-
How does one safeguard against losing data with changing current fiscal years
I would like to use the out of the box TIME dimension/logic. However, I do have concerns about losing data if a fellow model builder inadvertenly changes the current fiscal year. How have others handled this situation? We have considered building exports to backup these modules every night and store the data outside of…
-
Data Loss with Inroducing Time Range
So in the current setup, a module is dimensioned by Model- calendar time dimension and the horzion is from 2021 to 2026, the granularity being weeks. This setup is used in prod since go live for 2 years now. We realised the span of time for data in that particular module can be reduced. Idea now is to introduce a time…
-
Using SUM to map data from a parent to a child in the same hierarchy
Is it possible to map data at say level 3 in a hierarchy to a level 5 item using SUM function? I keep receiving a 'Level mismatch on common dimension' error so I assume this is not!! Thanks, Chris
-
Can ANY be used where the source contains TIME dimension?
Hi All, I am try to query the presence of a list item in a source mapping where the source contains TIME dimension. Source contains one list combined with TIME where a mapping can differ across a year. I want to query this mapping to determine if a target list is in use at any point during that time period. I use this…
-
Can we add numbers of list item in a numbered list by taking input from user?
For Example: If user entered 10 then 10 list item should get created in the particular list.
-
Create a number sequent in a period column.
Hi everyone. what is the formula on adding a number sequent in one column like 1,2,3,4,5 etc. i tried RANKCUMULATE but it returns all 1. by the way this result was already filtered. thank you.
-
TIMESUM from a Module with time dimension to a Module with a fakeweek dimension.
Good afternoon, I am trying to map the data in day format to a fake week dimension using a timesum. I have a start and end period in DATE format but the formula only gives me a result when this two are the same. This is the formula: This is the source module: With the data imported to day. And this is where I map each week…
-
Adding actions to processes
I am on Level 2 Sprint 1 training, here now I have created actions but now I want to add 1.5 and 1.6 to the processes to 1 Load products and T1.1, 1.2, & 1.3 to T1 Build Product Hierarchies. below is the SS for reference. Can anyone help me with how can I do that?
-
Error when importing a concatenated numbered list
Hi Guys, Please what might be the issue with this import error, I'm at my wits end in trying to solve this issue. I have created a concatenated unique code from these five fields on this module When I import the Driver Tree Combination into a Numbered List due to the characters is long It throws these error and does not…
-
Dynamic naming line action matching names in Actions
Hello. Quick question. I've implemented Dynamic renaming line items similar to this. The question I have is that I use both modules where I dynamically rename line items (Source and Target) in an action to copy calculated information into a snapshot (e.g.: REP9 into REP09b). Would I need to remap line items in the action…
-
複数のラインアイテムを条件にして、結果List内を検索したい
Test_listメンバー検索 Moduleを使用してリスト内を検索するModuleにしたいです。 検索条件は画像2のとおり、 検索条件1：Text 検索条件2：list: 検索条件2(検索条件2はNumbered list) 検索条件3：Text です。 検索結果ラインアイテムにどの様な関数を検索結果に入れなければいけないかアイデアが欲しいです。
-
Anaplan Workflow Access
Hi All, I've given access to myself as workflow owner but not able to see workflow tab . Can anyone have idea about that?
-
Import Error Issue
Hi Anaplaners, I'm importing a list hierarchy with 3 levels. I have added a prefix "DR1 -" for level 1 code and "DR2 -" for level 2 code & "DR3 -" for level 3 code to the hierarchy items to make them unique for successful import. But yet I'm getting an error "Invalid Parent" Below is the screen shot of the highlighted…
-
Spacing between number formatted line items that include units.
When we format a line item to include a unit, Is there a way to remove the space between the unit and the value? lines formatted to include the USD currency unit look like this as a default: $ 1,234,500 I would like to know if there is a way for it to appear like this: $1,234,500
-
The ITEM function should take a hierarchy as argument
I'm not quite sure why i receive the a/m error. Module: Formula: Error: The formula for 'REP01 Long Term Loan Payable'.Effective Interest is invalid: Effective Interest = IF Is Month Included in Period? THEN IF START(PERIOD('L1 List of Loans'.Date of Loan)) = START(ITEM(Time)) THEN 'L1 List of Loans'.Amount *…
-
How to start in a row based on specific date
Hi everyone. may i know how can i start in a specific month row based on my specific month or date. Here is my criteria: and this is what i want to display in m y module: Thank you.
-
Planual Explained - Day 5
Rule "1.05-03": Article 1, Chapter 5, and Rule 3 – “Avoid using List Properties” List Properties are same as line items but have many limitations, so keep it simple and have one place for calculations i.e., Module line items. This goes against P and A of PLANS if you wish to create list properties. Here is how it was done…
-
I NEED HELP ASAP
Hello, I have already a production model and i need to create 2 models X and Y . The X and Y models should be deployed and linked to the production using revision tags. Therearefore, i copied the production model twice. But when i pass a revision tag in the production i can only synchronize the Y model ( because it is the…
-
ALM enabled between 2 Dev models linking to the same Production Model
We have the usual setup of DEV → UAT → Prod copies of a model. We've took up a model optimisation activity which would involve deleting redudant models, changing dimensions, and changing logics. all aimed at reducing size and improving performance The bottle neck is that this activity will go on in parallel with the…
-
What have you found to be the biggest roi in terms of model optimization?
I have a very slow model that I want to start optimizing. There's obviously a lot to do. Anyone have any great success stories? What did you do? Where should I start?