Posted on

We Can Help You

We Can Help You:

You can engage BISB (BI System Builders Ltd) to design and deliver your Data Warehouse and Business Intelligence Solution. We provide all the Business Intelligence services listed below.


Cornerstone Solution®

A Cornerstone Solution® is the backbone product of knowledge, know how and methods formalised and systematized by BISB. It is a strategic Business Intelligence Solution Architecture and Delivery Framework. It consists of the Cornerstone Framework of BI Solution Architecture and the full Delivery Model (set of Business Intelligence Services and Mechanisms). BI Solution Architecture and a full set of Business Intelligence Services and Mechanisms form a full Business Intelligence Solution known as an End to End BI solution. Cornerstone Solutions® are End to End BI solutions that include End to End Solution Architecture.  Cornerstone Solution® is BI Vendor and data agnostic so regardless of what has been or will be procured it is worth speaking to us.


System Integration

System Integration refers to the installation and configuration of your Business Intelligence Platform and its integration into your Data Warehouse, your Business Process Areas, departments, functions.  The Data Integration component may include legacy source systems, ODS’s, 3NF Enterprise Data Warehouse, master/reference data, spreadsheets, XML files, third party data, text files and RDBMS platforms such as Oracle or MS SQLServer, Informix or DB2.  System Integration works equally well with ‘Big Data’ tool sets as with the long established classic BI tools.


Can We Help?

Optimal Data Warehousing Design & Build

Optimal Data Warehouse design is critical to a successful BI implementation.  Data Warehouse design should be driven by user requirements. BISB use the Agile Data Warehouse Design methods published by Lawrence Corr through workshops to gather requirements and model. A Data Warehouse that does not meet end user requirements is not fit for purpose. A Data Warehouse must have excellent performance, hold trusted data, be loaded in a timely manner and join up the business.


ETL Design For Clean & Trusted Data

Clean and trusted data is achieved through the development of the ETL system which will extract, transform and load data into the Data Warehouse. This involves extracting data from source systems, cleaning it and transforming it before loading. Cleaning and transforming data encompasses numerous tasks such as fixing ‘dirty’ data by removing duplicates, fixing partial records according to business rules, trapping errors and conforming data etc. The benefit of this is that business users have confidence that they are working with data that can be trusted and that is joined up. There are really two big components to the ETL system. These are the development of the system and the management of the system.


Analytic Applications

Analytics consuming clean, quality assured, joined up data are highly valuable to the business. The three most common ways to achieve Business Analytics are to Build, Buy, or Buy and Extend. Business Analytics may be designed and developed for you from scratch (Build), procured from a vendor such as SAP BusinessObjects (Buy), or by using and customising templates (Build and Extend), often referred to as accelerators to jump start a BI initiative.

Business Intelligence Services


 Business Intelligence Competency Centre

Organisations can protect and grow their Business Intelligence investment by establishing a Centre of Excellence (CoE) often referred to as a Business Intelligence Competency Centre (BICC). BISB have advised several companies on BICC strategy and process. The BICC is the optimum way to role out, maintain, support and scale your Business Intelligence initiative.


Business Intelligence Training

BISB can provide bespoke Business Intelligence and SAP BusinessObjects training geared to meet specific needs. This may include end user BI tool training, BI administration, BI system user adoption, Data Warehousing, and Business Intelligence Competency Centre awareness, orientation, and governance.


BISB Business Intelligence Services

The following Business Intelligence Services are provided by BISB.


Macro-Business Intelligence Services

Business Intelligence Strategy

BI Solution Architecture Design

End to End BI Programme & Project Planning & Management

Business Intelligence End To End Solution Design

Business Intelligence Competency Centre – Design, Process, Implementation, & Governance

Business Intelligence Change Management & End User Adoption


SAP BusinessObjects

Our services include the Installation and configuration of the SAP BusinessObjects Business Intelligence Platform in Single or Multi-machine Deployments

Deployment Across Single or Multiple Environments – Production, Pre-Production, System Test, & Development

High Availability & Clustered Environments

SAP BusinessObjects Administration

SAP BusinessObjects Security Model Design & Implementation


Analytics & Report Development Services

SAP BusinessObjects Semantic Layer (Universe) Design (OLAP & Relational)

SAP BusinessObjects Web Intelligence Report Development

SAP BusinessObjects Explorer Development

SAP Crystal Reports Development

SAP BusinessObjects Dashboard Development

SAP BusinessObjects Live Office Development

SAP BusinessObjects Advanced Analysis (OLAP) Development

Ask us about developing with other BI tool sets


 Data Warehousing

Requirements Gathering Workshops (ADWD/ BEAM)

Dimensional Modeling

Logical & Physical Models

Conformed Dimension Bus

Enterterprise Data Warehouse Design

Physical Deployment

Data Federation


ETL System

ETL Strategy

Data Services (Data Integrator) & SSIS ETL Package Design & Development

Metadata Management

Master Data Management

Source to Target Field Mapping & Data Dictionaries

Data Profiling

