-
Anaplan Data Import Issue: Numbered List Code Mismatch
Hey Team, I'm facing a bit of a challenge trying to pull data from a source module into a target module. Here's the situation: The source module has a numbered list dimension, and I need to bring one specific module's data over. I've already determined that the target module also needs to use a numbered list because there…
-
In Level 2 - Supply chain model - do my time settings look right?
The only reason I ask is because I've been unable to achieve some of the UX pages and, asking in prior questions, I seem to have everything right but the UX pages still aren't working. Would someone mind taking a look at my time settings? Thanks in Advance!
-
Is there a way to filter the dropdown in a Report page similar to the Board page?
Hello, Is there a way to filter the dropdown in a Report page similar to the Board page? I don't have the same capacity when in the Report page. There's no Gear icon to filter: Below is the screenshot from the Board page where I was able to filter my toggle dropdown:
-
Is there a way to remove the extra empty columns in Report App?
Hello, I'm building report pages. Is there a way to auto-fit the data such that empty columns won't show? It would look so much better:
-
Identifying orphans in a composite hierarchy for deletion
Hi, I have an L2 list that is used to capture staging data. The parent to this list is L1. The user runs a import action via the UX and a csv file to load serial numbers into the L2 list (L2 is a numbered list) The user has been provided a template to upload the L2 list wherein they need to enter the parent and that is…
-
How to calculate number of months between two dates when one date falls outside of model time range
I am needing to calculate the number of months between two dates, one of the dates falls outside of the model time range. I am needing this so I can do a straight line depreciation cacluation but the # of months formula returns a blank value because of the date/time range isue.
-
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…