Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Problem with the Report Connector

Hi,

I have a problem when I try to select a report and load data. Has some one some kind of idea where this problem lies (see sreenshot):

10 Replies

Problem with the Report Connector

Hello,

Has the user connected permissions to execute that report?

Regards.

Not applicable

Problem with the Report Connector

I think so I get to see all the of the reports in SAP. But can you tell me where I can check if I got the right permissions?

Problem with the Report Connector

Hello James,

You should ask to the SAP people that installed the transports. Anyway, try in transaction

/n/QTQVC/SQL


whether or not you can get some data from the system.

Hope that helps.

Not applicable

Problem with the Report Connector

I tried this transaction and I can get data from the system, this means that this cannot be the problem must be something else

Problem with the Report Connector

Hello,

That means you can get info from raw SQL statements, but the report or its variant may not be accessible to your user. Did you create that report or variant? Are they accessible to your user?

Regards.

Not applicable

Problem with the Report Connector

Hi,

I created the report my self and the SAP system tells that I am autorized to acces the report (see sreenshot).

But maybe the problem lies in the fact that the user that I use to connect to the SAP system does not have the autorisation to open the SAP system itsself because the user is a System user and not a Dialog user. when I changed this to Dialog user I can log in to the Sap system but then I was not abble to make a transaction (sq03). Maybe this is the problem why I am not able to load the report.

When using a other user in the sap system (administrator) then I can view the report and see all the values.

suniljain
Honored Contributor

Problem with the Report Connector

Dear Jams,

you can extract SAP report in qlikview which generate spool in memory otherwise you cannot .

can you post details like which report are try to extract ?.

Not applicable

Problem with the Report Connector

The rapport that I want to extract is a birthday list see the screenshots below I hope you can help me:

suniljain
Honored Contributor

Problem with the Report Connector

Dear James,

Can you give me details whether that report generate spool in SAP R/3 System.