-
ALMing multiple revision tags into Production environment
Hi, I have a scenario wherein I have multiple revision tags ALMed from Dev environment to the UAT environment. They have been synced in the correct order. I now need to sync to Production with UAT environment. I understand that revision tags are cumulative in nature but wanted to understand any possible implications of…
-
Activity: Prepare Data Exports
Hello, i had a trouble to understanding to fill the formula on "Code" line item, if the purpose was to get the code on G3 Location, why don't just make the line item format List and refrence G3? well i try that, and i got another question, why you cannot refrence straight to G3 grid Code? and what the downstream mean in…
-
Export Function
Hi Anaplanners, Hope you all are doing good! I have one question regarding export. Lets say we have module dimensioned with 4 dimension . And we cannot add 4 dimension in row. I have added time dimension(Year) in Page selector. While exporting I dont want time to be displayed in export file. Is there and possibility in…
-
Restore to ID in production model (Deployed)
Hi We have a development model (standard mode) and a Production model (Deployed mode) with ALM between them. The latest revision tag was pulled in Production more than few weeks ago. A production user updated data in production model last week. They haven't made any significant change since then but want to revert that…
-
Exporting and distributing management reports
Hi, We have created some really great looking customer reports in Anaplan but it is very time consuming exporting each individual customer report and then renaming the file to the customer name. We have over a hundred customers to issue reports to. Has anyone in the community come up with a way to expediate this process? I…
-
Still stuck on "Confirmed PO Delivery" and "Confirmed PO Receipt", something isn't adding up.
I'm honestly not sure what to say about this one because I thought I had nailed down all the formulas, and then the corrected formulas, but here we are. I think I can narrow down where the errors are taking place, I just don't know how to correct them. In all truth, I could really use a review of all the formulas in…
-
complex load from SAP to Anaplan that cause performance issues ?
Q :When dealing with complex data loads from SAP to Anaplan that causes performance issues ?What are the approaches need to consider in mind before or after the load ? Q : And the load happens now model is taking more time to load ? How to tune the model in this scenario?
-
Pulling list property into a module
Appreciate that it is recommended to avoid using properties in lists, however we do have a couple of instances of this in our model. Just looking to pull one of these into a module that we have already created, shown below and was looking for advice as to what formula is best to try and achieve this.
-
Module Mapping History Check
Hi All, I have a mapping module that maps GL account to P&L line items. please how can I check the historic changes in the mapping module. Is there a way to check it rather than going through the model history? Your help will be really appreciated.
-
Modeling Performance
Hi Team, I would like to get the next year summary value into previous year’s month. If we need current year summary, then we can use YEARVALUE function to achieve but we need to bring data from next year so we can use either LOOKUP or TIMESUM . I would like to know which function is effective between LOOKUP and TIMESUM.
-
Can you find the mistake in my formula or somewhere else?
It looks like my formula is not working because nothing is filled in? how can I solve this problem? it should get data from here: And here: Thanks in advance! Kr, Eva Lagae
-
Export Filter Issue
Hi Anaplanners, I am using a classic dash board and have a module saved view with 4 lists pivoted in the row and Time, then I have a native version on the page. The problem is when I filter for a version and time using a filter module, the filter works perfectly to filter the module based on the filter selection and when I…
-
How should I form this formula?
I have the modula SYS08 employee details where my bonus% is 0 but I know the role and department. And I have this modula EMP03 empolyee drivers by role where I know the bonus for every role in the end I want to know the total bonus for the sales department in December. So I want to look in EMP02 Employee expenses to my…
-
Need help related to custom Time Dimension
Hello Everyone, Want to create module which captures data days wise, but the challenge is the data should be Displayed in two ways. So, If current forecast day is 6th Aug, so 1st Column named "Till Date" will be showing Summation of 1st Aug to 5th Aug and remaining days will be displayed in further columns which will sum…
-
Issue Bringing List-Formatted Line Items Across Modules with Different Dimensions
Hi Community, I'm currently building a report where I need to compare Budget and Actual values. As part of the client requirements, I need to include additional attributes for each employee (Resno), such as: Position Title Grade Supplier These values are list-formatted line items in the source module, which has the…
-
How to Bring a Line Item (List-Formatted) from a Module with Different Dimensions
Hi everyone, I'm facing a challenge when trying to bring data from one module to another, and I believe the issue lies in the dimensionality. Here’s the situation: I have a source module with the dimension IDLoader, which contains codes like 2025-01_91001_BU10114_Q10068_SU19999. From that code, I extract different parts…
-
How to Auto Populate a Form for Users?
I’m working on a page that includes two tables: Module 1 (called CRM Table): Dimensioned by L4 Employees, includes line items like Term Date, Role, and Department. Module 2 (New Hire Table): Dimensioned by L4 New Hires, with similar fields. Both L4 Employees and L4 New Hires roll up to L3 Department in the same hierarchy.…
-
Reducing calculation effort
Currently looking to make use of the feature where can now see the calculation effort entailed in certain line items and I've already been able to eliminate or refine a number of elements in various modules but just wanted to check in terms of best approach to take to this next one. I have included a copy of the formula…
-
Sumif based on month ?
A first module collects a quantity per month, client, and product. For each month/client/product, a warehouse (list element) is defined. Based on the warehouse, the start month is calculated (Time Period Format). My goal is to be able, in another module, to sum the quantities by products/warehouses/start month. When I try…
-
Opening Capex Code not referencing Closing Capex correctly
Dear Model Builders, Please refer my attachd Opening Capex code which I believe not referring to the previous month's closing capex correctly. Appreciate your help on finding the cause of error and possible solutions. Thanks