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.