Hi experts,
I made some corrections in my BW model to optimize performance of cube Z. Step by step:
1. Create copy of cube Z
2. Compress cube Z (to accelerate load from cube to its copy)
3. Copy all data from cube Z to its copy
4. Compress copy of cube Z (to accelerate load from copy to cube)
5. Delete all data from cube Z (with option "drop all dimension tables")
6. Change structure of cube Z (add new dimensions, one of new dimensions is Line Item Dimension)
7. Copy all data from copy to cube Z
8. Compress cube Z
after that, I faced with 2 issues:
1. DB statistics is in red status and I am not able to make it green or yellow. I tried to create statistics with the help of "Create Statistics (Btch)" button on Performance tab and with the help of "DB Statistics" Process in RSPC. But both approaches failed.
2. Report SAP_INFOCUBE_DESIGNS shows partly wrong (inactual) information about infocube structure (new dimension tables are not shown, dimension tables size is smaller than it really is).
I have asked DB admins to create statistics on infocube tables on DB level, maybe this can help. Now I'm waiting for result.
But I think there must be another way to solve these 2 problems. And I really want to know the reasons why such problems take place.
Have you any ideas?
Best regards,
Sergey Musatov.