click through x tract q vb w cube

8/11/2019 Click Through x Tract q Vb w Cube

1/21

How to extract SAP BW Queries

into QlikView


2/21

We start the Xtract QV Designer.

Click Connect (1) to connect to the (local) Xtract QV Server.

www.theobald-software.com 2


3/21

Click New(1) to create a new Extraction.

Enter a name for the extraction (2)

Select BW Cube / Query as extraction type (3)

and Click Okto continue.



4/21

In the Xtract Connection Manager fill in logon credentials (1)

and host information (2)

Test the Connection (3)

and Click OK twice to confirm (4)



5/21

The Xtract BW Cube dialog opens.

Click to open Look Up dialog (1)

Fill in BW Query name (2) Click to search the BW Query (3)



6/21

Select your BW Query (1)

Click OKto confirm selection (2)



7/21

The meta data is automatically fetched from SAP.

Now drag and drop the Key Figures and Dimensions(1) to the right

pane of the dialog (2)

Click OKto continue (3)



8/21

Right click on the entry and select Copy QV Scriptto generate the

ready-to-use Script into the clipboard (1)

Alternatively click on Run -> Generate QlikView Script



9/21

Start QlikView and create a new document.

Click to open the Script Editor (1)



10/21

Paste the Xtract QV Script from the clipboard into the Main area

by pressing Ctrl + V (1)

Click OKto exit the Script Editor (2)



11/21

Click to Reload Script (1)

After successful loading click to start Quick Chart Wizard (2)

Select Bar Chart (3)

Click Nextto go to the next screen (4)



12/21

Select_0D_COUNTRY from the list of the Dimensions (1)




13/21

Select the first Measure from the Drop Down list (1)




14/21

Leave the settings to default (1)

Click Finishto end the Wizard (2)



15/21

Right click on the Chart we created

Select Properties(1)



16/21

The Chart Properties opens. Select ExpressionsTab (1)

ClickAdd(2)



17/21

Insert the Sum of the second Measure into the Expression Area (1)

Click OK to exit the Expression Editor (2)



18/21

Click OKto exit the Chart Properties Dialog (1)



19/21

Enjoy the first result



20/21

Play around with the data. Seeing is believing.



21/21

www theobald-software com 21

If you have any questions or comments, please write at:

[email protected]

click through x tract q vb w cube

Documents