Referencing ASO Summary Data in BSO Calculations

The Short of It Using the @XREF function, we can leverage consolidated data from an Aggregate Storage database to drive Block Storage (Essbase/Planning) calculations in a fast, dynamic process. Example Your company (Pop Inc.) sells snacks and drinks from kiosks. You calculate driver-based revenue metrics for an array of FP&A exercises based on Year-Over-Year impact.…

Read More

DataSync in OAC – Automating a Job Via File Creation

The DataSync utility is the easiest way to load data from relational or a file source into the Oracle Analytics Cloud (OAC). DataSync has a scheduling capability but often you will need to trigger a load process as soon as data becomes available from another system, instead of waiting for a scheduled process time. DataSync…

Read More