-
Export View with 4 dimensions to the left side and time in the columns
Is there a way to export with 4 dimensions on the left side and time (months) in the columns? I created a saved view and used tabular multiple column export (filtering the specific months with a boolean in a separate module). However if I put the line item and time in columns it errors stating line items must be in columns.
-
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…
-
Can we stop a integration flow in Cloudworks which is running indefinitely?
A integration flow which usually runs between few seconds to 1 minute is now taking 30 mins and still running, whereas in model there is no tasks running. Can we stop/**** the integration flow without hampering the model?
-
Cloudworks succeeds but doesn't actually run
Hi all, I've noticed for a CloudWorks process I have that the actual integration says "success", but when I check the model, the last run time of the process was not updated, nor was any new data added to the model. This is an integration from BigQuery that worked previously, and is now not actually pulling new data. Has…
-
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 -…
-
Lesson 12.4.3
I've only just realised after completing lesson 12.4.3. that all of my cells are displaying zeroes. Does anyone know what I've done wrong?
-
L1 model building exam
can anyone help me with L1 exam's 7th question
-
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…
-
Enable MFA for secure login to Anaplan
Hi I would strongly like Anaplan to enable us to require MFA for login to Anaplan. Currently we have Anaplan integrated with Azure for SSO logins for internal staff but for external users it is username and password only which is a real worry. As we all know MFA is an absolute must and we would really appreciate this being…
-
SYS00 Time Settings'.Forecast Period? is not a recognized line item or list member
Hi team am receiving an error
-
Removing unnecessary Top Levels
Removing unnecessary Top Levels (or better yet, not adding them in the first place!) Author: Allison Slaught, Certified Master Anaplanner and Principle Solution Architect at Anaplan. To improve efficiency in your models, it’s important we only calculate where necessary. One way we can do that is to only use Top Levels…
-
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…
-
Reports Not Rendering Properly on Mobile App
I've noticed that reports don't show up in the same way on Mobile that they would on the web…e.g. when using KPI's w conditional formatting, on the web we get a little colorful ball on the side, which doesn't appear in the mobile app. Also, i have a grid w two fields in the rows & on the web it displays nicely w…
-
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
-
Data Write functionality giving me an unknown error
Hello all, I keep getting this error when I try to use the Data Write action in UX. It's an unknown error and I'm a system admin. What am I doing wrong? The Send to HR button is a Text write that labels the Status flag column to "HR". The Send to GM button sets a Boolean flag to TRUE.
-
Integration data between Anaplan and SFTP file
Do you know about integration data between SFTP (Filezila) to Anaplan? I want to import data from SFTP file to Anaplan.
-
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…
-
Common Department in 1 List
Hi Community, I would like to ask a question in my new setup where I can flag similar departments in a list. Using only the 3 letters of the code present on the list. In my example below there is 2 Office of the President 1 which is the child of the TMC Main parent and the other is the child of TMC SL. Requirement: I need…
-
New UX Gantt Chart: Show Dependencies with Arrows
It would be great to show the dependencies between particular tasks in Gantt charts with connecting arrows between tasks. Something like this: You would need a way to connect the particular tasks to each other - i.e. specifying the dependents or precedents of each task. At the moment dependencies are only conveyed through…
-
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…
-
Gantt Chart - Show Value on Bar and in Tooltip
From the technical documentation: "Gantt charts can also use conditional formatting instead of setting bar or milestone colors directly. Gantt charts support conditional formatting as described in Conditional Formatting, and its related procedures. This allows you to add color gradient based on values contained in your…
-
L2 Sprint 3 - 3.3.6
Can anybody please help me with why my data is showing 0 instead of 16388 in Confirmed Purchase Order Receipt (week 3) after following the instructions in the screenshot? I have applied the following formulae: PO Submitted: IF Submit Purchase Order Request? THEN 1 ELSE 0 Confirmed PO Delivery: POST(PO Submitted, Final…
-
L2-Sprint 2, DEM03 module
Hi, In L2-Sprint 2, DEM03 module we created few line items and applied some formulaes, after applying formulaes the data is populated for only FY2020 since we have only 2019 actual data we pulled the data from 2019 to 2020 by applying OFFSET function. In DEM03 module, for Baseline forecast line item we applied a formulae…
-
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.
-
PLAN Ahead [May 2023 Community Newsletter]
Greetings, Anaplan Community! 🤗 We're delighted to bring you the latest edition of our monthly newsletter, where we showcase insightful articles, engaging discussions, our exceptional spotlight user, and more. Discover practical tips and valuable insights to help enhance your Anaplan experience and continue fostering…
-
Ability to Show History in NUX While Viewing Drill Down
Currently users are able to self-service via NUX to show the history of a cell's values. This is not possible if the inputs are indirectly referenced and not available on a dashboard. Since users are allowed to show history when viewing a grid on a dashboard, the users should also be able to show history during drill down…