Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unable to Connect to SAP data

I am trying to connect to my sap system but this doesn't work I get a lot of errors. when making a connection the connection says dat the test connection works, so that cannot be the problem. But I still get a lot of errors, can somebody please help.

23 Replies
suniljain
Master
Master

pls try following Tcode in SAP R/3

/n/qtqvcsql

pls SAP R/3 side whether role is assigned properly o not.

if you are able to extract data from above TCode then it is always extractable from Qlikview side.

tmumaw
Specialist II
Specialist II

Did you apply the tranports to SAP ? Is the user defined as a background (batch) user?

suniljain
Master
Master

Dear Thom,

Not getting your reply.

Not applicable
Author

I have the following settings in my sap system, is this correct or not>?

suniljain
Master
Master

Dear james,

pls execute following TCode in SAP R/3.

/n/QTQVC/SQL

write select * from t000

click on Open stream and then Fetch stream.

pls let me know what is the outcome .

Not applicable
Author

Hi Sunil.

I tried the Tcode but it does not work there is no outcome when I execute the Tcode in SAP R/3, what can be the problem?

suniljain
Master
Master

If you do not get any outcome after executing /n/qtqvc/sql TCode means that

file is not properly pransported in SAP R/3 system.

Not applicable
Author

I have a problem involving SAP BW (OLAP Connector):

One of the cubes that is shown in Qlikview is empty, but in Business Objects this cube is filled with data, does any one know how this can ben resolved.

And when I select a cube and I click on reload I get the following error (view print screen) But under the error messages the script says that the data is fetched, can any one help me with these two problems.

suniljain
Master
Master

I think data is not fetched.pl try to extract fact and dimention table seperately. and join fact table to all dimention table in qlikview . it is faster and best way to eatract cube.

still if you have query ,

reply me.

Not applicable
Author

Sunil,

where can I extract a fact and dimension table seperately. when I click on cubus in the scriptbuilder I get the Infoprovider en Qeury.

I select a qeury and I click ok, thats is what I do. So I do not see the difference between a fact and dimension.