Join Now
Making trusted decisions togetherMaking trusted decisions together
  • Solutions
    • Solutions
      • analyticsops-solution AnalyticsOps
      • technology-solution Quality Embedded Analytics
    • Industries
      • financial-solution Financial
      • government-solution Government
      • healthcare-solution Healthcare
      • insurance-solution Insurance
  • Products
    • Technologies
      • sap-bo SAP BusinessObjects
      • sap-data-services SAP Data Services
      • tableau-software Tableau
      • power-bi Power BI
    • Products
      • 360suite 360Suite
      • wiiisdom-ops Wiiisdom Ops
  • Resources
    • Blog
    • White Papers & Ebooks
    • Webinars
    • Events
    • Support
      • Helpdesk
      • Downloads
      • Documentation
      • Knowledge Base
      • Release Notes
  • About Us
    • Our Mission
    • Careers
    • News
  • Contact Us
4   
By Yasmina Couty SAP BOBJ Use Cases October 29, 2020

Lire cet article en Français france-drapeau

Flag. Backup. Archive.
The Recipe To A Perfectly Sized SAP BusinessObjects Environment

Flag-Backup-Archive-SAP-BOBJ

Do you have clothes in your wardrobe that you haven’t worn in over a year but you keep them for that “just in case moment”? You keep buying new clothes without throwing out the old ones meaning it’s a challenge to even close your wardrobe. This is probably the same case for your SAP BusinessObjects platform — you have content that hasn’t been used in a while just sitting there. The issue with this is that it’s taking up valuable space in your platform for more important content, thus causing migrations to run longer, and increasing chances of regressions and backup times. Just like doing a spring clean of your wardrobe once in a while is healthy, it’s also healthy to do the same on your SAP BusinessObjects platform. Here I’ll explain how to carry out Business Objects archiving easily with 360Suite. 

What Is Business Objects Archiving?

Archiving in SAP BusinessObjects is a very manual process, there’s no doubt about it. To choose the content that you want to archive you either ask your users to list the reports they no longer use (which 9 times out of 10 they’ll say they use all of them) or you use the audit universe in SAP BusinessObjects. However, this is very difficult to exploit because the universe structure isn’t simple and will not show unused documents, only documents with usage appear in the BOBJ Audit. This list will then need to be validated by managers. From here, you’ll need to create a BIAR file to store all the documents you want to archive. You can then either move this to an archive folder or delete them completely. As you may already know there is no way of mass deleting documents, you’ll have to manually delete each resource one by one. 

The 360Suite Way

Now with 360Suite, archiving and cleaning up your SAP BusinessObjects platform no longer has to be a tedious affair. There are four steps to the 360Suite way: flag, backup, archive, and automate. 

1. Flag 

Let’s say you want to find content that hasn’t been used in the past year. 360Eyes will gather all the content based on specific parameters. Firstly, name your flag, for example, #TOARCHIVE, then choose the time frame in months (e.g. 3, 6,13 months, etc). The type of content that can be flagged are WebI, Crystal, Deski, Explorer WorkSpace, Xcelius, QAAWS, Analysis OLAP, and Design Studio, Agnostic, Hyperlink, Lumira, and Shared Element. Once the 360Eyes job runs, it will scan all BI content and add to the description field of any content that meets the criteria in the parameter file. 

This is the result of the 360Eyes job tagging #TOARCHIVE for a document that meets the criteria specified for Archiving:

Object Description To Archive

2. Backup

Wouldn’t it be great if we could restore something that was deleted? Well, 360Plus can do just that! Once you’ve flagged the content that you want to archive, it’s important to back it up in case something gets deleted by mistake. If 6 months down the line, a user can’t find the report they need, you will be able to restore it in seconds.

3. Archive 

You’ve flagged your unused content and you’ve got a backup in place, now it’s time to auto-archive your unused content. You can achieve this in a number of ways:

With 360View, you can create an administration task that will hide the flagged objects by setting a specific SAP BusinessObjects access right. This will hide them from users. Only the Administrator is able to view, edit and manage those resources until they are unarchived. 

The advantage of this method is that the objects will still exist on the platform and can be easily unarchived and made available to users. However, they will still be taking up disk space and performance won’t change.

With 360Plus, you can create a BOBJ Promotion task that will promote the flagged objects to another folder, either on the current SAP BusinessObjects or onto another SAP BusinessObjects system. This way, if you wish, you can permanently bulk delete the objects, using the source objects removal function, but with the option of retrieving them at a later date. We like to refer to it as “pseudo-archiving”. 

The advantage of this method is that you can physically remove the content whilst still maintaining a copy that has the same CUID.

If instances are the type of objects that take up a lot of disk space, then you can use 360View to archive them. This option will export WebI document instances as files (e.g.: as .wid, PDF, XLSX files, etc) and their related folder hierarchies from the SAP BusinessObjects filestore to a given location, such as a NAS or a SAN. The method allows you to free up precious space where the filestore is installed, as scheduling-heavy companies are typically subject to a large number of generated instances.

4. Automate

What’s great about 360Suite solutions is that this process can be scheduled so you don’t have to worry about cleaning up your environment. You can set it up so that content that hasn’t been used for a given amount of time automatically gets archived.

How Are 360Suite Customers Carrying Out Business Objects Archiving?

User Feedback First, SAP BusinessObjects Archiving Second

Sometimes content cannot just be deleted without getting feedback from users, and this is exactly how one of our customers approached their SAP BusinessObjects platform clean up. They decided to carry out one archive per year with two different processes in place; one for public documents and one for personal documents. For public documents, users have to confirm deletion and for personal documents, users have to inform the administrator which unused documents they want to keep. 

This is a brief explanation of the customer’s process:

