About nicole.johnson

nicole.johnson · ‎04-19-2022

我想知道如果佤邦s any resolution for this. I have a request from an end user that would like to have an easy way to see if they change Input X on a dashboard, what measures does it impact downstream? I'm newer to the model and there's a lot of manual tracing needed to identify the answer. For example, 1 input cell has 14 line items that reference it.

nicole.johnson · ‎06-25-2021

@arperlad Until the change is deployed, I identified a fun workaround using the new CloudWorks functionality! You can set up a weekly schedule to run a process that has the Order List action in it. That way, the Order List action runs weekly and you don't have to think about it.

nicole.johnson · ‎05-25-2021

In a New UX page, I have a field card with 2 drop-downs. BEFORE If I re-select the same value from a drop-down, then the value no longer displays. For example, if I go to the Forecast 2 drop-down and choose "UAT Forecast" from the selector again, then the field displays nothing per screenshot below. All the data on the page that's filtered based on the Forecast 2 drop-down still behaves as if "UAT Forecast" is selected. After If I refresh the page (Alt+R), nothing happens. If I refresh the webpage (F5), then the value chosen for Forecast 2 ("UAT Forecast") reappears. Now, I know it could seem strange to want to re-select the same value from a drop-down, but sometimes you go to select a value and realize you still want the same value you previously selected. You can avoid this issue by pressing 'Esc' instead of re-selecting the same value. However, I'm bringing this up as a functionality issue because it's confusing for end users. I'm wondering if there is something I've done incorrectly in the build of the New UX page, or if is this a bug.

nicole.johnson · ‎01-13-2021

Thank you, @anirudh ! This is exactly what I was looking for. I'm able to replicate the issue per your instructions and now have a great new tip for end users!

nicole.johnson · ‎01-13-2021

Thank you for the tips, @ChrisAHeathcote . I agree with the merits of hygienic UX design! I should have noted in my original post that the issue is occurring in a worksheet, rather than a board. @anirudh 's example is a good representation of the issue I was having.

nicole.johnson · ‎12-18-2020

