I am facing issue with aggregates, that when using reports with Aggregates (front end tools like BEx, Webi, RSRT) some data is missing in reports.
But if I check Infoproviders, data is available in BI. Also when I execute the report in RSRT (using option Do not use Aggregates) reports displays correct data. Also reports work fine when I deactivate aggregate.
As of now only workaround I know is to deactivate aggregate. But I would like to know the root cause of the issue and permanent fix.
Any pointers from your end will be of great help.
Thanks in advance!