We have requirement to create BWA index for APO / Planning cubes. We have large amount of data in the planning cubes and the query execution time (DB % - 79 % ) is much larger.
I saw one of the posting here - You just need to check the option to "auto-aggregate" the request when it is closed.
We need to understand where we have to make this settings. Can anyone please provide the details in steps. Advance Thanks.