While drilling up/down the report, the results are displayed after delay
We have a WebI Report whose hierarchy is based on the time Year -> Quarter -> Month -> Day -> Hour -> 30 mins.
While drilling up/down the report, the results are displayed after much delay and most of the time, all / some of the values are displayed as "#REFRESH" or '##########'. However, if i refresh it, all the values are displayed.
What could be the cause for this issue? and how to troubleshoot it?
Thanks In Advance!!!
This error appears in cells due to smart measures when the value returned by the smart measure is not available. This occurs when the grouping set containing the value is not available with the data provider.
Remove the error by refreshing the data.