Oracle Sales Cloud BI Housekeeping

When I get access to a Sales Cloud environment for the first time, I am always eager to start making all kinds of reports to add value to Sales Cloud by taking benefit of all the reporting capabilities that come with it.  But before I do that, I always clean up my BI environment first.

It is easy to do and makes it a lot easier for anyone working or making reports to navigate around in BI.

There are typically 4 tasks I carry out in order to tidy up the BI environment.

  1. Clean up the Subject Area list
  2. Set standard reports to read-only
  3. Clean up catalog folders
  4. Cleaning up how to search reports

Clean up the subject area list

Subject areas are the sets of data that you can report upon as I explain in this video.  The list of subject areas is quite long and that is actually really exciting, as it allows us to make many reports, in many different ways.  But what if you would not want to use  lead management in Sales Cloud, Households, or Asset Management?  Why would you keep the related subject areas available?  In a few clicks, these can be hidden from anyone making reports.

  1. Connect to the Oracle Sales Cloud BI
  2. Navigate to the administration sectionIf you do not have access to this section, your user does not have the appropriate privileges.  Ask an administrator to grant you the BI Administrator role.

biHousekeeing_1_admin

  1. Access user and group privileges

biHousekeeing_1_privs

  1. Remove roles. For each of the subject areas that you want to hide, click on the role names that have access to the subject area and remove the role from the subject area. Remove all roles form having access to the subject area list and it should be hidden from anyone trying to use it.

biHousekeeing_1_roles

Set out-of-the-box reports to read-only

Oracle Sales Cloud comes with a whole set of out-of-the-box reports.  I like to use them as examples, as templates.  I do not like changing them though, as changing them means that you can no longer look back at how Oracle provided them.  You can always take a copy of them and use the copy instead to make it fit your requirements.  Therefore I always make sure that I set the folder that contains the out-of-the-box subject areas to read only.

  1. Connect to the Oracle Sales Cloud BI
  2. Navigate to the BI Catalog

biHousekeeing_2_catalog

  1. Choose folder properties

biHousekeeing_2_properties

  1. Set the folder (including the content) to read only

biHousekeeing_2_readOnly

Exactly the same result can be achieved by changing the permissions as shown below, but changing the read-only property is easier and faster

Clean up catalog folders

Reports are typically made for a specific audience, whether it is by role (for salesreps or sales managers), by country or by business unit.  It is very easy to make sure that users only get to see the reports that they are supposed to be using.

Also when report creation is a distributed task and not only organized centrally, it is very easy to make sure that local report creators in a country far away cannot change reports created where you are located.

It is all about creating roles for each of the user groups in Sales Cloud and creating a folder in the BI catalog where reports for that group of users can be stored.  A last thing to do is hiding those folders that users are not supposed to see by setting the folder permissions.

  1. Connect to the Oracle Sales Cloud BI
  2. Navigate to the BI Catalog
  3. Choose folder permissions

biHousekeeing_3_permissions

  1. Change permissions per role.  These permissions can be set per folder or per individual report if you like micro management

biHousekeeing_3_roles

There are different levels of permissions to be set, here are the most useful in my opinion:

  • Full Control: users can use, create, change and delete the folder and its content
  • Delete: users can delete the folder or report
  • Traverse: users can access the folder, but not the reports in a folder.  This is a useful permission if you want to grant users access to reports in a sub-folder of this folder
  • Read: users can use access a folder or a report, but cannot make changes
  • No Access: Users are not allowed to do anything with the folder or report.  The equivalent would be simply not set permissions at all.

Cleaning up how to search reports

There is a way to control which reports a user can search for in Sales Cloud by setting reports and dashboards to hidden or not.  I describes this in the following post

Leave a Reply

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