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

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

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