SAP Knowledge Base Article - Public

2892340 - Hierarchy text description cut when consuming BW data

Symptom

You are filtering a Hierarchy and description texts are not complete

 The description length is maximum 20 Characters

length20shortdescription01.png

Environment

Analysis For Office

Reproducing the Issue

Filter an Infoobject that has enabled a hierarchy and "short text" is set on InfoObject

Resolution

Analysis for Office is using the Short Description from hierarchy because the "Short Text" is set on the InfoObject settings.

If you have enabled more than one Text size, Analysis for Office will choose the Text-Size on the following order:

  1. Short Text
  2. Medium Text
  3. Long Text 
  4. Extra Long Text

Solution 1:

 Uncheck the Short-Text on Infoobject settings and check the expected Text-size (Medium or Long Text)
   

  textsizersd.png

Now you will see the Medium Text Description

descriptionmedium.png

 

 Solution 2:

 Once you refreshed the DataSource, you can change the text size at runtime on the Workbook

  1. Click on the Infoobject you want to change the text size 
  2. Go to Members on Analysis tab
  3. Change the text size

runtime.png

Keywords

20, characters, cut, split, length, text, title, hierarchy, parent, node, root, query, designer, hana, modelling, modeling, tools. , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office 2.7 ; SAP Analysis for Microsoft Office 2.8