Skip to Content

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:


KNA1.MANDT = T005T.MANDT

KNA1.LAND1 = T005T.LAND1


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.


Output:


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.


Your’s

Krishna Tangudu 🙂

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. 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?

    (0) 

Leave a Reply