When scrolling left to right in a New UX worksheet page, sometimes the scroll bar gets locked to my mouse movement as if the mouse is still clicked down on the scroll bar, even when it isn't. So, when I'm done scrolling and release the mouse button and move the mouse around, the table still scrolls left and right in relation to the direction that I move the mouse. The way I'm able to get it to stop the undesired scroll behavior is by clicking on the scroll bar again. Some notes: This isn't easy to describe. Please don't hesitate to ask for clarification. I've tried to identify steps to recreate the issue, but am unable to (I know, I know, it's a troubleshooting dream). End users have pointed out the issue to me: they have experienced it and I have as well. We're using Google Chrome on Windows machines. For me, it has occurred with both a bluetooth mouse and the touchpad built into my laptop. I'm wondering if this is some sort of 'feature' that we're inadvertently turning on, or if it is a bug. I'm curious if anyone else has experienced a similar issue.

nicole.johnson · ‎12-18-2020

This is now a feature in the New UX.

nicole.johnson · ‎10-10-2020

@JaredDolich I doubt you recall this exact exchange, but I had said that I would be starting up a Best Practice article in the next 2 weeks, but there's been some exciting career changes in the air for me that have been consuming a lot of my time as of late. I have to put drafting a Best Practice on the back burner for a short while, and didn't like that I posted a commitment to writing it in this forum and then did not follow through. We'll see if it hasn't been covered yet when I get back at it.

nicole.johnson · ‎10-10-2020

I'm interested in attending a virtual event in early December and am open to the event type.

nicole.johnson · ‎09-30-2020

@Tiffany.Rice That's great to hear! When I first learned about the profile function, fixed asset depreciation was the first thing that came to mind (I was formerly an Accountant that developed a fixed assets database in MS Access for a nonprofit). This use of profile for fixed assets is a perfect use case! I can see how you'd have a different profile for each depreciation type, and then each asset or asset type is assigned a depreciation profile. Then, incorporating David Smith's example, you'd have all of the depreciation calculating really efficiently.

nicole.johnson · ‎09-29-2020

@JaredDolich Thank you so much for sharing the additional information! Getting set up to write it will be even easier thanks to the information you provided. Once you suggested it I immediately added it to my list of goals for the next 2 weeks. I appreciate the encouragement. It is too good of an opportunity to pass up!

nicole.johnson · ‎09-29-2020

What a great idea @JaredDolich I felt really lucky when I found the answer. It makes a lot of sense that other modelers might be looking for it, too.

nicole.johnson · ‎09-29-2020

My Anaplan team currently sits in Data Operations (within Revenue Operations). This gives me exposure to changing data structures and data availability. I'm an Anaplan team of 1, but ramping is in progress with another team member in Finance who can assist with building models. Company size is 400-500 employees.

nicole.johnson · ‎09-29-2020

我知道了,Anaplan团队可以坐在a variety of departments: some sit on Technology or Operations teams, some sit in Finance. There's a variety of roles that are filled by a small number of people wearing many hats, or sometimes a large number of people wearing fewer hats. I enjoy learning about the different team structures, as it is fodder for creating more deliberately planned responsibilities within the Anaplan team. So, where does YOUR Anaplan team sit? What are the roles in your Anaplan team? What's the size of your organization? Looking forward to reading replies!

nicole.johnson · ‎09-29-2020

Thanks! I will!

nicole.johnson · ‎09-29-2020

The transition to ASC 606 has been an incredible use case thus far! We previously implemented a 606 revenue projection tool which made ample use of the profile function. This solution was invaluable to me: We have multiple profiles for revenue recognition based on the type of future product sold. The linked solution allowed me to assign profiles to product types and then lookup the profile instead of using a potentially very long and unmanageable if statement. It is one of the more abstract maneuvers I've made in Anaplan, and I really enjoyed implementing it.

nicole.johnson · ‎09-28-2020

Hi everyone! I've included my introduction below: How did you find the Anaplan Community? I revisited the Software & Technology group forum after listening to an interview in which Sarah Roberts briefly mentioned the group “Higher Education & Public Sector”. There’s a good amount of engagement in that group, and I’d enjoy the benefits of that in this group! What specifically are you working on at the moment and how can this group assist you? Right now, I’m working on a tool that helps reconcile budgeted revenue to actual revenue. While there isn’t anything I specifically need help with, it is interesting to learn about how others in the industry have approached reconciling budget vs actual ASC 606 revenue. What goals do you have for your participation in this group? Things that would be nice to see in this group: - Learning about projects that others are working on - Learning if anyone has tapped into the engineering resources at their companies to see how The Anaplan Way correlates with software development. - Learning where your Anaplan team sits: what part of the organization? What's the size of your organization vs the size of your Anaplan team? - What type of models do you currently have and what future models are in your roadmap/honeycomb? I imagine a lot of us have similar challenges and solutions in common and some online or virtual chats could benefit all of us!

nicole.johnson · ‎09-13-2020

"The goal is not to simply recreate complex Excel spreadsheets within a shiny new web interface. The aim is to truly transform and showcase the new ways companies can now plan." ^ Those 2 sentences caught me--that's exactly what I like about Anaplan: its potential to transform the planning experience. I can't help but to think how fun it would be to see examples of such transformations in "before & after" format, much like we see in popular home makeover shows.

nicole.johnson · ‎08-31-2020

That's helpful to know, and it makes sense why Platform Updates can sometimes break the scripts. Since the testing I'm interested in has more to do with ongoing data validation, I think there are simple yet effective measures I can employ to speed up the testing process without going the Selenium route yet. As I learn more I can automate more, but the important part is that I've become more aware of the value of testing downstream data as changes are made to a model. If I weren't on a Mac, I think the Excel add-in would have a lot to offer in terms of time-to-value for spinning up semi-automated data validation (but once the Google Sheet Add-In becomes available, I can explore that as an option). However, I think the API will help me achieve a similar goal (with more leg work).

nicole.johnson · ‎08-30-2020

自写你最初的帖子,你采纳a new best practice for testing? I was recently introduced to the idea of Test Driven Development (TDD) while learning Python. I really enjoyed the concept of TDD and wondered how I could leverage the benefits of TDD with Anaplan model development. UAT and checking against existing external Excel models have served me well for initial model buildout. However, I've found the most trouble when small tweaks are needed in a rush: you make the "small" change and it works the way you think it should (it passes a 'unit test'), but there's no regression testing performed on all the other individual units which would ensure you haven't unintentionally distorted downstream outputs. I spend a lot of time comparing data to make sure things are still behaving, but having tests that I can run instead would save a lot of time. Anytime I start doing something really repetitive and tedious, I quickly get the suspicion that someone out there has an idea of how to do it more efficiently. I have some vague ideas of how I might implement some testing modules, but my first step was to come to the Anaplan community to see if someone else had already invented the 'TDD with Anaplan' wheel.

nicole.johnson · ‎08-24-2020

I'm so appreciative of the quality of these user groups, thank you so much for organizing this and for opening this group up to the Pac NW. The presentations inspired new best practices and also helped me understand that some of the challenges I experience are a part of business that others experience as well. It was equal parts reassuring and invigorating!

nicole.johnson · ‎03-20-2020

Thank you for this, @Matthew_Kuo ! I really enjoyed the presentation on the 19th and am looking forward to incorporating some of these practices! Thank you so much for sharing what you've learned along the way. It is very appreciated.

nicole.johnson · ‎03-20-2020

OH my gosh yes this is like when I would accidentally launch iTunes on a really old laptop. Except this issue happens very often and I get so bummed when I accidentally click on the map when I'm trying to demo something for a new model builder.

nicole.johnson · ‎03-17-2020

I know you wrote this solution over 2 years ago, but it is really going to come in handy for me in my latest project. Thank you!!

nicole.johnson · ‎02-26-2020

The new link is working, thank you!

nicole.johnson · ‎02-26-2020

Hi @MagaliP , when I click the link I get a "Message Not Found" screen.

nicole.johnson · ‎02-18-2020

Hi! Thanks for making this thread. Is there an estimated date for GA of the Google Sheets add-on? We are on mac os, which means we haven't had an opportunity to explore the Excel and PowerPoint add-ins, so it makes us all the more excited about the Google Sheet add-in!

nicole.johnson · ‎01-27-2020

A possible workaround is to employ a different symbol as a delimiter for each segment. Something like " 123_Q-SW^Q1". Then the formula doesn't require as much fiddling.

nicole.johnson · ‎01-24-2020

For SYS08 I decided to just change the name of the line item "Distribution Center" to "Supplied By". However, for DAT01 I do not believe we were ever instructed to created a line item named "Produces SKU". For Sprint 3 specifically I've also come across some line items in SYS01 that I did not have in the module: 'First Day of Period'; 'Last day of Period'; 'Weeks Only?'. I'm going back and reviewing to see where I may have gone off course but think we weren't explicitly instructed to create those line items. Perhaps instead they were necessary formulas for other line items to reference and maybe I accomplished it without needing those line items. Curious if anyone else had this issue.

nicole.johnson · ‎01-15-2020

Any opinions on best practices when the source system is an Anaplan spoke, rather than an external system? For example, the annual budget is developed in Anaplan using a Budget spoke. While there are transaction modules in the Budget spoke for user data entry, there are multiple calculations performed on that data to arrive at the final budget (ex: headcount based expenses). The end result of the Budget spoke is a dimensionalized module, not a transactional module. There are other reporting spokes that need summarized, dimensionalized budget data (ex: for variance analysis). Since the data in the Budget spoke is already dimensionalized, it doesn't make sense to go to great lengths to flatten it to get it into the HUB, only to need it dimensionalized in other reporting spokes. Is this an example in which it makes sense to have a module with more than just the time dimension in the Hub? Or maybe I'm missing something big here. I'm not looking for a perfect answer, just more of a general guidance around when a spoke serves as a data source. Perhaps it doesn't flow through the hub at all?