Essbase Calc Scripts: FIX…ENDFIX Explained with Examples
Learn how FIX…ENDFIX focuses an Essbase calculation on a slice of the cube, with examples for aggregation, allocation, clearing data and copying scenarios —…
Read article →ERP
SAP, Oracle Smart View, Essbase, EPM Cloud, TallyPrime and Busy explained without the jargon.
Refresh Oracle Smart View Sheets Automatically with VBA
Refresh Oracle Smart View Sheets Automatically with VBA
Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →Oracle EPM Cloud Explained: Planning, FCCS, Narrative Reporting and More
Oracle EPM Cloud Explained: Planning, FCCS, Narrative Reporting and More
A plain-English map of Oracle EPM Cloud: what Planning, Financial Consolidation and Close, Account Reconciliation, Narrative Reporting and EDM each do — and how…
Read article →MaxL Basics: Automate Essbase Data Loads and Calculations
MaxL Basics: Automate Essbase Data Loads and Calculations
Use MaxL scripts to automate Essbase: log in, clear and load data with a rules file, run a calculation and log errors — with…
Read article →Smart View Lesson 1: What Essbase and Smart View Are
Smart View Lesson 1: What Essbase and Smart View Are
Understand Essbase cubes, dimensions, members and hierarchies, how Smart View connects Excel to them, and where it fits with Planning and EPM Cloud.
Read article →Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
Essbase Explained: Cubes, Dimensions and Why Finance Teams Love It
What Oracle Essbase is, how cubes, dimensions and members work, the difference between BSO and ASO, and a first look at calc scripts —…
Read article →SAP Posting Periods: Why You Can’t Post in a Closed Month
SAP Posting Periods: Why You Can’t Post in a Closed Month
The "posting period not open" error explained: what posting period variants are, how finance opens and closes months (OB52), separate material periods (MMPV), and…
Read article →SAP Basics Lesson 6: FI Overview for Finance Users
SAP Basics Lesson 6: FI Overview for Finance Users
SAP Financial Accounting explained for users: G/L, AP and AR, documents and posting keys, line item reports, open item clearing, period closing and the…
Read article →SAP SE16N and SQVI: Pull Table Data Without ABAP
SAP SE16N and SQVI: Pull Table Data Without ABAP
Use SE16N to browse SAP tables and SQVI QuickViews to join them into your own reports — with the most useful table names for…
Read article →SAP Basics Lesson 2: Transaction Codes You Will Use
SAP Basics Lesson 2: Transaction Codes You Will Use
The T-code system explained: /n and /o, display vs change vs create codes (03/02/01), finding a T-code, common codes for finance, purchasing and sales…
Read article →SAP Fiori Launchpad for Business Users: Spaces, Tiles and Search
SAP Fiori Launchpad for Business Users: Spaces, Tiles and Search
Find your way around the SAP Fiori launchpad: spaces and pages, tiles and KPIs, enterprise search, personalising your home page and when to fall…
Read article →SAP FICO for Finance Users: GL, AP, AR, Cost Centres and the Reports You Will Use
SAP FICO for Finance Users: GL, AP, AR, Cost Centres and the Reports You Will Use
A plain-English tour of SAP FI and CO for accountants: company codes, GL accounts, document types, vendor and customer processes, cost centres and profit…
Read article →