Join Now
Wiiisdom | Analytics Governance SolutionsWiiisdom | Analytics Governance Solutions
  • Solutions
    • By Initiatives
      • analyticsops-solution AnalyticsOps
      • technology-solution Embedded Analytics
      • icon-scale-analytics Scale Analytics
      • icon-regulatory-compliance Regulatory Compliance
      • icon-enable-rpa Enable RPA
      • icon-cloud-analytics Move to the Cloud
    • By Industries
      • financial-solution Financial
      • government-solution Government
      • healthcare-solution Healthcare
      • insurance-solution Insurance
    • By Technologies
      • sap-bo SAP BusinessObjects
      • sap-data-services SAP Data Services
      • tableau-software Tableau
      • power-bi Power BI
  • Products
    • wiiisdom-ops Wiiisdom Ops
      • tableau-software Wiiisdom Ops for Tableau
      • sap-bo Wiiisdom Ops for SAP BusinessObjects
      • power-bi Wiiisdom Ops for Power BI
    • 360suite 360Suite for SAP BusinessObjects
      • favicon-eyes 360Eyes
        Metadata & Impact Analysis
      • favicon-live 360Live
        Live Monitoring
      • favicon-bind 360Bind
        Automated Regression Testing
      • favicon-univ 360Univ
        Universe Management Tool
      • favicon-cast 360Cast
        Report Bursting & Scheduling
    • 360suite 360Suite
      • favicon-view 360View
        Administration & Maintenance
      • favicon-plus 360Plus
        Disaster Recovery, Backup & Promotion
      • favicon-vers 360Vers
        Versioning & Lifecycle Management
      • favicon-safe 360Safe
        License Compliance
      • favicon-init 360Init
        Project Creation
  • Resources
    • Resource Center
    • Webinars
    • Events
  • About Us
    • Our Mission
    • Careers
    • Partner Program
    • News
  • Contact Us
0 0   
By Pauline Lancaster SAP BusinessObjects 360Suite BI Administration December 23, 2019

Lire cet article en Français france-drapeau

How To Implement and Use Tags in Business Objects

business-objects-tags

Let’s Take A Step Back

Imagine this scenario: You have thousands of SAP BusinessObjects documents and Universe objects. You do not know where sensitive data exists or which documents are not being used. There are probably a number of Regulatory and Security Compliance questions you need answers for as well. So, how can you answer these questions without spending endless hours looking through all your documents?

The best way to accomplish this is to label SAP BusinessObjects content: flag SAP BusinessObjects documents or tag Universe objects so that you can find your answers easily. 

Defining Flags and Tags

Flags are specific text in the description fields of documents (Webi and Crystal Reports) that are inserted to allow content to be moved. Rather than spending time adding these flags individually, 360Suite can help you add these flags in bulk. Once these flags are added, you can automate moving the flagged content via a promotion job. After the content has been moved, the flag is automatically removed.

On the other hand, tags in Universe objects provide a way to categorize objects in order to search for and find them for regulatory compliance and data cataloging. Back in September 2019, Gartner published an article stating that “Data Catalogs are the new black in Data Management and Analytics”. According to Gartner, “demand for data catalogs is soaring as organizations continue to struggle with finding, inventorying and analyzing vastly distributed and diverse data assets”. 

For more information on data catalogs in SAP BusinessObjects, you can have a look at our article.

How to tag universe objects

We provide a solution called 360Univ that allows you to bulk update Universe objects. A Universe (UNX) can be exported to excel, and the excel file can be updated. You can then re-import the excel file to bulk update, insert and delete objects, descriptions, SQL Select, etc. In the example below, you can see how objects can be tagged with the text “#SENSITIVEDATA_GDPR_PERSONAL”

tag-universe-objects

Often it is the Business Area that knows which objects they want to tag, rather than the Business Objects Administrators or Universe Developers. What’s great about 360Univ is that the information is exported to excel. The excel file can be sent to the subject matter experts, they can add the tagging where appropriate and then send the file back to the Administrator to import.  

This can also be done manually in Universe Designer or the Information Design Tool (IDT) if there are only a few objects you need to tag. If your organization has a lot of Universes and objects that need to be tagged, then 360Univ will save you a tremendous amount of time. Once these objects are tagged, you have the ability to answer questions about where and how the objects are used, and by whom. Once those tags are set, you can extract data with our other solutions, 360Eyes, to list all the documents that include sensitive objects. You will know where those objects are used, which users are running those reports and where the data are delivered.

How to flag documents

With 360Suite, there are a few ways to flag documents. The process you will follow will depend on the reason you want to flag documents.

Flag documents based on usage (or non-usage)

360Eyes can automate document flagging based on usage, or non-usage. Parameters are set based on the usage you want to flag and the text you want to use for flagging. You can flag documents that haven’t been run in 13 months, 24 months, etc. It is up to you to decide the criteria for flagging based on usage. 

The program runs and flags the documents that meet the criteria you set. Once that flag is set, you can run reports with 360Eyes to list all the documents that have been flagged. From there you can determine what to do with these documents. Maybe you want to archive them, or even bulk delete. Another option is to pseudo-archive the documents, which involves hiding them for a period of time but not removing them from the environment. 360Suite solutions provide several options depending on your needs. 

The image below shows the tag “#TOARCHIVE” added to a document that met the criteria for usage:

flag-documents-usage

This is a great strategy to control the growth of your Business Objects platform via an auto-cleaning mechanism as discussed in the following articles:

  • Control Your BOBJ Platform Growth
  • Alternative Auto Cleaning Process with 360Suite

Flag documents in bulk

Now you may want to flag documents based on criteria other than usage. In that case, you can flag documents in bulk with 360View. In the example below, you can see the feature that allows you to bulk update flags for documents. An excel spreadsheet with a list of CUIDs to be flagged is uploaded. The Flag Value for this example will be “#Sensitive”.

flag-documents-bulk

360Eyes and 360View allow you to generate this list in several ways, based on any given criteria. One use case could be to bulk flag documents that have Universe objects that were tagged as sensitive.

How to leverage those tags

Now that your Universe objects are tagged, how can you leverage them? All of the information that you may need can be retrieved with 360Eyes. There are over 70 pre-built sample Webi reports that extract this information. All you need to do is provide the filters for the data you are looking for:

1. Impact Analysis and Data Lineage

  • Where are sensitive objects used in documents?
  • What is the SQL behind the sensitive objects?
  • What is the data source?

Below is a 360Eyes report that extracted all the reports which contained objects that have been tagged with the text “SENSITIVEDATA”. 

tag-sensitive-data

2. Usage Audit: which documents have not been run in 24 months? 

3. Platform Maintenance: bulk Purge all documents that have not been used in 24 months, or archive/move to another folder. 

4. Regulatory Compliance

  • Which users have access to sensitive data?
  • Which documents contain sensitive data?
  • Which users are refreshing reports with sensitive data?
  • What happens with the data? Is it Emailed? Is it exported to Excel? 

5. Lifecycle Management : by tagging documents and Universes, you will be able to track where in its lifecycle an object is. These tags can be for documents or Universes that are in development, in the testing stage, in production, inactive or are ready to be archived. By understanding an object’s lifecycle, it helps determine if and what actions are needed. For example, promoting objects from one environment to another for testing or to be put into production. 

6. Monitoring : this allows you to track any metadata description changes and not just usage or non-usage of content. For example, if the author or owner of a document or a keyword changes, you can annotate these documents with a tag highlighting that the metadata relating to them has changed or evolved. 

7. Audit : auditing provides the ability to search and document all content based on its metadata for Business Objects, not only in the CMS and Auditor repositories, but also in the filestore, both input, and output, i.e. current documents and instances (historical snapshots of the documents).

Get Organized 

Implementing Business Objects Tags on your Universe objects will save you a significant amount of time when it comes to finding where sensitive data is stored and what documents are not being used. What’s more, is that with 360Suite solutions you no longer need to waste time on manual processes when we provide solutions that allow you to bulk update flags and tags. Our solutions will help you better leverage those tags so that you have a better idea of where your sensitive objects are stored, who has access to what, and if there are actions needed to be put in place. 

Ready to flag your documents and tag your Universe objects?
Contact one of our experts to get started. 

CONTACT US NOW!

Related posts

360Univ360EyesBusiness Objects MetadataBusiness Objects Bulk UpdateBusiness Objects Universe Management360View
Pauline Lancaster / About Author
Pauline, Presales Engineer, and former BOBJ Admin, has over 20 years of professional and technical experience, including 18 years of consulting experience supporting clients in IT development, deployment, and production support. She now helps customers discover better solutions for managing their SAP Business Objects and Tableau environments.
More posts by Pauline Lancaster

Related Posts

business-intelligence-self-service
Help Yourself: Extending the Reach of Self-Service Business Intelligence
0 0
04 Oct 2019
migration Business Objects
Leveraging 360Eyes data for Business Objects migration

A year ago, I was onsite to help a large French telecom company with our solutions for their Business Objects migration….

5
14 Mar 2017
business-objects-security-tips
23 tips for a bulletproof Business Objects Security
0 0
05 Feb 2020
performance-testing
Business Objects Performance Testing
0 3
01 Jun 2018
lockheed-martin-use-case
Reducing Costs, Increasing Automation, and Improving Visibility for Self-Service Reporting at Lockheed Martin
0 0
12 Mar 2019
fannie-mae-maintains-an-efficient-sap-businessobjects-environment
How Fannie Mae Maintains an Efficient SAP BusinessObjects Environment
0 3
20 Mar 2018
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 assessment
Business Objects BI on BI Assessment

For the last decade, we helped our Business Objects clients to maximize their SAP BI investments and reduce associated costs….

4
19 Sep 2017
user adoption
Ensure SAP BusinessObjects User Adoption!

How can you make sure that your Business Objects reports show accurate information? Don’t let your users be unpleasantly surprised when…

3
11 Dec 2016
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
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
crystal-report-connections
The More the Merrier: Bulk Updating Crystal Report Connections
0 0
09 Sep 2019
bi-on-bi-360eyes
How City of Chicago uses BI on BI to improve metadata management, increase security, and save money
0 5
08 Feb 2018
reduce-sap-business-objects-costs
Reduce Your SAP BusinessObjects Costs
0 2
12 Jul 2018
preparation-migration-business-objects-orange
How Orange Prepared For Its SAP BusinessObjects Migration
0 0
29 Jul 2020

Leave a comment Cancel reply

Information

  • Careers
  • Press
  • Terms & Privacy Policy
  • Legal
  • Supplier Code of Ethics

Support

  • Helpdesk
  • Downloads
  • Documentation
  • Knowledge Base
  • Release Notes

Latest news

  • How SAP Ariba Improved Its SAP Data Services Documentation Capabilities
    March 16, 2023
  • What is BI Testing?
    March 8, 2023

Connect With Us

  • Making trusted decisions together
  • Français
2023 © 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.