topic SAP Connector in QlikView

SAP Connector

tmumaw — Mon, 23 Nov 2009 21:44:22 GMT

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

SAP Connector

Mon, 23 Nov 2009 23:10:57 GMT

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

SAP Connector

sicilianif — Wed, 25 Nov 2009 23:16:25 GMT

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

SAP Connector

tmumaw — Mon, 30 Nov 2009 22:47:18 GMT

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.

SAP Connector

Anonymous — Fri, 12 Mar 2010 07:25:55 GMT

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

SAP Connector

sicilianif — Fri, 12 Mar 2010 15:02:32 GMT

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

SAP Connector

Anonymous — Wed, 17 Mar 2010 05:11:37 GMT

Thanks,

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