-
NO Time dimesin module to Time dimension module
HI I want bring the data from non time to time module. as mentioned screen shot
-
Restore archived model of a deleted workspace
Hello, It is possible to restore an archived model included into a deleted workspace. Thank you in advance for your answer! Regards
-
Can I have a code in a list mapped to different parent between two time periods?
I wonder if someone have come across of this use case: Our reporting hierarchy is based on Cost Centres i.e. Cost Centres are mapped to Business Units (Parent/Child relationship). There was a request to move a Cost Centre between two Business Units in July going forward, meaning that history remains unchanged. When I…
-
model search
Is this search feature buggy? I don’t think it is working as is. For example see below: I search for ‘calc’ I only want results with calc in it Below also gives results with references that contain c AND a AND l AND c This is not correct. The search is limited here. The Boolean logic behind the search does not seem…
-
Process Ignores one of the Action in it
We have one automated process which has five actions in it which clears the list and reload the new items in the hierarchy. When the automated process runs it ignores the last action which reloads the list. Upon checking we found that the Server has the necessary access to run the action and also the source system(i.e.…
-
SYS08 Product Family issue in Level 2 Sprint 2/3
In rebuilding for the 2nd time due model loss, I am having an issue with getting the products to be assigned to their product family so I can get the correct values in SYS08 SKU Details and then use it in DEM03 Demand Forecast. Images are what is in SYS08 and the Blueprint of it. Where am I going wrong, it has become a…
-
Is it better to use CODE(ITEM( SKU List)) or to use SYS SKUDetails.code?
Hello, I need to concatenate two codes because I am generating a combined list. My first instinct was to utilize the function (CODE(ITEM()), but the example I saw in ANAPEDIA used the the systems module Line item [SYS SKUDetails.code]. Given that I don't even have a system module, I'm unsure if doing it this way is a bad…
-
Sequence of list elements creation during imports
Hi, As part of a requirement, I am looking to gather more information on the order in which the list elements are created. Consider my source as If I want to use the above view as a source and create list elements , 'A', 'B', 'C' and 'D'. Can there be any possibility that instead of creating them in the order , Anaplan…
-
List Item Change
Hi Guys, I have a change in the list item in Anaplan, the list is marked as a non prod list, I have to check the references for the SVs direct update in Filter, is there a quick way to do it? Though I have checked for the list references. Thanks, Anmol Sarna
-
Period Function is not giving the desire output.
Hi Anaplaners , I am using the PERIOD function to populate the month from the date-formatted line item. In my case, it worked fine till FY26, but it is not returning anything after December 31, FY26. My hunch is how Period works with model calendars?
-
Did anyone faced this issue, why Anaplan is not allowing me to fetch Items using FINDITEM formula?
I have a list named Custom Weeks, and applied FINDITEM formula to get items against 'Next Start Date Text', but except Week 40 FY22 and Week 49 FY22, FINDITEM is not fetching items from the said list. Need help. Formula for 'Next Start Date Text' : TEXT(MONTH(Start Date + 7)) & "/" & TEXT(DAY(Start Date + 7)) & "/" &…
-
About deleting module data
Hello, I want to delete the module's data efficiently. With 100+ modules, manually removing them one by one would be too time consuming. Don't you know how to do something? Thank you
-
Using the same DEV for 3 different production models
Hello All, I use the same DEV model for three different production models that represent three different divisions at the company but pretty much the same design. Recently, I needed to add new developments to one of the models, but I do not want to push that functionality to other two models. Now, I need to make a new…
-
11.3.4 Activity: Add Formulas to Profit & Loss Report Module
Hi. requesting assistance in this part. I am not sure what I am doing wrong. I have transfer the file as directed but the number for forecast do not match. The data should be like this. Thank you
-
Line Item that keeps subtracting based on what's left
Hey, I would love to know if you can help me with this case. I'm trying to subtract the value of one Line Item from another depending on the result of the first one: For example, a projected stock value versus my financial target. It's easy in Excel, but I'm not sure how to perform this operation in Anaplan using a single…
-
How to deal with 3 dimensions having many to many relationship?
I am having some trouble connecting dimensions because I have a relationship with many-to-many and therefore I can not use LOOKUP as I am used to. I feel like I had some trouble explaining the problem before so I will use some screenshots. I have a model for a book retailer, and my final goal is to determine the…
-
Filter only those changed line items
Hello, I want to apply a filter to a module in order to import the new values re-writing the old ones. Let me explain a bit. I have a module dimensioned by Projects (a,b,c) This is my view of the grid in the first phase: Project Start Date End Date New Start Date New End Date A 15/8/2023 30/8/2015 B C Second Phase: Project…
-
"Fake Versions", vs. Native Versions. How do "Fake Versions" work and how do you set them up.
A lot of organisations seem to use "Fake Versions", vs. Native Versions. How do "Fake Versions" work. Please could someone explain how to set up and use "Fake Versions", How they should be used and of course how they work (the logic underpinning them). Thanks
-
Best practice for building a P&L with custom summary levels?
Hi, What is best practice for building out a P&L? The P&L applies to an existing list L2 GL accounts however, there are additional summary levels (ex. total travel) and calculations (gross margin, net income) that dont exist in the L2 GL account list but are required for the P&L report. See picture for example of…
-
Error message
Hello, I need help in creating a formula that divides the sales of a single week by the sales of the entire year. I am utilizing a custom calendar. When I attempt to use the SUM function, I encounter the following error message: "The name ' used in the SUM clause is not recognized as a line item in the model." I have…