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 →Category Archives: SAP & Oracle
SAP, Oracle Smart View, Essbase and Oracle EPM Cloud explained without the jargon.
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 Transaction Codes Every Business User Should Know
SAP Transaction Codes Every Business User Should Know
A practical cheat sheet of SAP transaction codes for finance, purchasing, sales and reporting users — plus the navigation tricks that save time every…
Read article →Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Oracle Smart View for Beginners: Ad Hoc Analysis in Excel
Learn Oracle Smart View ad hoc analysis step by step — connect, zoom, pivot, keep only, POV and suppression options — explained for Excel…
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 →Essbase Calc Scripts: FIX…ENDFIX Explained with Examples
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 →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 →Smart View Functions: Build Cell-Based Reports with HsGetValue
Smart View Functions: Build Cell-Based Reports with HsGetValue
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 →SAP ERP Modules
SAP ERP Modules
SAP ERP Modules SAP Modules can be categorized into Functional ModulesTechnical Modules Below is a list of key SAP Modules. SAP FI Module - FI…
Read article →SAP as Business Suite
SAP as Business Suite
SAP - Business Suite SAP Business Suite is collection of fully integrated applications such as SAP customer relationship management (CRM), SAP Enterprise Resource Planning…
Read article →SAP – Systems Applications and Products
SAP – Systems Applications and Products
What is SAP ERP? SAP stands for Systems Applications and Products in Data Processing. It is ERP (Enterprise Resource Planning) software as well as the…
Read article →