Recent Posts

How to Refresh SAP Analysis for Office Queries & Data Sources with a Macro

Depending on the report, having a way to automate your data source refreshes may save you a ton of time. Contents: 1. How to Create a...

SQL CASE Statement - The IIF Alternative for SAP Business One/HANA Databases

If you're working on an older or alternate SQL server, the IIF function may not be supported, instead you'll want to use a CASE...