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;

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s