SAP BW Use Pattern in Variable with Customer Exit

In my current project I created with a collegue a really cool function to analyze a string with 1333 characters. We are using a BW 7.4 SP 17 on HANA. First we have to build an Advanced DataStoreObject with a Field which has a length of 1333. For further understanding, we call the field Field_1333. As data type I used SSTRING.

Create a field with a length of 1333 in Eclipse
Create a field with a length of 1333 in Eclipse

The Advanced DataStoreObject will be included into a CompositeProvider. The Problem is the CompositeProvider cannot work with a field which has the length of 1333.

Advanced DSO cannot work with a field which is longer than 255
Advanced DSO cannot work with a field which is longer than 255

So my colleague decided to build an Open ODS View on top of the Advanced DSO. Therefor you have to activate the checkbox External SAP HANA View. My Open ODS View contains only the field "Field_1333", Number of Records and one InfoObject I need for my query. As you can see, the Open ODS View shows a length of 250 for the field "Field_1333". This is only a display problem.

Open ODS View Display Problem
Open ODS View Display Problem

When you look into the data, the Information is complete.

Datafield in ADSO
Datafield in ADSO

Now I use the Open ODS View in my CompositeProvider and here we go, the field is now available for my query.

Mapping Field with Open ODS View
Mapping Field with Open ODS View

Now we build a query on the CompositeProvider and add the necessary InfoObject into the rows and a restricted key figure into the columns with a variable for the field "Field_1333". This variable is used to fill the customer exit variable of the field "Field_1333".

Query Variable Customer Exit
Query Variable Customer Exit

Now you have the opportunity to fill a lot of values separated by comma. The customer exit sorts all values by ascending and fill the variable with '*' & value & '*'

ls_e_range-low = ls_e_range-low && '*' && ls_code-ccode && '*'.

Now we can combine different combinations and get a result. This result is used as a PreQuery in my main development. So I am able to build a complex analytics application and give the user the opportunity to analyze his data deeply.

Replacement Variable with PreQuery
Replacement Variable with PreQuery
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
29,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
39,99 €

Write a comment

Comments: 0