Create a Web Intelligence report on SAP NetWeaver BW data using an existing multisource

Using SAP NetWeaver Business Warehouse Variables in Web Intelligence

Task 2: Create a Web Intelligence report on SAP NetWeaver BW data using an existing multisource

universe

Create a new Web Intelligence document on the multisource universe U##_MSU_CallData.unx using BI Launch Pad.

1. Launch BI Launch Pad and log on with the following details:

Field name Value

System wdflbmt2268

SAP System RWB

SAP Client 800

User Name user## (replace ## with your

assigned group number)

Password Enter your password

Authentication SAP

2. Create a Web Intelligence query against a SAP NetWeaver BW InfoProvider.

Log on information Field name Value SystemAssigned

system

Assigned system

User name user## (replace ## with your assigned group number) Password Enter your password

Authentication SAP

3. Create a query with the dimensions Material Name, and the measure Number of Calls. Set a query filter to see results that have more than 1 call.

Make sure that the descriptions of the values for Material are displayed in the result.

4. Save your report in the SAP BusinessObjects BI platform folder All Folders

→ BI Training → User Area → User ## with the name U## WebI Multisource Universe.

179

Unit 4: SAP BusinessObjects Web Intelligence TBI30

Solution 7: Create a Web Intelligence Document on SAP NetWeaver BW Data Sources

Task 1: Creating a Web Intelligence document on SAP NetWeaver BW data using the BICS connectivity for direct access

Create a Web Intelligence document based on a BW query with hierarchies and an optional variable using Web Intelligence Desktop.

Query information

Field name Value

SAP NetWeaver BW Query Sales by Material (Hierarchy) [P_SALES_MAT_HIER]

InfoProvider MultiProvider - Customer Sales [P_SALES01]

1. Launch SAP BusinessObjects Web Intelligence.

a) Select Start → Programs → SAP BusinessObjects Enterprise BI platform 4.0 → SAP BusinessObjects BI platform Client Tools → Interactive Analysis Desktop.

2. Create a Web Intelligence query against the SAP NetWeaver BW query with the description Sales by Material (Hierarchy).

Log on information Field name Value

System wdflbmt2268

User name user## (replace ## with your assigned group number) Password Enter your password

Authentication SAP

a) Choose Bex as data source for your new document.

b) Enter your logon information provided the instructor.

c) Select Customer Sales Multiprovider.

Continued on next page

180

TBI30 Lesson: Web Intelligence and SAP NetWeaver Business Warehouse Data Sources

d) Enter the description of the query Sales by Material (Hierarchy)in the search field and click Enter.

e) Choose the query and click OK.

3. Drag the following objects into the Result Objects panel.

Type Value

Hierarchy Product Hierarchy for material MARA Measure Sales Volume EUR

Select only the Product hierarchy node and all its descendents of the hierarchy and run the query.

a) In the Query Panel, expand the node Material and drag Product Hierarchy for material MARA into the Result Objects pane.

b) Drag Sales Volume EUR into the Result Objects pane.

c) Click the arrow on the hierarchy element in Result Objects pane.

The Member Selector window opens.

d) In the Member Selector window, select the checkbox left to Product hierarchy.

e) Right-click Product hierarchy and choose Descendents.

f) Click OK.

g) Click Run query.

4. In the report, you only want to see data from Sales Organization Germany Frankfurt [1000].

Hint: To see the list of values, you have to Refresh Values . a) In the Prompts window, select Sales Org (Multi/Optional) and choose

Germany, Frankfurt.

Hint: Display the keys for the available values using the Hide/Show keys values button .

b) Select Hierarchy Node (Material) in the left pane. Do not make any selection here.

c) Click OK.

Continued on next page

181

Unit 4: SAP BusinessObjects Web Intelligence TBI30

5. Navigate through the report.

a) Expand the hierarchy nodes by clicking the Plus signs.

6. Set Product Hierarchy as Section.

a) Right-click Product Hierarchy and choose Set as Section.

7. Navigate through the report again to see the effect of sections.

a) Expand the hierarchy nodes by clicking the Plus signs.

8. Remove the sections by undoing your changes.

