topic Re: SAP OLAP Connector from BW Key & Text in QlikView

SAP OLAP Connector from BW Key & Text

nicholas5141 — Fri, 21 Apr 2017 07:32:31 GMT

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.

Re: SAP OLAP Connector from BW Key & Text

Anil_Babu_Samineni — Fri, 21 Apr 2017 09:21:32 GMT

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

Re: SAP OLAP Connector from BW Key & Text

nicholas5141 — Fri, 21 Apr 2017 09:45:14 GMT

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?

Re: SAP OLAP Connector from BW Key & Text

Anil_Babu_Samineni — Fri, 21 Apr 2017 09:51:46 GMT

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

Here, can you post data and explain required result

Re: SAP OLAP Connector from BW Key & Text

nicholas5141 — Fri, 21 Apr 2017 10:57:47 GMT

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