Data Cleansing & Data Quality

Data Governance


Performance Design

Business Intelligence Platform, RDBMS, & ETL Sizing

Hardware Recommendations

Database Table Design Optimisation e.g. Aggregate Design & Monster Dimension Management

ETL System Optimisation

OLAP Cube & Query Design Optimisation

Optimization of All Reporting Tools Listed Under Report Development Services


Enterprise Performance Management

KPI’s, Balance Scorecards & Strategy Maps







Posted on

Death Of The Cube – Long Live The Cube!

OLAP Cubes

OLAP Cubes

The acquisition of BusinessObjects by SAP paved the way for a very welcome tighter integration between the two softwares. One of the challenges coming out of that tighter integration was the performance of Web Intelligence against an OLAP universe generated on SAP cubes and BEx Queries. The reality of SAP project implementations was that SAP Netweaver experts designed large cubes and large queries. And why not; after all this was the OLAP world?! Large SAP cubes and large BEx Queries make sense for OLAP.

However, Web Intelligence is not an OLAP tool, it builds a cache of data referred to as a ‘microcube’. Note the word ‘microcube’. Attempting to pass large volumes of data from an OLAP query to the microcube could cause the Web Intelligence engine to perform poorly or crash. BISB have observed this on numerous occasions when undergoing performance testing at client site. Problems with the version of Explorer dependent up on the Web Intelligence engine have also been observed for the same reason.

But failing to process large volumes of data was not a weakness of Web Intelligence. On the contrary, Web Intelligence was designed for smaller, fast, ad hoc queries. Users experiencing problems with large volumes of data and Web Intelligence could consider the use of Crystal Reports. Crystal Reports uses a different cache infrastructure to Web Intelligence.

The above mentioned data volume issues have made the SAP BI 4.0 road map very welcome. Using the new Data Federator connectivity through the SAP BusinessObjects BI 4.0 universe means that the SAP MDX engine (OLAP) is bypassed. This removes one of the big issues of the SAP OLAP data volumes, namely MDX crossjoins. Other development means that the BI 4.0 universe now has connectivity to SAP HANA. If you have the budget available this makes SAP HANA highly desirable for Big Data and Analytics.

Finally, ardent OLAP users that cannot live without a cube have not been left out in the cold. BI 4.0 ushered in the end of the Voyager OLAP tool, replacing it with the new Advanced Analysis for OLAP tool.

The view expressed in this article is from BISB and not necessarily SAP. Russell Beech was Senior Analyst in the BusinessObjects Analytic Applications Division for almost six years. Check out Web Intelligence In Under Three Minutes here.

Posted on

Privacy Statement


By using this Website, you consent to the collection and use of the information as described here. If we decide to make changes to this Privacy Statement, we will post the changes on this site so that you will always know what information we collect, and how we use it. From time to time, as may be required by applicable law, we may also seek your explicit consent to process certain data and information collected on this website or volunteered by you.

Collection and Processing of Your Personal Data

To serve you better and understand your needs and interests, BI System Builders collects, exports, and uses personal information with adequate notice and consent. When you visit our web site, we may record your IP address and use cookies and other Internet technologies (referred to below as Automated Tools and Embedded Web Links) to gather general information about our visitors and their interests. The technologies used and the information collected are described in more detail below.  We may further collect and process any information and data that you volunteer to us, e.g. when you register for events, subscribe to newsletters, participate in online surveys, discussion groups or forums, or when make purchases.

Use and Purpose of Collected Personal Data

The information BI System Builders collects to understand your needs and interests helps BI System Builders deliver a consistent and personalized experience. We will use such information only as described in this Privacy Statement and/or in the way we specify at the time of collection. We will not subsequently change the way your personal data is used without your consent, as required by applicable law. Some of the ways we may use your personal data include, but are not limited to:

  • To process your orders and deliver the products and services that you have ordered;
  • To keep you up to date on the latest product announcements, software updates, software upgrades, security patches, system enhancements, special offers, and other information from SAP and BI System Builders. This may occasionally include information from other technology companies or business partners about products and services that can add value to your SAP products;
  • To tailor information about SAP products and services to your individual interests. For example, during a business engagement, it allows us to provide you with specific information on products and services that may be of interest;
  • To provide the ability to contact you, and provide you with billing information, and to provide customer feedback and support;
  • To provide contests, sweepstakes or other marketing or promotional activities. Personal data may be collected to administer those programs;
  • To conduct questionnaires and surveys in order to provide better services to our customers. Your completion of any questionnaires is voluntary;
  • To support recruitment inquiries; and
  • To meet contractual obligations.


We use IP addresses to help diagnose problems, to administer our website, and to gather demographic information. We may also use IP addresses or other information you have shared on this website or at any earlier occasion or a campaign code, to determine which pages on our sites are being visited and topics that may be of interest so we can provide you with information about relevant products and services. Generally, BI System Builders will aggregate such data only in an anonymous way and will not tie it to a particular individual unless he or she has given consent. When you visit our site, we recognize only your domain name.  Your IP address will not be used to identify you unless you provide your prior consent.

