Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
tmumaw
Valued Contributor

SAP Connector

Hey group quick easy question for you. I am using the SAPCONNECTOR to generate my SQL code here is a sample of my select stmt does anyone see anything wrong with it? Is the table name too long? That is what I am starting to think.





SQL

Select MANDT TEXT COSTCENTER MODIFYDATE CREATEDATE EMPLOYEEID

CREATEID

MODIFYID COMMENTDATE from

ZPRDCOMMENTS

Thanks





1 Solution

Accepted Solutions
tmumaw
Valued Contributor

SAP Connector

Thanks. I am using the SAP Connector to generate the SQL code. What I did find out though CREATID is a reserved word in Qlikview. I changed the name to Z_CREATID and it works fine. Thanks for your help.

View solution in original post

6 Replies
Not applicable

SAP Connector

Do you have commas between the fields, or do they just not show in your post?

sicilianif
Contributor

SAP Connector

Are you getting an error when try to load?

Also, have you tried using the script builder to build your queries? It is a wonderful tool.

Frank

tmumaw
Valued Contributor

SAP Connector

Thanks. I am using the SAP Connector to generate the SQL code. What I did find out though CREATID is a reserved word in Qlikview. I changed the name to Z_CREATID and it works fine. Thanks for your help.

View solution in original post

smadan
New Contributor

SAP Connector

Hi all,

Sap latest connector not allowing me to picked the cubes records after 2,39,400 3 times i have tested this , can i picked the sap cubes data through any other way out

can anyone help me it very urgent. please send me the syntax also my cube is like that.

[$0FIAR_C03]:
Load *;
Select PseudoMDX (
Dimensions (

[0ACCT_TYPE] (),
[0AC_DOC_TYP] (),
[0DOC_DATE] (),
[0NETDUEDATE] (),
[0PMNTTRMS] (),
[0POST_KEY] (),
[0PSTNG_DATE] (),

Measures (

[0MEASURES0000000000000000].[0DEB9CRE9LC00000000000000], //Amount in Local Currency with +/- Signs
[0MEASURES0000000000000000].[0DSC9AMT9DC00000000000000], //Cash discount amount in document currency
[0MEASURES0000000000000000].[0DSC9AMT9LC00000000000000], //Cash discount amount in local currency
[0MEASURES0000000000000000].[0CREDIT9DC000000000000000], //Credit amount in foreign currency
[0MEASURES0000000000000000].[0CREDIT9LC000000000000000], //Credit amount in local currency
[0MEASURES0000000000000000].[0DEBIT9DC0000000000000000], //Debit amount in foreign currency
[0MEASURES0000000000000000].[0DEBIT9LC0000000000000000], //Debit amount in local currency
[0MEASURES0000000000000000].[0NETTAKEN0000000000000000]), //Net period used
From ($0FIAR_C03));

Thanks

sicilianif
Contributor

SAP Connector

Smadan,

In our company we chose to go with the underlying DSOs and tables instead of using the cubes. Not only was it faster to process for us, but it gave us more control.

Frank

smadan
New Contributor

SAP Connector

Thanks,

How we linked the Dimesion table with the measures tables.through DSO connection only show fact table not the other tables.