Over time, SAP BusinessObjects deployments have a tendency to grow in size, especially environments that are heavy on ad hoc reporting. It is difficult to get information on how your environment is growing and ensure the platform growth doesn’t get out of control. Unused content increases the size of your platform, causes migrations to run longer and increases the time and space needed for backups. The larger the environment, the more critical this becomes.
GB&Smith’s 360Suite of tools have a solution to this problem. 360Eyes and 360Plus provide an auto cleaning process that will allow you to control your platform growth over time. This feature is what enticed the 2 largest SAP BusinessObjects clients to invest in the 360Suite.
360Eyes is a tool that provides metadata about your BI environment. The tool is used for Impact Analysis, identifying unused reports and objects, finding differences across environments and much more. 360Plus is a tool used for backups and promotions.
The auto cleaning process will allow you to do the following with your unused Webi, Crystal and Deski Reports:
- Flag (360Eyes)
- Backup (360Plus)
- Archive (360Plus)
Flag Unused Documents
360Eyes contains a program that will flag all unused reports in your environment. The description field in each unused Webi, Deski or Crystal Report is updated with #TOARCHIVE. You can specify whether you want to flag reports that haven’t been run in 6 months, 1 year, any time frame… it is up to you. This program can be scheduled to run on a monthly basis (or other frequency) so that you are flagging content to be archived at scheduled intervals.
Backup Unused Documents
You want to ensure that you have a backup of the documents prior to archiving and/or deleting them. 360Plus gives you the ability to schedule a full backup of all the content in your environment or select specific content to backup, such as individual Universes, folders, reports etc. This can be scheduled at any frequency you select, i.e. daily. The tool enables you to restore/rollback any content that has been deleted.
Archive Unused Documents
Once the unused reports are flagged with 360Eyes, you can run a Promotion job using 360Plus. Using the “Migrate with Flag” option, you can move all the unused reports to an Archive folder within the environment or copy the unused reports to an Archive folder in another environment. This job can be scheduled to run on a monthly basis after the unused documents are flagged with the schedule job in 360Eyes.
Delete Unused Documents
After a period of time, perhaps 6 months, you will want to delete those unused documents from the Archive folder. You will have a backup, so in the event you need to restore any report that has been deleted, that can be done with 360Plus.
Using the tools in the 360Suite, the auto clean process involves the following steps to empower you to keep your platform growth from getting out of control:
- Flag – 360Eyes flags unused reports.
- Backup – 360Plus backups BOBJ reports.
- Archive – 360Plus will move or copy the unused reports to an archive location.
- Repeat – Each of the steps in this process can be scheduled, allowing this to be an automated process.
The tools in the 360Suite give you the ability to manage your SAP BusinessObjects environments to make administering SAP Business Objects easier, quicker and much more pleasant! Saving you time and money on managing the environment so you have more time to spend on more important, value-added tasks.