SAP OLAP Connector from BW Key & Text

[nicholas5141]

Hi All,

Currently I am using SAP Connector extract data from BW but I facing some issues.

I select 1 field but output come with Key and text as per screenshot.

1. How do I avoid the output without key & text. apart from that how to avoid key as the screenshot ?

2. How do I avoid the key come with [0DISTR_CHAN].[DS] ?

Screenshot also attached how I extract data via SAP connector.

Please assists thank you.

[Anil_Babu_Samineni]

Seems you are using, Direct Query. Can you tell us the issue you are facing

[nicholas5141]

Hi Anil,

Issue stated above, current issue that I face that output selected 1 field come out with 1 Key and text as per screenshot and the key field come out with some prefix example [0DISTR_CHAN].[DS] as per screenshot attached.

1. How do I avoid the output without key & text. apart from that how to avoid key as the screenshot ?

2. How do I avoid the key come with [0DISTR_CHAN].[DS] ?

Sorry what do you mean Direct Query?

[Anil_Babu_Samineni]

Still Confusing, Seems you get good result set in Qlikview.

Here, can you post data and explain required result

[nicholas5141]

Example I select 0DISTR_CHAN expected output should be DS

SELECT 0DISTR_CHAN

Expected output DS,DA,SS

Not

Key

[0DISTR_CHAN].[DS]

[0DISTR_CHAN].[DA]

[0DISTR_CHAN].[SS]

Text

Direct Sales

Gas

Strategic Sourcing

Because I am selecting 1 Field.

Thanks