Web Intelligence - Tutorial7

Web Intelligence

Obily B W
SAPANDME.BLOGSPOT.COM
SAP Business Objects 4.0 SP02

sapandme.blogspot.com

WEB INTELLIGENCE – TUTORIAL 7

Beginners guide to Web Intelligence

1. Introduction to Web Intelligence

2. Documents and Queries

3. Data Restrictions

4. Creating Web Intelligence Reports

5. Enhancing and Formatting Reports

6. Formulas and Variables

7. Synchronizing multiple Sources

8. Analyzing Data and Managing Reports

Obily B W



Analyzing Data using WebI

Drilling
For this your account needs to have proper authorization to create document
using drill mode. Check the screen shots below;

Obily B W



With scope level none with scope level two

We can take snapshot of the drilled down block for further analysis

The snapshot will be copied to another report panel within the document.
During drilling a new toolbar will appear at the top of the document

Obily B W



If the report contains aggregate measures calculated at the database level, one
can use Query drill option. On activation Query drill drills by modifying the
underlying query, by adding or removing dimensions, filters etc. Query drill will
reduce the amount of data that WebI stores locally during usual drill function.

Obily B W



Sharing Documents
To make the document visible to others, one option is to save the same in “Public
Folders”, or save the reports in excel or pdf formats and distribute the same or
distribute directly in “.wid” format.

Combined Queries
If we want an intersection value of two queries as the result, we move for
combined queries. Like, if we need all the products list that doesn’t had any
special promotions and the database only had flag towards promoted products;

In this case we need to move with combined queries as below;
Obily B W



First query, with no filters will show all the values;

Second query showing only products with special promotions;

So the resulted report after combining these two queries should have 203
instances. And the combination here should be a “minus” (others are
intersections and union)

Obily B W



Combined queries should be from same universe; exactly same objects must be
used in the queries. Only objects created in the first query will be displayed in the
block. For returning unique rows, change the query properties.

Sub Queries
This is used when the results of a query is depended on results of an inner query.
Inner query will be processed first and then the results are passed to Main query.
Check the example shown below.
We need to find all the stores that draw more revenue than a particular store (A)
in the country.
For that first we need to know the revenue of the store A.

Obily B W



Obily B W



Using Functions
Some function details…

RIGHT() Extract given number of characters from right
REPLACE() Replace specific string with another one
LEFT() Extract given number of characters from left
SUBSTR() It uses variable length and position to extract a string within
another string
LENGTH() Find length of a string
POS() Find the position of a character in a string

Some examples…
1) =NAME OF([YEAR])+”-“+RIGHT([YEAR];2)

2) =REPLACE([QUARTER];”Q”;”Quarter”)

Obily B W



3) =SUBSTR([STORE NAME];11; LENGTH([STORE NAME]))
Here the syntax is “substr(string name; start position; total length of string)”

Obily B W



4) SUBSTR([ADDRESS];POS([ADDRESS];” “)+1; LENGTH([ADDRESS]))

Obily B W



5) Using date function

6) Using IF() function
Some examples below;
For getting half yearly revenues, we need to sum up quarterly details…
1st half = Q1+Q2
2nd half = Q3+Q4
Create a variable “HalfYearlySales” and use the following logic;
=IF [QUARTER] INLIST(“Q1”;”Q2”) THEN “First half” ELSE “Second half”

Obily B W


Web Intelligence - Tutorial7

More Related Content

What's hot

Similar to Web Intelligence - Tutorial7

Recently uploaded

Web Intelligence - Tutorial7