-
target with more dimension than source
Hi I have source module by GEO and ORG, However, I have target module by GEO and Time dimension. In the source module there is a mapping between GEO and ORG, So the line item is list formatted. How do I get the mapping to the target module. For example, if GEO 1 is mapped to ORG 1, I should get that in the target…
-
Target module with less number of lists
In my situation here, I have a source module that has two dimensions - EMP and Geo and Time and line item called MAP which is list formatted (GEO). Target dimension has one dimension EMP and Time and line item that is list formatted (GEO). I want to bring in the Geo from source to target in this case. Since the target has…
-
Level 3 Sprint 4.5 Finalize Assignments Action Button
In the screen shot for 4.5, there is an action button for "Finalize Assignments". I have read through the user stories and the in the build steps and I cannot find any reference to this. What does this action do?
-
How to Count the recurring combinations of List Members
I want to Count the recurring combinations of Time, Employee, Project and Fund but the issue is that the List is too big to use Sum function, I need some other means as I cannot even create a TRID for it due to lot of List Members and also I am unable to create a Staging Module or anything like that to do the task. I want…
-
Entity or Country First
Hello, We're considering launching into a new country, how would be best to structure this in the organisational hierarchy? Country first, then entities; or entities, then countries. For reference both entities will be trading in both countries. e.g. Total Company > UK, Germany > Entity 1 - UK, Entity 2 - UK, Entity 1 -…
-
How do we take the Current User and apply a filter on a view?
We have created a module SYS11: Current User with dimension Users. Per the instructions found we set in Blueprint Users List = Show all users:Off Now we want to take that user and apply a filter to Sales Detail on UX page to show only the transactions related to that logged in user. We are struggling to figure out how to…
-
SYS00 Time Settings'.Forecast Period? is not a recognized line item or list member
Hi team am receiving an error
-
Get the values from one cell data to another cell
Hi Please go through the screen shot source: it is input by the user Target : we have period dimesion . now i bring down the data from p2 to p13 at what they inputed. for Dp1 conventional. they want take value from CV vol coff -conventional. for organic they want to take from og vol coff . in sys module i will add another…
-
Help me with a formula.
Hello Community, I´m trying to get in a module from a formula to know if an employee has for reporting only and distributor accounts here is my formula: Here is the module from where i want to pool the info: Not sure why but my formula on the Has report only or distributors accounts are not working as intended, not sure if…
-
How to get the values form different time periods
i want to get the values from non time period to time period module. how shouid i get it
-
What is the process for viewing a workspace map like a model map in Anaplan?
Hello, I'm attempting to figure out how to examine workspace maps, similar to Model maps. It will be useful for us to keep track of the dataflow between models. Is there anything we have for Anaplan? TIA
-
Displaying an Incorrect Version of Data
Hi All, I just would like to check if anyone experienced the issue wherein affected users are viewing an incorrect data (ie. Actual was selected as version on context selector however, the report in Apps shows Budget data). I tried to replicate the issue by giving the same role permission on my account as affected users…
-
How to Select the Current Fiscal Year
Hello, I have a data module that lands data in a monthly basis. I then created a module that has Q1 to Q4 line items - the intention is to get the data from Mar 23 for Q1, Jun 23 for Q2, etc. So I then created a module with the below line items and with the year as my time dimension and put a formula in each of them so the…
-
Forecast and annual plan in parallel working in a single model
My forecast periods ends 4 weeks before the annual planning number submission. I need to find a way to use the model simultaneously for forecasting and annual planning. Is it possible to achieve? The model is also interconnected with other models. Can time and or version dimension be the solution?
-
how to decide the completed years(Length of service)
hi guys~ In Sales_Rep_Details module, What we know is the sale start date, so I calculate the completed years by: Start_Date_Current_Period(2020-01-01) - Start Date then I devide it by 356 the final formula is ROUND(('SYS01 Time Settings by Month'.Start_Date_Current_Period - Start Date) / 365, 0, Up,NORMAL) by compare my…
-
vLOOK Error "'REV04 Price Growth Rates'.Unit Price % is not a recognized line item or list member"
Hello, i am getting error message "'REV04 Price Growth Rates'.Unit Price % is not a recognized line item or list member" when i am trying to apply vlook formula.
-
Select Data using a Boolean from a module with other dimensions
Hello, I have the three following modules: Pick Year: Dimensions: Product, Forecast, Time (Year) Line Item: Select (Boolean) Employee Sales: Dimensions: Employee, Market, Time (Year) Line Item: Sales (Number) - Filled with a flat Sales module (Flat Sales Module.Sales Amount[sum: Employee, sum: Market, sum: Year]…
-
Allocate a summary level data input into other
Hello, In one module, I want users to enter one growth number for a country. I then want that growth number to be applied to every single product in that country (in another module). There are thousands of products in the country, so I don't really want to have to enter the same growth number multiple times. However, I…
-
List Properties - show on UX?
Hello, I am guilty of using List Properties extensively to ease export referencing, and I am aware of the need to 1.05-03 Avoid using List Properties - however, this can be a really good tool that saves on line item space. Does anybody know if it is possible to present List Properties as part of a table in the New UX, or…
-
Writing information back to a blank module
Hello, I have an idea that I'm hoping can be done. I can't think of a way to do this now. I have a module at a Job level. I would like to write all the details of a particular job (Name, Code, location, salary) into a blank module that is not dimensioned by Job. I need this because I want to track a history of requests…
-
Sync on dashboard
Hello All, Hope everyone is doing good! I have 2 different grids on a dahsboard and both are pointing to a common dimension, however when i select a project in one grid ( top one with one of the dimension being the project ) the bottom grid is not in sync with it ( its not chaning the project ) , I noticed that the bottom…
-
How to update the Date as Blank from import Action
Hi, How can i update a Date Column which already had Valid Date with BLANK from Import Action?
-
Importing file that has one column whose first row is empty
Hello everyone, I'm struggling with the import of a file: there is one column that has the first row empty, therefore the file won't upload properly. I can't remove the column from the combination of properties because I need it to generate the unique key. The only solution I've found so far is importing the file with…
-
how can to get more command on writing formulas in line items
It will be helpful if you have provided some suggestions or resources to gain more knowledge
-
User Stories - which "tool" should I use when writing them?
Hi guys, Which tools/softwares (excel, word etc, TAW app) are you guys using when writing User Stories? Is there any nice templates out there? Regards, Stig
-
Options to improve performance when loading flat list used in reporting
Hello, I'm loading flat data between 2 Anaplan models and in the target model, I'm using the Sum function to dimensionalize the flat data into a reporting module. The reporting module needs to have 5 lists + time and also requires summary to be on so data can be reviewed at aggregate levels. As a result the import action…
-
Position of Totals
I have two nested dimensions, A & B, in rows and time and line items being in columns. I want to show time totals (All Period and Qtr) first and then the months but even if I sort, Anaplan defaults back to its general time sequence the moment I put Line Items in Columns. I don't want to manually select and then show time.…
-
Refering to data in previous item of a list
I have pulled a list in a module and this list contains data for various events. Now I want that the calculation on any event in the list to act on the data on the previous list. Example: I have 3 line items in my module, namely the principal amount, increase rate (different for different time periods and events) and a…
-
Avoid drill down to sensitive data
Hi folks, I have a challenge in a Workforce Planning model I am building. I have a organisational hierarchy going från A1→A6, where A6 being individual employees, and A4 being Cost Center. The selective access for the model is on Cost Centers (A4), which then gives access to Teams (A5) within the cost center and all…
-
Find if List member exists in List formatted Line Item
Hello, I'm struggling with this problem: I have a module named "Example" using two dimensions: "Dummy" and "Test". It contains a line item called "Item" which is formatted as "Product", Product being a list. I would like to create a subset of only the products that have been used in this module but cannot find a way to…
