-
Transfer Value from Time Period to List
Hi everyone. i have time period (weekly). since weekly is the same as gregorian calendar. so i created a list which week 1 to 52. now i already have data from a module which has a time period. my mapping: sample is week 8 from Cash Balance Beginning - Copy, it did not reflect in Sys Time Mapping.
-
Get previous Item in current list
Hi everyone, in Time period, i can use PREVIOUS() function. In my module, i dont have time period so i created a list which has Week 1 to Week 52. if data from module cash balance is 0, then previous ending balance will become the beginning balance. but it gives me error. here is my module.
-
How to send Delta loads from Hub to spoke with dimensions ?
Iam having few questions in anaplan build .Some one please answer. Q1. There are Business units the team wants to look for different Versions Variance 1. Variance 2018 to 2022 (2023 not to be considered) variance 2. 2019 to 2023(2022 not to be considered) Variance 3 : 2018. Q2. There are 3 years of data in hub. How to send…
-
how to compare week time to month period time
Hi may i know what would be the best way to compare the week (time) to month period? Thank you.
-
How to Push Selective Data from One Module to Another
Hi ALL, I need assistance with setting up an integration between two modules in the Model. I have two input modules, Module1(Dimension UID1) and Module2( Dimension UID2). We have few common columns between two modules. These should be populated. When running the integration, I want to transfer data from Module 1 to Module…
-
Count the total number based on filter KPI
Hi, I have a Count line item of employees that has a formula of 1 in my employees module. I have a Total Count line item on another module to show the Total Count based on Filter that has a formula of: my Filter formula is: How do I show the total count of employee based on the filter? Thanks
-
Show all data if no user filter selected
Hello, I have a user filter selection. It only shows data after filtering. How to see all the data even without filter? Thanks.
-
USER Time Filter Selection
I need to filter Months based on the user selection . If user selects FY 25 corresponding months should be displayed.
-
1.4.3.2 Import Data & Add Formula - adding formula
Hi, I try to add formula to the code line, but I get error that says 'code does not apply to any lists', what is the problem= Kind regards, Katja
-
sort functionality for nested dimensions
In our Anaplan Model, for one of the modules , we moved the dimension from the Context selector to the Rows section. This is because we want the user to select the dimension using the "Field" Card [dropdown] instead of selecting it from the page selector. Based on the user's selection from dropdown, entire page will be…
-
Need help with a time filter
Can someone please help me implement the given scenario. I have implemented it but there are certain loopholes that I am having trouble fixing. Scenario1 : I have a module with version list on rows , 4 line items(1,2,3,4) on columns and Time range FY15 on columns after line items. For LI 1,2,3 I only want to see years and…
-
How to delete List with Zero Across all Years and Not a Single Year
Hi Anaplaners, I have a data upload using list properties. I would like to delete the List for Store with zero values in a calculation module Dimensioned by Store List. The problem am facing is when I capture the sum of value with zero and I delete the Store List in the system module using "Delete using List selection" it…
-
IFP &OWP available in Polaris?
Hello, Do the new Integrated Financial Planning (IFP) and Operational Workforce Planning (OWP) applications support Polaris, or are they only available out of the box on the Classic Engine? Thanks in advance to anyone who can help!
-
Plan IQ Setup
Hi Team, I have a Demand Quantity for different products. I want use PLAN IQ to setup the forecast. I have followed the PlanIQ training video but as i have no Related data and attributes data. The process is failing. Could someone please assist on this. Dimensions: Product, Orders. Data: Demand quantity in (Data wise…
-
How to avoid showing disabled parent from Drop Down list Selection
User is not willing to see parents in drop down list selection. By creating a flat list of my level 4 and by creating mapping between L4 and flat list we can fulfill the ask but I am looking at multiple options on how to achieve this. Feel free to share the approaches if any.
-
Quarter Filter
How to create a user specific filter, where user selects a particular year, and only those quarters of year selected should be visible?
-
Create/Show Grand Total Column
Hi everyone, is there anyway i can create/show the grand total of all fiscal year in column time dimension? like if i have FY23,FY24,FY25 and FY26, then the next column is Grand Total. Thank you. Update: FY columns are from Time dimension and not item list.
-
Level Mismatch Error
Hello All, I am getting level mismatch error while set up the summary method as ratio, i am not able to set up the applied to and ratio as describe in the below ss simultaneously. what is the possible reason for the error and any ideas and suggestion would be appreciated, thank you for your help.
-
3.4.3 Activity: Create Country Summary Module (SYS08 SKU Details)
Having issue with SYS08 SKU Details "Country Made In" formula tried both formulas. I believe its because its a list that I am searching in but not sure best resolution would be ? Formula: 'SYS07 Distribution Center Details'.Country[LOOKUP:'SYS07 Distribution Center Details'.Country ] Error: The dimension of mapping used…
-
Faster method for SUM from multiple sources
Hi Everyone, Can anyone confirm which of the below is faster? Final Line Item = Module A. Line Item A [SUM: A, SUM: B, SUM:C] + Module B. Line Item B [SUM: A, SUM: B, SUM:C ] Line Item 1 = Module A. Line Item A [SUM: A, SUM: B, SUM:C] , Line Item 2 = Module B. Line Item B [SUM: A, SUM: B, SUM:C ] , Final Line Item = Line…