Automated Tools

In addition to the information you provide, BI System Builders may also collect information during your visit to a BI System Builders website through automated tools, which include Web beacons, cookies, embedded Web links, and other commonly used information-gathering tools. These tools collect certain standard information that your browser sends to our website such as your browser type and language, access times, and the address of the website from which you arrived at the BI System Builders website. Using these tools, BI System Builders is also able to confirm receipt of e-mails that the recipient consented to receive, and can track other information such as pages visited on the BI System Builders site and whether or not the recipient registers for an event offered by BI System Builders and certain other aggregate data that is not related to a particular individual.

Embedded Web Links

Emails from BI System Builders often use links designed to lead you to a relevant area on the Web, after redirection through BI System Builders’ servers. The redirection system allows BI System Builders to change the destination URL of these links, if necessary, and to determine the effectiveness of our marketing initiatives. In emails, such links may also allow BI System Builders to determine if you have clicked on a link in the email, and the information about this interaction may be connected to your personal identity. If you do not want BI System Builders to collect information about the links you clicked, you can simply choose not to click on the links in an e-mail that BI System Builders sends you.


We may use cookies to deliver personalized content, to save you having to re-enter your password repeatedly, and to tailor our information offerings to how you and others use the site.

E-mail Addresses

If you choose to give us your e-mail address, we will communicate with you via e-mail. We do not share your e-mail address with others outside BI System Builders or the SAP Group of companies. You can choose not to receive any more e-mail at any time. Depending on how your e-mail application is set up, information about you may be transmitted automatically when you send e-mail to BI System Builders. If you choose to register for third-party services, we may need to send some information from your BI System Builders registration to the service provider, possibly including your e-mail address.

Event Registration

Our site includes forms that you fill out to request information and services. These forms may collect your financial information, such as your banking details or credit card numbers. BI System Builders promises to use any financial information that you submit solely for billing and payment purposes for that special transaction. This may include the transfer of your data to third parties involved in executing the transaction, such as banks, credit card companies and other financial and credit control institutions.

Sharing Your Personal Data

BI system Builders may use the information in connection with processing your inquiries and orders, to help improve our services and for processing and storage. We may also share such information with business partners, service vendors, authorized third-party agents or contractors in order to provide a requested service or transaction, including processing orders, processing credit card transactions, hosting websites, hosting event and seminar registration and providing customer support, or providing you with information on products and services that may be of interest to you.

We only provide these third parties with the minimum amount of personal data necessary to provide the services on our behalf, and the third parties are not permitted to use your personal data except for the limited purpose of completing the requested service or transaction. We do not sell or rent your personal data to third parties for marketing purposes unless you have granted us permission to do so.

We may respond to subpoenas, court orders, or legal process by disclosing your personal data and other related information, if necessary. We also may choose to establish or exercise our legal rights or defend against legal claims.

Circumstances may arise where, whether for strategic or other business reasons, BI System Builders decides to sell, buy, merge or otherwise reorganize its businesses in some countries. Such a transaction may involve, in accordance with applicable law, the disclosure of personal information to prospective or actual purchasers, or the receipt of it from sellers. It is BI System Builders’ practice to seek appropriate protection for information in these types of transactions.

We may collect and possibly share personal data and any other additional information available to us in order to investigate, prevent, or take action regarding illegal activities, suspected fraud, situations involving potential threats to the physical safety of any person, violations of BI System Builders’ terms of use, or as otherwise required by law.

While visiting BI System Builders’ website you may be directed to content or functionality that is hosted by a third-party supplier, not on Most often, this is done to host special events, such as contests or seminars. When information is collected on behalf of BI System Builders exclusively, the appropriate BI System Builders’ privacy statement will be referenced on the site and will govern how information is used. For other, non-BI System Builders’ sites, the site’s owner’s privacy policy will be referenced.

Security of Your Personal Data

BI System Builders is committed to protecting the personal data you share with us. BI System Builders use a combination of security technologies, procedures, and organizational measures to help protect your personal data from unauthorized access, use or disclosure.

Links to Other Sites

This site may contain links to other sites. BI System Builders is not responsible for the privacy practices or the content of other websites outside the BI System Builders company.


We communicate with users who subscribe to our services on a regular basis via email, and we may also communicate by phone to resolve customer complaints or investigate suspicious transactions. We may use your email address to send you information about changes to our services, and to send notices and other disclosures as required by law. Generally, users cannot opt out of these communications, but they will be primarily informational in nature rather than promotional.

BI System Builders provides you the opportunity to exercise an opt-out choice if you do not want to receive other types of communication from us such as emails or updates from us regarding new services and products offered on this website or if you do not want us to share your personal information with third parties.

Children’s Privacy

BI System Builders does not knowingly collect Personal Data from children under the age of 13. If we learn that we have collected Personal Data on a child under the age of 13, we will delete that data from our systems.


If you have any other questions about this privacy statement or if you wish to inspect the information we hold about you, please contact: