BW Text Variables of Type Replacement Path

[Pages:18]BW Text Variables of Type Replacement Path

Applies to:

This article is applicable to SAP BI 7.0. For more information, visit the EDW homepage.

Summary

This document shows how to use and also helps in the analysis of issues with BW text variables of type replacement path. The document will show how to create a sample query using this feature, discuss some parameters, tables and functions which will help in the analysis of problems in this area. Author: Ricardo de Azeredo Rosa Company: SAP Labs Brazil Created on: 11 July 2010

Author Bio

Ricardo is a Support Consultant in SAP Labs Brazil since 2007. He has worked extensively on SAP R/3 and BW as a PM Certified and BW Consultant since 2002. His knowledge includes PM, CS, DMS, PP, PS modules and BW systems. Since 2004 he has focused his knowledge in Business Warehouse working in various critical projects in this area.

SAP COMMUNITY NETWORK ? 2010 SAP AG

SDN - sdn. | BPX - bpx. | BOC - boc. | UAC - uac. 1

BW Text Variables of Type Replacement Path

Table of Contents

Text variables of type Replacement Path:......................................................................................................3 Replacement Path Tab ..............................................................................................................................8 Hints Regarding Issues in this area:...........................................................................................................9 Detailing this issue:..................................................................................................................................13 Replacing texts and/or Key: .....................................................................................................................15 Tables T009 and T009C ? text for 0FISCPER..........................................................................................15 Related Content:......................................................................................................................................17

Copyright ....................................................................................................................................................18

SAP COMMUNITY NETWORK ? 2010 SAP AG

SDN - sdn. | BPX - bpx. | BOC - boc. | UAC - uac. 2

BW Text Variables of Type Replacement Path

Text variables of type Replacement Path:

This is possible to use text variables in order to handle dynamically the descriptions of formulas and selections in the query designer. This is useful, for instance, when you are using date restrictions in your query and you want to show the values listed by these restrictions in the query result. Below you will find some screenshots of a simple example: You have created a query with 3 selections where the characteristic 0FISCPER is restricted by 3 different months as per figure below:

Next 3 figures show the details for each selection, where the characteristic 0FISCPER has been restricted by values 010.2010 for selection 1, 011.2010 for selection 2 and 012.2010 for selection3:

SAP COMMUNITY NETWORK ? 2010 SAP AG

SDN - sdn. | BPX - bpx. | BOC - boc. | UAC - uac. 3

BW Text Variables of Type Replacement Path

Picture below shows the result when you execute the query (transaction RSRT). The information provided is not clearly understandable because this is showing the description provided for the selections in the query definition ("Selection1", "Selection2" and "Selection3"):

This is possible to make more understandable the result of this query replacing the static description of these columns by a dynamic description depending on the restriction set. In this case, using text variables you will be able to replace the description for your selection ("SelectionX" in the example) by the value that you have restricted the characteristic 0FISCPER on each of these selections. You can follow the steps below in order to use that: In the selection definition, field "Description", create a new text variable:

Pressing the "Create New" function:

SAP COMMUNITY NETWORK ? 2010 SAP AG

SDN - sdn. | BPX - bpx. | BOC - boc. | UAC - uac. 4

BW Text Variables of Type Replacement Path

In the next screen, you inform the "Processing By" as "Replacement Path" and the reference characteristic which you want to replace the information (that is 0FISCPER in our example). The Technical name is automatically suggested by system and it can be edited if necessary (VAR_20100503200426 in this example):

In the tab "Replacement Path" you need to inform with query object you want to replace the information (infoobject or variable) and also with data from that object should be used for replace. In our example it will be informed as Infoobject and Key respectively. You can find more information regarding the fields from that tab in the online documentation informed in item "Replacement Path Tab" of this document.

SAP COMMUNITY NETWORK ? 2010 SAP AG

SDN - sdn. | BPX - bpx. | BOC - boc. | UAC - uac. 5

BW Text Variables of Type Replacement Path

After save the new variable, it is going to be available and can be informed in the description field of our selections, as in figure below (if you enter that manually, this will require the tag "&" before and after the technical name of the variable):

This is possible to set the same variable for all 3 selections from our example:

SAP COMMUNITY NETWORK ? 2010 SAP AG

SDN - sdn. | BPX - bpx. | BOC - boc. | UAC - uac. 6

BW Text Variables of Type Replacement Path

Now, using the text variable type replacement path, the result is that the description for each selection is going to be replaced by the value from which 0FISCPER has been restricted in that selection, as you can see in the figure below:

So, the presentation of data using this feature is more understandable. It also can be dynamically handled in case you restrict you characteristic by a variable in the selections.

SAP COMMUNITY NETWORK ? 2010 SAP AG

SDN - sdn. | BPX - bpx. | BOC - boc. | UAC - uac. 7

BW Text Variables of Type Replacement Path

Replacement Path Tab Some more information about Replacement Path Tab can be found in the online documentation below:

Replacement Path: Replacement with a Characteristic Value

Replacement Path: Replacement from Variable

/03/6ba03cc24efd1de10000000a114084/fram 565cd22fc95f6ce10000000a1553f6/frameset.htm eset.htm

SAP COMMUNITY NETWORK ? 2010 SAP AG

SDN - sdn. | BPX - bpx. | BOC - boc. | UAC - uac. 8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download