Optimize BI & Analytics Apps

Alex Stevenson demonstrates how to optimize legacy BI & Analytics applications using Metoscope automation software. This presentation was given at the Hyperion Solutions 2020 virtual conference organised by InterRel Consulting.

Inspect

This page provides a developer or analyst with the facility to inspect all captured information relating to an element and is available within the Analysis module.

Inspect is comprised of the following panes:

Selection Options

Explore

Compare

Visualize

Annotations

Usage

Selection Options

Explore

Compare

Visualize

Annotations

Usage

Editing or Deleting an Instance | Product Module

Editing or Deleting an Instance | Product Module

Edit

Follow these steps to edit an existing Instance | Product Module:

  1. move the mouse-pointer over the edit link on the appropriate table row and click.
  2. amend the Instance Name and/or Instance Description and click on Save to commit or Cancel to return to the Instances tab.

Delete

Follow these steps to delete an existing Instance | Product Module:

  1. move the mouse-pointer over the delete link on the appropriate table row and click.
  2. a confirmation dialog box will be displayed with “Yes” and “No” buttons. Click on Yes to proceed with deletion of selected Instance | Product Module or No to return to the Instances tab.

Tip: exercise caution when deleting as this change cannot be undone.

Adding a new Application Instance | Product Module

Definition: An Application Instance is a specific occurrence of an application of a Vendor’s software in a distinct environment. For example, there may be a SAP BusinessObjects “Sales & Marketing” BI application that is implemented in 3 environments, e.g. Development, Test and Production. Each application + environment combination is referred to as an “Instance”.

A Product Module is a module within a BI or Analytics software product, e.g. SAP BusinessObjects Web Intelligence Documents, SAP BusinessObjects Universes or Power BI Service, amongst many examples.

Adding an Instance | Product Module

Follow these steps to create an Application Instance with relevant Product Module:

  1. first select a relevant Product Module for which meta data will be captured.
    Tip: the values listed in the Product Module control are populated based on available adaptors. The concatenations of <Vendor | Product | Product Module | Version> are distinct.
  2. next, enter a unique name into the Instance Name field, e.g. “Sales & Marketing (Prod)”
  3. enter a meaningful description
  4. click on the Save button
  5. the adjacent table Current Instances | Product Modules will be updated with the new addition.

Persisted Data Refresh

NB: once a change has been applied to an Instance | Product module it is important that the application data is refreshed. To do this, position the mouse-pointer over the data refresh icon in the top right corner of the page and click.

Explore

This page enables an analyst or developer to search all of the captured meta data associated with a selected Product Module and one or more Instances.

Selection Controls:

This is where the scope of the initial search is set.

Figure 1: selection controls

To select the scope of search, undertake the following tasks:

  1. select a single a Product Module from the dropdown control. The Instance dropdown will be populated with valid values.
  2. select one or more Instances from the dropdown control using the checkboxes. The table underneath the Instance control will be populated with Parts that are present in the selected Instances.
  3. select one, more than one or all Parts using the checkboxes.
    Note: by positioning the mouse-pointer over a column header and right-clicking the mouse button, a local column filter will be displayed which enables a search to be applied to the Parts table. Click away from the table to hide the filter.

Analysis Overview

The Analysis module is designed to enable the exploration of captured meta data in order to achieve rapid insights. Accessed via the topline tab menu or through guided navigation from the Home page, the following pages are available:

Figure 1: Tabs available under “Analysis”

Explore: enables retrieval of nodes, attributes and values from multiple instances of a selected Product Module. For example, search for all occurrences of a key word (e.g. “discount”) or object type (e.g. query) across SAP BusinessObjects instances for Finance and Sales & Marketing.

Inspect: provides a facility to view captured meta data, usage data and applied annotations relating to a single selected Part (e.g. dashboard, analysis, report or semantic layer). Furthermore, visualizations are available to view the Object Model of the selected Part or view as a hierarchical tree or treemap. It is also possible to view the similarity of the selected Part against all other parts within the relevant Instance.

Query: this is where a user can write, save and re-use their own SQL queries to interrogate the meta data repository.

Visualize: a range of chart and diagram types are available to support insights into lineage, hierarchical relationships and structures between and within BI & Analytics Parts.

