APD Issue

[Former Member]

Hi Gurus,

I am trying to load data from a query to a Transactional ODS using APD. When I run the query through APD screen ( by using Display data) I am getting erronious data. But when i tried to run the same query using RSRT, Bex Analyzer & web analyzer i am getting the desired report.

I am not having exceptions, conditions, filters and even free charecterestics in my query. I am using 10 restricted key figures and 10 Calculated key figures.

Please help me in solving this issue.

Thanks

Suman

[Former Member]

Try to make a copy of the APD and check whether it works fine.

[Former Member]

Hi,

Did you check the data in the direct update dso? does it bring correct data of the query ?

[Former Member]

Hi Guru's,

I am facing the similar problem...Can any one provide be some idea..

Thanks and Regards,

Dev

[Former Member]

Previously in my query, I used some hidden key figures. I made all the key figures to Display then my APD got worked perfectly.

[Former Member]

Hi Suman,

this is sirisha,

i am using 2 querys with left outer join to feed the result of these querys in to a transactional ods.

in my querys i have used formula to calculated results under columns, and also used some formula variables in these calculations.

when i execute the query in bex analyzet it is giving the right results, but after inserting the query in the APD and right clicking on the query icon and display data it is showing all zeeros like this

,0000000000000000E00 0,0000000000000000E00 3,6500000000000000E02 0,0000000000000000E00

0,0000000000000000E+00

0,0000000000000000E+00

insted of displaying the values.

if you have any idea pl.let me know. it is urgent for me.

Thanksa in advance

Sirisha