Wrong Data Display in Direct DTP
we have created an data source base on function module for direct access, the data source work fine in RSA3 giving the right value, but when i check the cube by giving the Date value it give me no result as the same date is showing the result in RSA3.
i have check in the query that if i give the range for whole month it provide me with the right result but for one day or interval of 10 days or week it return no data.
but in RSA3 it is showing correct result.
kindly please let me know the reason why it is showing this behaviour.