Excel, SAP, Oracle & automation tips — plus wacky facts
SAP, Oracle Smart View, Essbase, EPM Cloud, TallyPrime and Busy explained without the jargon.
SAP, Oracle Smart View, Essbase, EPM Cloud, TallyPrime and Busy explained without the jargon.
📄 52 articles⬇️ 39 with practice files🕒 Updated 12 Nov 2026
🎓 Start here: Smart View Course → 🎓 Start here: Tally & Busy Course → 🎓 Start here: SAP Basics Course →📥 Practical Working File:Download this complete, formula-ready spreadsheet template to practice directly in Excel.Download TDS FY 2026-27 Calculation Workbook (.xlsx) Automating TDS Deductions in…
Read article →In SAP ERP (ECC 6.0 and S/4HANA), SAP FICO (Financial Accounting & Management Controlling) forms the transactional backbone of corpora
Read article →SAP Logon SAP Logon is used initiate a user session in a desired SAP Server. The same SAP Logon pad can be used to…
Read article →Stop SAP reports timing out: run them in the background with a variant, schedule them daily or monthly, check status and spool output in…
Read article →Source system, locations, import formats, mappings and data rules: a plain-English walk through Oracle EPM Cloud data integration and where loads usually go wrong.
Read article →Connect Smart View to Essbase or EPM Cloud with a private or shared connection, open an ad hoc grid, refresh, and set the most…
Read article →Learn Oracle Smart View ad hoc analysis step by step — connect, zoom, pivot, keep only, POV and suppression options — explained for Excel…
Read article →Why finance teams use multidimensional cubes like Essbase alongside relational SQL databases: pre-aggregation, hierarchies, sparse/dense data and the questions each answers best.
Read article →Build free-form reports with Smart View functions: HsGetValue syntax, referencing cells for members, the Function Builder, refreshing functions, and when to use functions vs…
Read article →Use Oracle's EPM Automate command-line tool to log in, upload files, run data rules and business rules, refresh the cube and export data —…
Read article →Combine everything into a monthly report: parameter cells for period and entity, ad hoc or function grids, preserved formatting, multiple sheets refresh, and VBA…
Read article →Use Oracle Smart View functions such as HsGetValue to pull single numbers from Essbase or EPM into any Excel layout — syntax, POV defaults,…
Read article →
