Forum Discussion

Nadav's avatar
Nadav
Regular Visitor
10 years ago

SAP BW connectivity issue

Hi,

This is the first time i use the SAP BW CONNECTOR.

I can not find a way to choose whether to show the key or the text of my SAP BW InfoObject.

The result is that sometimes I see a numeric value (code) in the field values and sometimes text (in the same column).

 

Thanks.

5 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Nadav

     

    Since I don’t have a SAP server to be connected now. Could you please provide a screenshot to show the issue you mentioned above?

     

    Best Regards,

    Herbert

    • Maring's avatar
      Maring
      New Member
      10 years ago

      Hi,

      I have a similar problem,

      In SAPBW there's an option to view a field as text, as key or as both.

      However, in PBI it only views the field as text, and I could not find a way to view the field as text or both.

      It's a big problem cause I can't connect tables with text... it has duplicates. 

      Attached is a depictin of the problem

      Thanks

      Marina

       

  • JerryS's avatar
    JerryS
    Frequent Visitor
    9 years ago

    I am also having this problem with data being extracted from SAP BW as text only. This is a signifcant issue when dealing with Part Numbers (SAP = Material) where the key is an alphanumeric and the text is the part description. The Part description is of limited value as we have many parts with the same description but different 'Part Number'. Is there any solution now as time has moved on since this point was raised?