web intelligence - tutorial7

sapandme.blogspot.com

SAP Business Objects 4.0 SP02

Obily B W

SAPANDME.BLOGSPOT.COM

Web Intelligence

SAP Business Objects 4.0 SP02 SAPANDME.BLOGSPOT.COM

Web Intelligence

WEB INTELLIGENCE WEB INTELLIGENCE WEB INTELLIGENCE WEB INTELLIGENCE –––– TUTORIAL 7TUTORIAL 7TUTORIAL 7TUTORIAL 7

Obily B W


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

Technology