Managing BSO Database Properties in Oracle Planning and Budgeting Cloud

Managing BSO Database Properties in Oracle Planning and Budgeting Cloud


Welcome to this step-by-step tutorial on how to manage BSO Database Properties in Oracle Planning and Budgeting Cloud. You view and edit database properties in Calculation Manager. In Enterprise View, choose a BSO database to see its properties. The Enterprise View pane displays your Planning application and its associated databases. Properties are displayed in the content area. On the General tab, you can view database information, manage calculation settings, and review buffer and storage information. On the Dimension tab, you can view the number of dimensions and a tabular display of each dimension’s name, type, and members. To optimize performance of the BSO database, you can set dimensions as sparse or dense and set their order of precedence. This task is performed outside of Calculation Manager on the Performance Settings tab. I’ll return to Calculation Manager. On the Statistics tab, you can track the database start time, the elapsed time, the number of connections, statistics about the data blocks, and run-time statistics. You can view transaction commit options on the Transactions tab and recent changes on the Modifications tab. The shortcut menu enables you to perform tasks that vary depending on the selected object. At the application level, you can refresh the application list after changes are made, and start and stop applications to load or unload applications and their associated databases from memory. You must stop and restart applications when you make changes to database properties. You also can choose to stop and start only the databases in the application. Let’s take a look at sessions. The Sessions list displays active user sessions and requests. This is an active request for a business rule I have running in the background. In the Options section, the Kill action is selected by default. You can end the selected request, all requests from all users, or all requests from a specific user. If you selected All Requests or All Requests from User you can choose to end requests on the selected server, application, or database. I’ll end only this active request. The request has been terminated. Let’s return to Database Properties. Now, let’s take a look at the plan type shortcut menu options. You can unlock database objects and start and stop the plan type’s database. Restructuring databases may take a while. Perform this task as one option to defragment application data. In a BSO application, you can clear all data values, upper-level data blocks, non-input data blocks, dynamic data blocks, or empty data blocks. You can view your application’s location aliases Location aliases map an alias name to the physical location of its database. Finally, you can manage Drill-Through Definitions for Planning plan types. In this tutorial, you saw how to manage BSO database properties. To learn more, visit cloud.oracle.com.

Danny Hutson

Leave a Reply

Your email address will not be published. Required fields are marked *