Hi BW Gurus,
For the past few days we have been experiencing slower then average response times for this particular query. This query is written on infoprovider of type ODS, at this point. In the query properties, the Read mode is set to "H: Query to read when you navigate or expand hierarchies".
Can someone suggest ways to improve performance of the Query when it is created on ods.
Thank you in advance, your responses will be well rewarded.