Allocations & Cost Management is a really unusual area of a business. All other reporting needs focus on taking lots of transaction or balance level detail, tweaking & adjusting it and then aggregating it together for reporting. Allocations is the inverse of this – which presents a unique set of challenges. (more…)
Matt Yorke
Hitting the Apex
I was in a conference yesterday and there was some lively debate about the pros and cons of APEX vs Oracle Analytics Cloud, OBIEE & BICS. I thought I’d drill in to this a little further and explore what role does Oracle Application Express plays in a Business Analytics environment and should (or could) Application Express be used instead of Oracle Analytics Cloud?
Getting Started with the Oracle Analytics Cloud Rest API
This is a brief introduction into the Oracle Analytics Cloud Rest API; there isn’t any documentation on it yet – so this should get you started. (more…)
Do I have SSH (command line) access to my Oracle Analytics Cloud server?
Rules files on Oracle Analytics Cloud
I’ve been asked a number of times whether we can run existing “on premises” rules files in OAC, and also run in OAC using a SQL data source.
We’ve tested out both of these features and both work well:
- Use Essbase 11.1.2.4 SQL based rules files
- Developing them off-line on an on-premises install in EAS
- Setting the SQL connection string to be a substitution variable
- Deploy them to OAC
- Update the substitution variable to point to the cloud RDBMS
alter application 'TBC' set variable 'OCIString' 'QUBIXDB:1521/pdb1.a28217.oraclecloud.internal'; import database 'TBC'.'TBC' data connect as 'admin' identified by 'password' using server rules_file 'data' on error write to 'c:\eastemp\data.err'; execute aggregate process on database 'TBC'.'TBC' stopping when total_size exceeds 10;
How To – Goal Seeking
Essbase has some great machine learning functions (e.g. @TREND), but these functions usually need tuning. This is a simple goal seeking function to help optimise a linear expression
Oracle Analytics Cloud Introductory Videos
Getting started with Oracle Analytics Cloud.
Triple Exponential Smoothing – Holts Winters
One of our customers required a 3rd Normal Formal Holts Winters Multiplicative predictive model, running on planning. The predictive planning add-in doesn’t support this method – but it’s actually one of the most interesting predictive algorithms since it supports seasonality – a must have for retailers.
ORA-00257: Archiver error
If you’re new to Oracle Analytics Cloud and haven’t got an Oracle DBA helping you out – you’ll definitely come across this one pretty quickly.
(more…)