a) Click Undo until the initial report is displayed.

9. Duplicate the report table.

a) Right-click on the border of the table and choose Copy.

b) Right-click under the table and choose Paste.

10. Turn the second table into a column chart.

a) Right-click on the duplicated table and choose Turn Into → Column.

11. Change the Report Title to Product Hierarchy - Sales Volume EUR.

a) Double-click Report 1 and enter Product Hierarchy - Sales Volume EUR.

12. Save your report in the BusinessObjects BI platform folder Public Folders

→ BI Training → User Area → User ## with the name U## Product Hierarchy.

a) Click the arrow next to Save on the toolbar in the File tab and select Publish to... to display the Publish a document to the server dialog box.

b) Navigate to the folder Public Folders→ BI Training → User Area → User ## and enter the name U## Product Hierarchy.

c) Click Save.

Task 2: Create a Web Intelligence report on SAP NetWeaver BW data using an existing multisource universe

Create a new Web Intelligence document on the multisource universe U##_MSU_CallData.unx using BI Launch Pad.

1. Launch BI Launch Pad and log on with the following details:

Continued on next page

182

TBI30 Lesson: Web Intelligence and SAP NetWeaver Business Warehouse Data Sources

Field name Value

System wdflbmt2268

SAP System RWB

SAP Client 800

User Name user## (replace ## with your

assigned group number)

Password Enter your password

Authentication SAP

a) Select Start → Programs → SAP BusinessObjects Enterprise BI platform 4..0 → Custom Link to BI Launchpad.

b) In the home page of BI Launch Pad, click Applications → Web Intelligence Application to start Web Intelligence.

2. Create a Web Intelligence query against a SAP NetWeaver BW InfoProvider.

Log on information Field name Value SystemAssigned

system

Assigned system

User name user## (replace ## with your assigned group number) Password Enter your password

Authentication SAP

a) Click New.

b) Choose Universe as data source for your new document.

c) If requested, enter your logon information.

d) Select the multisource universe U##_MSU_CallData.unx.

3. Create a query with the dimensions Material Name, and the measure Number of Calls. Set a query filter to see results that have more than 1 call.

Continued on next page

183

Unit 4: SAP BusinessObjects Web Intelligence TBI30

Make sure that the descriptions of the values for Material are displayed in the result.

a) Drag Material Name into the Result Objects pane b) Drag Number of Calls in the Result Objects pane.

c) Drag Number of Calls in the Query Filters pane and set it Greater than 1.

d) Click Run query.

4. Save your report in the SAP BusinessObjects BI platform folder All Folders

→ BI Training → User Area → User ## with the name U## WebI Multisource Universe.

a) Click the arrow next to Save on the toolbar in the File tab and select Publish As... to display the Publish a document to the server dialog box.

b) Navigate to the folder All Folders → BI Training → User Area → User

## and enter the name U## WebI Multisource Universe.

c) Click Save.

184

TBI30 Lesson: Web Intelligence and SAP NetWeaver Business Warehouse Data Sources

Lesson Summary

You should now be able to:

• Explain the SAP NetWeaver Business Warehouse connectivity options

• Explain how to use BEx queries in Web Intelligence using BICS connection

• Describe the elements of SAP NetWeaver BW OLAP universes

• Describe how SAP NetWeaver BW objects are mapped and used in an universe

185

Unit Summary TBI30

Unit Summary

You should now be able to:

• Classify the main target groups as well as the main business scenarios where users can benefit from using SAP BusinessObjects Web Intelligence

• Discuss the positioning of SAP BusinessObjects Web Intelligence within the SAP Business Intelligence portfolio

• Explain basic Web Intelligence functions

• Explain how to use advanced Web Intelligence functions

• Create a Web Intelligence document with advanced functions on an universe

• Explain the SAP NetWeaver Business Warehouse connectivity options

• Explain how to use BEx queries in Web Intelligence using BICS connection

• Describe the elements of SAP NetWeaver BW OLAP universes

• Describe how SAP NetWeaver BW objects are mapped and used in an universe

186

In document TBI30 SAP Business Intelligence Solutions with SAP Business Warehouse (Page 193-200)