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…)
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?
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…)
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 220.127.116.11 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;
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
Getting started with Oracle Analytics Cloud.
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.
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.