Public Documents

  1. Generate Excel documents listing all docs that haven’t been used the past year. We generate one file per project, using the reports from 360Eyes and BO Publications Excel files generated from 360Eyes are uploaded to their Google Drive and shared with project maintainers. Excel files contain OpenDoc links so that projects can link to documents quickly and check if they are needed.
  2. Project maintainers flag docs with YES if it’s ok to delete. Multiple people can work on the spreadsheet file (Google Drive handles this well).
  3. When all project maintainers have flagged their content, they produce merged csv files with CUIDs that were flagged, using reports from 360Eyes. This is the content they delete.
  4. 360Plus Backups are running daily so they have backups in place. If ever something is deleted that needs to be restored they can always get it back using 360Plus.
  5. The final stage is to bulk delete all the flagged content thanks to 360View. 

Personal Documents

  1. Generate Excel files, one for each user, with 360Eyes, and send it to users by email via BO Publication.
  2. Users are asked to open the document they need via OpenDoc Link and press the Save button once if they still need it. This updates the modified date for the document.
  3. After a certain date, they run the same report again with 360Eyes so they can see if docs have been updated since they sent the email.
  4. All content that was not updated will be deleted.

This process was critical for success to make sure their SAP BusinessObjects platform stayed in order and performance wasn’t compromised due to unused content taking up valuable space. Having user involvement also reduced the risk of content being deleted when it shouldn’t have been.  

Spring-Clean Your SAP BusinessObjects Platform With Ease 

Archiving and cleaning up your SAP BusinessObjects platform no longer has to be a task to dread. With 360Suite solutions, you can schedule your Business Objects archiving to allow you to focus on more worthwhile tasks. Cleaning up your platform will improve your performance, increase disk space, and reduce regressions during upgrades or migrations. Does it sound like something you’d want to put in place? Get in contact and we’ll get you up and running.

Related posts

360suite-updates-2021
February 24, 2021

What’s New in 360Suite in 2021

READ MORE
bec-improve-sap-businessobjects
November 30, 2020

How BEC Better Serves Its Customers with Improved SAP BusinessObjects Promotion Management

READ MORE
360suite-updates
November 17, 2020

What’s New in 360Suite in 2020

READ MORE
360View360Plus360EyesBusiness Objects MetadataBusiness Objects Bulk UpdateBusiness Objects BackupBusiness Objects Automation
Yasmina Couty / About Author
More posts by Yasmina Couty

Related Posts

Metadata and BI on BI in Business Objects
0 5
12 Feb 2018
groupe-eram-projet-consolidation-bi
QlikView to SAP BusinessObjects Migration: BI Consolidation Project for the Groupe Eram
0 0
23 Apr 2020
Business Objects regulations
Business Objects Risk Management and Regulatory Needs

When it comes to Business Objects risk management or Business Objects regulations needs it is a black box due to…

5
19 Oct 2017
bec-improve-sap-businessobjects
How BEC Better Serves Its Customers with Improved SAP BusinessObjects Promotion Management
5
30 Nov 2020
airbus-helicopters-bi-self-service
3 Steps Towards A Self-Service BI: Airbus Helicopters
0 0
28 Apr 2020
Business Objects cross-charging
Inter-company billing and cross-charging made easy with 360Eyes for SAP BusinessObjects

Keys to implement inter-company billing and cross-charging using 360Eyes Full BI-on-BI tool Without using a specialized software solution, how can…

2
01 Aug 2017
business objects migration solutions
360Suite – Your new 3 best friends for SAP BusinessObjects migration

At Xoomworks BI we view the GB&Smith 360Suite of tools as administration intelligence for SAP BusinessObjects. Planning a BI 4.1…

0 3
06 Oct 2016
intrust-migration
Business Objects Automation at INTRUST Bank
0 1
04 Dec 2018
business objects solutions
Thinking Out of the Box

If you are following GB&SMITH you may have read my previous post a ‘decade of success’, then, you already know…

4
06 Sep 2017
Documenting SAP BODS Metadata
Documenting SAP BODS Metadata With 360Suite
4
18 Sep 2020
360bind automated regression testing
Discover A Solution That Automates Your SAP BusinessObjects Regression Testing In Just A Few Clicks
0 0
09 Jul 2020
business-objects-recycle-bin
360Plus Backup vs Business Objects Recycle Bin
0 1
20 Aug 2018
dcp-use-case
How A Fortune 500 Company Prepared for a Business Objects Upgrade
0 1
22 Jan 2019
harley-davidson-trophy-roi
Harley-Davidson Saved More Than $1 Million with 360Suite
0 6
20 Feb 2018
lockheed-martin-use-case
SAP HANA 1.0 to 2.0 Upgrade: How Lockheed Martin Aeronautics Piloted Their SAP BusinessObjects Data Source Change
0 0
03 Aug 2020

Information

  • Careers
  • Partner Program
  • Press
  • Terms & Privacy Policy
  • Legal
  • Support

Latest news SAP BusinessObjects

  • Overcoming SAP BusinessObjects Challenges In A Federal Organization
    February 2, 2022
  • 3 Steps For A Successful SAP BusinessObjects Private Cloud Edition Migration
    August 17, 2021

Latest news Tableau

  • Tableau Testing: Selenium vs. Wiiisdom Ops
    February 7, 2022
  • Integrating Tableau Automated Testing To Ensure Trusted Dashboards At Red Hat, Inc.
    January 31, 2022

Connect With Us

  • Making trusted decisions together
  • Français
2022 © Copyrights Wiiisdom.
All Rights Reserved.

Request your trial for Wiiisdom Ops

Wiiisdom Ops supports Tableau Server and Tableau Online (now Tableau Cloud).
For custom installations, 3rd party authentication and single sign on, an initial setup may be required.
Please refer to our documentation and do not hesitate contacting us at: contact@wiiisdom.com.