cancel
Showing results for 
Search instead for 
Did you mean: 

Queries for SAP BW and SAP BW MDX data sources.

Former Member
0 Kudos

Hi All,

When selecting query using "Set Datasource Location" option, datas fetched by selecting the query from SAP BW Query datasource are not the same when i select the same query from SAP BW MDX Query folder.

Can anyone help me in solving this issue?Is there any difference in queries for the datasources.Or Can i use the same query for those two data sources?

Accepted Solutions (1)

Accepted Solutions (1)

IngoH
Active Contributor
0 Kudos

Hi,

the BW Query Driver is an old version (several years old) of the BW connectivity and the BW MDX Driver is the newer enhanced version which is recommended to be used

Ingo

Answers (1)

Answers (1)

adil_madid
Active Participant
0 Kudos

Hi,

You can use either of the drivers however BOSAP recommend to use BW MDX driver as the BW query driver does not support multiple structures and does not support display attributes.

BW query driver shows the hierarchies as sepates fields and parent-child relationship whereas MDX driver will offer parent child relationship only.

Thanks,

Adil