SAP Connector

[tmumaw]

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

[#2]

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

[sicilianif]

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 · Accepted solution]

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.

[Anonymous]

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]

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

[Anonymous]

Thanks,

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