Skip to main content

Video Archives

 Please find some of the old videos that I home-made while I was a consultant at QBIXAnalytics.com. You can also find the videos and articles on their "Adaptive Corner". 

- How to write easy to read formulas by adding comments, indentation, spacing...

- How to build a prepaids model, step by step guide

- Create visually appealing models by using emojis and Unicode characters (for 🦄 lovers)

- What is the difference between dimensions and attributes?

- You locked a version and your numbers have changed in it: why? solution?  And no it's not your eyes!

- Tired of clicking and navigating through the Hamburger menu? Create bookmarks in your browser to key Adaptive pages, that will always work (eg. book mark your Modeling Management page, Integration Design, Income Statement, Dimensions, etc.) --> for Finance Geek Peeps

- 2 simple and useful keyboard shortcuts (that will make you like an expert)


The art of formula writing: easy to read and efficient formulas




Build a Prepaids model: step by step guide



Create visually appearing models using unicode characters / emojis



What is the difference between a dimension and an attribute in Adaptive?




You locked a version, but numbers have changed! What?!?! Why?! How to fix it?




Create bookmarks to key Adaptive's pages that will always work

Unleash the geek in you... you will code a little here! (ok... mostly copy and paste it)


2 simple shortcuts in Adaptive





 

Labels:

Comments

Post a Comment

Popular posts from this blog

Adaptive's API

To integrate data in Workday Adaptive Planning, customers typically use the integration module to connect with ERPs, SFTPs, AWS S3, Snowflake, SalesForce, Excel, and Google Sheets, etc.  You can also use third party platforms such as Tray.ai , Boomi , Matilion etc. which leverage Adaptive's APIs in a user friendly setup.  And lastly, you can write your very own scripts (C#, Python, Powershell...) to make these API calls.  Most  common Adaptive's API use cases Import Data from ERPs Actual summaries and transaction details (by supplier, employee...) Assets, amortization, depreciation Payroll details and taxes Import Sales data from CRMs or datalakes Pipeline, churn, opportunities and customers  Billings, bookings, revenue, ARR Import Headcount data from an HRIS Current headcount and terminations Hired, not started Wages and compensation plans Benefits and other demographics Import Other data: Exchange Rates Weather Meta data: currencies, attributes, dimensions suc...
Read more

One (perfect) Headcount Planning Process in Workday Adaptive for FP&A

FP&A: The Perfect Headcount Planning Process in Workday Adaptive for non Platform customers: Streamlining integration, reconciliation and budgeting This article is for companies that are not on the Workday Platform  (HCM, FINS, Adaptive) and are missing out on the integrated cycle of hiring, planning, reconciliation, and system-wide alignment that Workday offers. I sometimes hear complaints (luckily not too much) about Workday HCM, Adaptive or FINS... but the truth is, no other tool on the market currently offers a complete solution that spans the entire hiring process—from budgeting and requesting to hiring, reconciling, and publishing plans across systems. Workday is the only one with this capability right now!  I’m not paid by Workday to write this… But after working with several HRIS, ATS, and ERP systems, I can confidently say that Workday stands out for its customizable workflows, overall ease of use, and seamless communication across all three systems -- assuming yo...
Read more

Adaptive REST API Calls for Platform Customers with User Sync Enabled

How to Make Adaptive REST API Calls for Platform Customers with User Sync Enabled If you’re a platform customer (HCM + FINS + Adaptive) or using Workday HCM or Financials alongside Adaptive and want to create custom scripts leveraging Adaptive’s REST API (XML), you’ve likely encountered a key requirement: providing Adaptive user credentials (username and password). For standalone customers or those not using user sync, this typically involves creating an integration user in Adaptive. Easy peasy.  But what if you’re using user sync? How do you supply credentials for API calls in the XML input? In this article, I’ll guide you through the steps to generate the necessary credentials when user sync is enabled. I’ll also share helpful links to official documentation to ensure a smooth integration process. 1. Overview The process allows Workday-synchronized users to make API calls to Adaptive Planning using Workday credentials . The key steps involve: Generating an OAuth token using Work...
Read more