Jump to: navigation, search

BO Documentation

BOE 3.1 and BI 4.1 are created and documented by SAP. SAP provides detailed information about the operation of the Universe Design Tool, Information Design Tool, Web Intelligence, InfoView, Designer, and other BO or BI applications. Access this SAP documentation from the following sources:

  • from the SAP BusinessObjects Business Intelligence Platform Documentation CD,
  • if you are a direct SAP customer, from the SAP website,
  • if you obtained BO software through Genesys, from the SAP website.




Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Example - Product Line and Product

This customization example adds two dimensions to the Info Mart database that are derived from string-based attached data that might exist in your environment. These dimensions (Product Line and Product) form a Product hierarchy within the GI2 universe that you can drill. You can add these dimensions to the GI2 reports to provide results by product, by product line, or by any other dimension that you choose to substitute in this example.

The general steps for customization are the following:

1. Create and populate one or more user data tables in the Info Mart database. [+] Show Steps
2. Configure user data keys in the aggregation tables to point to your user data table(s) and populate the aggregation tables. [+] Show Steps
3. Set Genesys Info Mart and Interaction Concentrator configuration options for collection of user data. [+] Show Steps
4. Add the attached data tables to the universe structure. [+] Show Steps
5. Add LOV, dimensions, and filters. [+] Show Steps
6. Define a hierarchy within the universe for attached data that has parent-child relationships, such as Product Line and Product. [+] Show Steps
7. Save the universe and export it to the repository.
8. Customize the Interactive Insights reports to include your attached data dimensions. [+] Show Steps

Sample SQL Script for Creating and Mapping User Data

The following sample script provides the SQL code that is used for this example.

[+] Show Sample Code

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 25 May 2017, at 05:56.