How to Contact Support

WordPress started in 2003 with a single bit of code to enhance the typography of everyday writing and with fewer users than you can count on your fingers and toes. Since then it has grown to be the largest self-hosted blogging tool in the world, used on millions of sites and seen by tens of millions of people every day.

The following is a list of some of the features that come standard with WordPress, however there are literally tens of thousands of plugins that extend what WordPress does, so the actual functionality is nearly limitless. You are also free to do whatever you like with the WordPress code, extend it or modify in any way or use it for commercial projects without any licensing fees. That is the beauty of free software, free meaning not only price but also the freedom to have complete control over it.

Your Entire Workflow

WordPress can take the place of your entire workflow from the initial draft to the time you hit publish – spelling, grammar, collaboration, and review – there’s no need for e-mails back-and-forth or expensive desktop software.

WordPress is a powerful semantic publishing platform, and it comes with a great set of features designed to make your experience as a publisher on the Internet as easy, pleasant and appealing as possible.

We are proud to offer you a freely distributed, standards-compliant, fast, light and free content management system, with sensible default settings and features, and an extremely customizable core.

Beyond Black and White

Everything that makes webpages feel rich – pictures, videos, music, documents – can feel right at home in WordPress. With a drag-and-drop file uploader that uses the latest technology to ensure your file effortlessly makes it to the web page every time, and a media browser to help you store, organize and find the files you’re looking for, WordPress hosts the files that make your pages pop:

  1. Your Site is Your Castle
  2. Extensive APIs
  3. Enterprise Ready
  4. Interoperability
  5. Trust, but Verify

Not everyone is evil, but keep those who are in check by limiting which html tags are kosher on your weblog.

The Right Tuxedo for Any Content

Your content deserves the best. The site should conform to your content, not the other way around. WordPress comes with a full theme system which makes designing everything from the simplest site to the most complicated portal a piece of cake. Have a new design every day. Your ideas should look as good as what they say.

Everything you see here, from the documentation to the code itself, was created by and for the community. WordPress is an Open Source project, which means there are hundreds of people all over the world working on it. (More than most commercial platforms.) It also means you are free to use it for anything from your cat’s home page to a Fortune 500 web site without paying anyone a license fee and a number of other important freedoms.

Obsessively Organized

It doesn’t matter how much content you have, if your visitors can’t find it. WordPress organizes your content by day, by month, by year, by author, by category — any way you can describe it — and dynamically creates browsable archives so things always stay up to date.

WordPress has killer search baked in. Every word you write is fully searchable through a single box at the top of each page and if your users choose to use an external search engine like Google, rest assured, WordPress will present your content in a way that all but ensures it makes it to the top of the results every time

With built in support for custom post types and custom taxonomies, if you can dream it, WordPress can make it a reality.

How do I Change my Password?

WordPress started in 2003 with a single bit of code to enhance the typography of everyday writing and with fewer users than you can count on your fingers and toes. Since then it has grown to be the largest self-hosted blogging tool in the world, used on millions of sites and seen by tens of millions of people every day.

The following is a list of some of the features that come standard with WordPress, however there are literally tens of thousands of plugins that extend what WordPress does, so the actual functionality is nearly limitless. You are also free to do whatever you like with the WordPress code, extend it or modify in any way or use it for commercial projects without any licensing fees. That is the beauty of free software, free meaning not only price but also the freedom to have complete control over it.

Your Entire Workflow

WordPress can take the place of your entire workflow from the initial draft to the time you hit publish – spelling, grammar, collaboration, and review – there’s no need for e-mails back-and-forth or expensive desktop software.

WordPress is a powerful semantic publishing platform, and it comes with a great set of features designed to make your experience as a publisher on the Internet as easy, pleasant and appealing as possible.

We are proud to offer you a freely distributed, standards-compliant, fast, light and free content management system, with sensible default settings and features, and an extremely customizable core.

Beyond Black and White

Everything that makes webpages feel rich – pictures, videos, music, documents – can feel right at home in WordPress. With a drag-and-drop file uploader that uses the latest technology to ensure your file effortlessly makes it to the web page every time, and a media browser to help you store, organize and find the files you’re looking for, WordPress hosts the files that make your pages pop:

  1. Your Site is Your Castle
  2. Extensive APIs
  3. Enterprise Ready
  4. Interoperability
  5. Trust, but Verify

Not everyone is evil, but keep those who are in check by limiting which html tags are kosher on your weblog.

The Right Tuxedo for Any Content

Your content deserves the best. The site should conform to your content, not the other way around. WordPress comes with a full theme system which makes designing everything from the simplest site to the most complicated portal a piece of cake. Have a new design every day. Your ideas should look as good as what they say.

Everything you see here, from the documentation to the code itself, was created by and for the community. WordPress is an Open Source project, which means there are hundreds of people all over the world working on it. (More than most commercial platforms.) It also means you are free to use it for anything from your cat’s home page to a Fortune 500 web site without paying anyone a license fee and a number of other important freedoms.

Obsessively Organized

It doesn’t matter how much content you have, if your visitors can’t find it. WordPress organizes your content by day, by month, by year, by author, by category — any way you can describe it — and dynamically creates browsable archives so things always stay up to date.

WordPress has killer search baked in. Every word you write is fully searchable through a single box at the top of each page and if your users choose to use an external search engine like Google, rest assured, WordPress will present your content in a way that all but ensures it makes it to the top of the results every time

With built in support for custom post types and custom taxonomies, if you can dream it, WordPress can make it a reality.

Our Content Policy

WordPress started in 2003 with a single bit of code to enhance the typography of everyday writing and with fewer users than you can count on your fingers and toes. Since then it has grown to be the largest self-hosted blogging tool in the world, used on millions of sites and seen by tens of millions of people every day.

The following is a list of some of the features that come standard with WordPress, however there are literally tens of thousands of plugins that extend what WordPress does, so the actual functionality is nearly limitless. You are also free to do whatever you like with the WordPress code, extend it or modify in any way or use it for commercial projects without any licensing fees. That is the beauty of free software, free meaning not only price but also the freedom to have complete control over it.

Your Entire Workflow

WordPress can take the place of your entire workflow from the initial draft to the time you hit publish – spelling, grammar, collaboration, and review – there’s no need for e-mails back-and-forth or expensive desktop software.

WordPress is a powerful semantic publishing platform, and it comes with a great set of features designed to make your experience as a publisher on the Internet as easy, pleasant and appealing as possible.

We are proud to offer you a freely distributed, standards-compliant, fast, light and free content management system, with sensible default settings and features, and an extremely customizable core.

Beyond Black and White

Everything that makes webpages feel rich – pictures, videos, music, documents – can feel right at home in WordPress. With a drag-and-drop file uploader that uses the latest technology to ensure your file effortlessly makes it to the web page every time, and a media browser to help you store, organize and find the files you’re looking for, WordPress hosts the files that make your pages pop:

  1. Your Site is Your Castle
  2. Extensive APIs
  3. Enterprise Ready
  4. Interoperability
  5. Trust, but Verify

Not everyone is evil, but keep those who are in check by limiting which html tags are kosher on your weblog.

The Right Tuxedo for Any Content

Your content deserves the best. The site should conform to your content, not the other way around. WordPress comes with a full theme system which makes designing everything from the simplest site to the most complicated portal a piece of cake. Have a new design every day. Your ideas should look as good as what they say.

Everything you see here, from the documentation to the code itself, was created by and for the community. WordPress is an Open Source project, which means there are hundreds of people all over the world working on it. (More than most commercial platforms.) It also means you are free to use it for anything from your cat’s home page to a Fortune 500 web site without paying anyone a license fee and a number of other important freedoms.

Obsessively Organized

It doesn’t matter how much content you have, if your visitors can’t find it. WordPress organizes your content by day, by month, by year, by author, by category — any way you can describe it — and dynamically creates browsable archives so things always stay up to date.

WordPress has killer search baked in. Every word you write is fully searchable through a single box at the top of each page and if your users choose to use an external search engine like Google, rest assured, WordPress will present your content in a way that all but ensures it makes it to the top of the results every time

With built in support for custom post types and custom taxonomies, if you can dream it, WordPress can make it a reality.