Skip to Content
Author's profile photo Krishna Tangudu

Using Text Joins to enrich Attributes with “Texts” in SAP HANA with SAP BO Analysis Office

Hello Folks,

In this blog, i will walk you through on how to enrich the Attributes with “Texts” in SAP HANA with SAP BO Analysis Office as reporting tool.

Problem Description:

To enable the description for “Country Key” column in KNA1 table using T005T table by “Text Join” and using “Label Column” to enable “Text and Key” for the same using SAP BO Analysis office.

As shown below We can get the Country for each customer number but we cannot get the description of the country here:

Screen Shot 2013-12-26 at 11.07.39 AM.png

To enable the country description, let us create a attribute view named “AT_TEXT” as shown below:

Joining Conditions:



Language column for Text Join: SPRAS

Screen Shot 2013-12-26 at 11.08.14 AM.png

Screen Shot 2014-04-21 at 3.19.02 PM.png

Hence we finished our attribute view; let us now preview the data.


Screen Shot 2013-12-26 at 11.09.46 AM.png

Now Joining this attribute view to the fact table using Analytic view and enabling the country description columns in AN_TEXT

Screen Shot 2013-12-26 at 11.11.04 AM.png

Data Preview:

Screen Shot 2013-12-26 at 11.11.48 AM.png

Connecting to Analysis Office:

1) Selecting the data source to login to the relevant SAP HANA database as shown below:

Screen Shot 2013-12-26 at 11.12.19 AM.png

2) Choose the data source and login as shown below:

Screen Shot 2013-12-26 at 11.12.54 AM.png

Screen Shot 2013-12-26 at 11.13.24 AM.png

Select AN_TEXT

Output in AO:

Screen Shot 2013-12-26 at 8.29.27 PM.png

Note: For Calculation Views we have to use keep the texts in “Description Mapping” column as shown below:

Screen Shot 2013-12-26 at 11.14.11 AM.png

Thanks for taking time in reading this blog. Do let me know your feedback on this.


Krishna Tangudu 🙂

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jerry Zhu
      Jerry Zhu

      Hi Krishna, thanks for putting together this blog and it's helpful.  Just a quick question.  I can't find the “Description Mapping” column in the calculation view as shown in the last screenshot.  I'm using HANA 1.0 SP8 and HANA Studio 1.80.3 .  Can you please clarify how I can get to it?