cancel
Showing results for 
Search instead for 
Did you mean: 

APD for query

Former Member
0 Kudos

Hi

I am trying to create APD whose source is Query and target is DSO.

I created a simple query with one characteristic infoobject.I created one Direct Update DSO which has only one charcateristic(this is key too) and simple transformation...I executed APD...I am getting following errors:

Error occured when starting the parser:timeout during allocate /CPC-CALL:'ThSAPCMRCV'

Syntax error in MDX statement

Termination:Error when executing the query

Processing cancelled

I have following doubts:

1.what is the error I am doing in this dataflow creation

2.Do I need to use only Direct update DSO when using DSO as datatarget for APD?

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member182470
Active Contributor
0 Kudos

Hi,

You have to use Direct Update DSO for APD's.

Execute your Query in Analyzer to see whether it executes properly.

Why don't you add any one field in the Data Fields section of your Direct update DSO?

Regards,

Suman

Former Member
0 Kudos

Hello,

AFAIK you have to use version 3.5 of query designer for APD. Direct update DSO is mandatory.

BR

Ondrej