Hello- It would be really great if there was an option, when formatting a line item with a List for drop down selection, if we could exclude the top level from being selected without having to make it its own level in a hierarchy. Maybe a "Don't Show Top Level" box on the formatting screen? This would prevent some situations where users cause data issues by inadvertently picking the top level of a list. Thanks, JZ
... View more
@sonpatel One solution would be to use [SELECT:TIME.'ALL PERIODS'] in your target formula, pointing to your source line item. This assumes you have total of all time periods turned on in time setting. Normally, using "Select" is not recommended, but ok if you are referring to time and you have the total of all time periods turned on in time settings. I will think through this a bit more to see if I can come up with more efficient solution.
... View more
Hi @Ameneh , I might have missed this...are Contribution Points going to be tracked in the 1.2 Contribution Management Page of the Master Anaplanner Home model for 2021? I noticed it has been offline for a few days, so was not sure if the tracking had been moved for 2021. Thanks, JZ
... View more
Hi @1636583 Neeraja Nathan's comment is correct, however, It may be helpful to note that Anaplan Pages will auto default to the Current Period (set in Time Settings) and the "Current" Version (set in Version Settings)... this assumes no specific filters have been set on time and versions. If you keep those settings up to date, at least those two dimensions will synch upon opening.
... View more
Hi All, I am having a bit of trouble sorting through all of the various ideas relating to NUX and formatting, so I have a simple request to migrate all previous formatting functionality from Classic UX to NUX. If this is the plan for the roadmap, then having an idea of timing (or even that it is on the roadmap) would be helpful to be able to communicate to clients. I am finding that I am having to use saved views in the model more often than not to populate the NUX pages due to complicated filters, etc. Then, when I need to make a change on NUX, I have to flip back to the model, rework, save and refresh vs. just being able to edit in the NUX. In addition, I like the NUX conditional formatting options better than old, but I cannot apply them to a view that I had to create in the old UX (Module Views)...unless I am missing something...which is entirely possible. Things that are notably missing right now: Filtering on Line items Setting specific column widths - NUX ability to drag column widths is great until you have nested dimensions in a view. Copy Across and Down Limiting features for each module (e.g. ability to insert, delete, open source module, etc.) Thanks, JZ
... View more
Thanks, @filip.sypniewski . I would add that it would be nice to be able to have ALL of the filtering and column width formatting that is in the old UX in the new UX. I am finding that I am having to use saved views in the model more often than not to populate the NUX pages due to complicated filters, etc. Then, when I need to make a change on NUX, I have to flip back to the model, rework, save and refresh vs. just being able to edit in the NUX. In addition, I like the NUX conditional formatting options better than old, but I cannot apply them to a view that I had to create in the old UX (Module Views). Is there a plan to migrate all the old formatting functionality to NUX? Thanks, JZ
... View more
Anaplan was not even a blip on technology’s radar when I started college, and I never could have predicted the seriousness of my ultimate relationship with the company and platform.
I started out as a nerdy auditor at one of the top accounting firms in the country. While I hate to admit my age, this was a time when a MAC Plus was considered “portable” and yellow ledger paper flourished. We dug through our client’s paper file cabinets looking for clues to help us uncover potential weaknesses in their accounting processes. A simple spreadsheet would have felt like a blessing of organized information. General Ledger systems were elementary at best and certainly did not provide any insight as to the origins of the transactions and how amounts were calculated. All information was stored in the brains of clients who squirmed at the idea of having to sit through an interview with an audit rookie.
From audit, I moved over to consulting. Two stints at “Big Six” firms (again, showing my age), and later to Akili (a.k.a. #bestplacetowork), where I joined the process-engineering revolution. My role was to help companies (typically finance and accounting departments) revolutionize their processes. General Ledger systems were starting to improve but required processes to fit around the system. These systems required a significant capital outlay from my clients, but they definitely helped them inch up the efficiency scale. Then came Online Analytical Processing (OLAP). Now, this was true magic. Companies finally had the ability to do something useful with their numbers. They could slice and dice their hearts out looking at information in multidimensional ways, and the environment was secure and auditable. The trouble was that even though these OLAP models were built with the best processes and intentions in mind, the businesses changed. My best-intentioned clients did not have the skills to update their expensive OLAP applications, and the companies had little appetite to spend more money on IT professionals and consultants to reconfigure. So, as many resourceful people will do, my clients moved to Microsoft Excel to work around their system constraints. After all, Excel is powerful, flexible, and very convenient.
Fast forward a few years and a few large companies later (now the early 2000s) my personal life and career desires landed me a job as a finance director at a large advertising firm in San Francisco. I led a team of brilliant, diverse, hard-working spreadsheet jockeys. I did my best to help them grow their skills and careers by moving away from the jockeying into the realm of analytical thinking and management. They were very capable and excited, but no matter how hard we tried, we could never fully escape the inevitable 12-hour days at the beginning of each month, trying to gain the confidence that the numbers we were sending off to the SEC were “accurate to the best of our knowledge”. That life finally killed my spirit (not to mention my marriage). I quit my job, traveled the world, volunteered, and generally enjoyed everything life had to offer outside of corporate America. I loved every minute of it — until I got bored.
Enter Akili (round 2). As I alluded to earlier, up until this time, Akili had been my absolute favorite job, and I was truly excited when they tracked me down and hired me back. Akili is a boutique consulting firm based in Dallas, Texas. Their core purpose is to improve the business performance of their clients through the application of people, process, and technology. They deliver the best combination of technology and consulting to ensure that their clients’ business objectives are met. Having been at several big consulting firms, as well as some top-notch corporations, I can honestly say that Akili is a true gem. It’s a culture that promotes excellence in delivery while having fun doing it—with outstanding, smart, and fun people. I have never felt more at home and happy with a team.
A few years after my return to Akili, we became partners with Anaplan. For those unfamiliar with Anaplan, it is essentially the solution to all of the limitations of my previous career experience. Anaplan is a cloud-based SaaS planning platform that is business-owned, flexible, and available like a spreadsheet environment, combined with the security, scalability, and auditability of a point solution. It was an instant attraction between us.
For the past five years, I have been working with clients to solve their business problems and improve the efficiency of their processes using Anaplan. One of my favorite projects was helping the FP&A team of a large media company move from herding and consolidating more than 40 multi-tabbed spreadsheets (sent by their TV stations across the country via email and all in different formats) into a consolidated P&L forecast on a monthly basis, to a standardized upload of data directly from the stations into Anaplan. As soon as the stations clicked the button to upload their data, the forecast was consolidated and ready for the corporate FP&A team to review. The process went from several weeks a month, with error-riddled data and a lot of iterations, to an almost-instantaneous result with much more accurate data. We later moved on to building models for their capital expenditure and workforce planning that fed even more accurate information directly into the FP&A P&L forecast. It was very satisfying to see such a huge reduction in time, errors, money, and frustration.
More About Anaplan:
Anaplan's UX: Changing the Way Companies Plan
New Anaplan Solution Architect Certification
Utilizing the Anaplan Academy to Support Your Journey
I have no technical programming training, but I have latched on to Anaplan model building, and now I can’t imagine my life (especially my client’s life) without it. It truly is the best of all worlds:
Cloud based SaaS—My clients do not have to invest in on-site software, data storage, and IT staff. They effectively “lease” space and a robust planning application for what they need. No long-term commitment, and limited risk.
Business-owned—If a nerdy accountant like myself can figure out how to build it, so can just about any spreadsheet-savvy millennial and beyond.
Flexible—A typical initial implementation is 8-12 weeks, and simple formula changes can be made almost instantaneously to adapt to business needs. Formulas are simple, if not more so, than Excel.
Secure and auditable—Only business owner administrators can change formulas and structures, and there is an audit trail of changes made. Users log in using single-sign-on from anywhere in the world, enter their information, and get their reports instantaneously. Heaven to my auditor mind.
It may sound odd, but I have passed up several opportunities for higher-level positions over the years because I just don’t want to break-up with Anaplan model building. Perhaps I need rehab.
Are you an Anaplan addict? Tell us why in the comments below.
Julie Ziemer, CPA & Sr. Business Planning Consultant at Akili Inc., is a Certified Master Anaplanner and Solution Architect. Julie has been working with Finance and Accounting processes and systems and management for over 20 years. Since joining Akili, Julie has worked with the Anaplan platform on a variety of engagements ranging from streamlining Financial Planning processes, Workforce Planning, Capital Expenditures, and Oil & Gas Volume planning.
... View more
As a model builder, it would be extremely helpful to have a "Used in Page" reference in the Module Settings to show where a module is used in a page, similar to the Used in Dashboard feature. This would allow for much more efficient auditing and help tremendously with model cleanup. This is especially important since we an now change or delete a module title in the page, and when you click on "Source module" in the NUX, it does not take you back to the specific module. Thank you!
... View more
Thanks @alexpavel. That is very helpful. It would be very nice to hide full pages from the App view by user role (vs. having to click into it before finding out you do not have access). Does anyone know of a way to do this? Thanks, JZ
... View more
Perhaps I am missing something basic, but I am having trouble re-organizing the initial Contents page once I get into my app. For example, I created a page that I wanted to serve as the landing page (or first item in contents). I subsequently added more pages to that category, and now my "Landing" page is at the bottom of the list. I do not see a way to move it to the top. I can change categories or move it to another App, but I cannot rearrange within a given Category. Has any one had the same issue or have a solution? Thanks, JZ
... View more