I like to extract data from MSS system (our BW is 3.1). Thus I followed all advices (OSS, SDN network) like upper case, user-own table ect. However I am not able to get a proper connection. Thus I am wondering if someone has an idea for the following:
In the 'DB connect: Table and view overview', I can only see the table of the MSS database owner. Unfortunately the view built specifically by the extraction-user doesnt appear in the 'DB connect Table and view overview'.
Thus has someone an idea, which authorisation is required for the extraction user in MSS at least to get this view in 'DB connect Table and view overview'.
Anyhow it would be excellent if someone could provide an extract of the given authorisation to his user, which is able to extract successfully data.
PS: Through EXCEL /ODBC using same user and view the data extraction is successful.