Tips and Tricks

Best practices and performance tuning for using Hybrid BSO in EPBCS

by

I recently presented at ODTUG KSCOPE19 in Seattle. Thanks a ton to ODTUG content selection team for giving me this opportunity to present at such a great conference! I presented along with David DeLozier on Best Practices and Performance Tuning for using Hybrid BSO in EPBCS. I had a great audience with lots of questions being asked. Sincere thanks to Oracle’s Mark Rinaldi for attending this session and contributing to answer questions asked by the … Read More

Quick Tip – Login format for Financial Reporting Studio on Oracle PBCS

by

The login format for Financial Reporting Studio on Oracle PBCS is slightly different compared to the on-premise one. Here is the format: User Name is in identitydomain.userid format. For example, if the identity domain is usxyzcorp and user id is admin@xyzcorp.com then the user id should be entered as usxyzcorp.admin@xyzcorp.com If the service instance URL is https://usxyzcorp.pbcs.us1.oraclecloud.com/workspace, you should use the following server URL format: https://usxyzcorp.pbcs.us2.oraclecloud.com in FR Studio.

Essbase Substitution Variables in Essbase SQL Load Rules

by

Do you know that you can use Essbase Substitution Variables in Essbase SQL Load rules? For example, you can use the substitution variables in the where clause of a SQL query to fetch only a specific year or month corresponding to the value of the variables. This is a very good feature if you want your SQL data loads to be controlled using the Essbase Substitution variables. Read further to see how this can be … Read More