-
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…
-
Working with Opening / Closing Balances and 'fake time'
We have an Anaplan model that uses "Fake Time" - that is a time dimension specifically constructed for the application and not one found native to Anaplan. For this reason the Opening / Closing Balance summaries don't work. We would like to be able to show the opening and closing balance at the beginning end of each weekly…
-
L3 Sprint 1 : Sales Planning
Hello everyone, I created a new model to display the Sales Planning using the PY Revenue from DAT02 Revenue and the PY Actual Revenue from TAR02 Account Review, applying the appropriate LOOKUPs and using SYS99 to retrieve the % of Account Sales Target. However, when I compare the results of my build with the results shown…
-
Quarter to Monthly
I have 3 modules. First module has list with yearly values. second module has line items that convert the yearly data to quarterly. I want to convert quarterly data monthly in third module. The quarterly module has override capabilities so if user select set annual to 0, then the total for that year will be 0. If user…
-
YTG, YTD Summary in Polaris
Hi All, Wanted to quickly check if the YTG, YTD summaries are not enabled for Polaris model yet unlike the Classic model. Thank you, Harshitha
-
Cell count is too large error
Not seeing existing posts about this error. How to resolve this?
-
Why the return value is False?
Hi experts: I put all the values into the formula, I think it should return TRUE, not FALSE, but why it return me FALSE? Maybe I missed something here ? Thank you for the help!
-
All of my DATA01 is cleared after 2019, is there any way I can fix this?
All of my DATA01 is cleared after 2019, is there any way I can fix this?
-
12.4.1 Activity: Create Saved View for Non Employee Expenses
Hi, for some reason my shipping costs are the same over every month and I don't know what to do to fix it.
-
Sorting in Combined Grids
Hi Team, I have been trying to apply a sort based on a column in one of the combined grids and seems like the option is disabled. Does anyone has any idea on this? Regards, Aakash Sachdeva
-
Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
-
Replace a line Item in the whole model
Is there any easy way to replace a Line Item in the whole model in all formulas? right now i have to check hundreds of modules to switch out a Line Item, which is quite tedious //GP
-
Anaplan Report page issue in the UX
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
-
Selective Access Challenge: Summarizing L3 Inputs at L1 Level Without Losing Granular Access
Hi Community, I’m working with a hierarchical list structure in Anaplan: L1 Region (e.g., Asia, Europe) L2 Country (e.g., India, Pakistan) L3 Local Input (e.g., Mumbai, Lahore, Islamabad) Users are given selective access only at the L3 level (specific cities like Mumbai, Lahore, etc.) so they can input data at those…
-
data import from module
I have source module having key (combination of location and department) as a dimension and target module has employee list as dimension. i want to pull amount from source to target that should remain same for all employee having that key (key added as line item in target module). what could be the best way to handle…
-
Solution for when 2 time dimensions needed
As shown in the screenshot, each monthly amount (Jan, Feb, Mar 2024) needs to be paid down in the future months (Jan–Aug 2025). The paydown must satisfy certain conditions specific to each month between Jan and Aug 2025. If the conditions are met, the paydown can occur. For example, if $20 is available to pay in Jan 2025…
-
How to get live small project for learning more.
I have completed level 2 certificate still I am not confident. I want practice more, where I get small project for practice.
-
Is there a way to auto-generate ID for user who entered line item?
In the UX, I want to be able to filter list members so end users can only see the list members they created/added. The users in this situation all have WSA access as this is a UX for our internal Anaplan team. These list members are currently being added by the form action in UX and I would like to avoid the user having to…
-
LOOKUP and FIRSTNONBLANK used in the same formula
I have two modules in Anaplan: Module 1: Name: dat_Fund Composite Dimension (List): ad_Fund Composite ID Module 2: Name: dat_Segment Dimension (List): ad_Segment ID There is no direct relationship or mapping between the two list dimensions. I'm trying to understand how the following formula works: Line Item: L0 Segment ID…
-
Capacity Model
Hi I am fairly new to anaplan and this is most likely the most basic question but I have created a model that indicates the number of "working days" within a calender period - my aim is to get the number of Days in a particular month that we have available to work. I have created the below model to get number of working…