How to check in manual triggered compression job – Zero elimination used or not ?
In this document i would like to share the experience about some facts about zero elimination and how to check when the manual compression job has been triggered by some one and you want to check that the zero elimination has been used or not for the manual compression job.
Most of the case this zero elimination option will obviously make some difference in viewing data in cube level/report.
In many times this zero elimination option will be switched on in process chain variant and there will be no issues. But in some cases when you have planned to do some reloads of data manually to cube and after it followed by rolled up and compression.
When you run compression with zero elimination, the process first excluded any individual F fact table rows with all KFs = 0, then if any of the summarized F fact table rows had all KF = 0, that row was excluded.
In one of our case, some one forgot to check the zero elimination option and compression job was carried out. Now how do you find out the manual job has carried out the zero elimination or not.
When you go to collapse you will be seeing display external batch jobs and logs. So when you click on display external batch job you can see all compression job starting with BI_COMP* ( you will be in SM37 screen) . But here you couldn’t able to find out whether zero elimination has been used or not.
Click on logs >
Execute: Below screen shot is the compression job which has been carried out on 23rd without the zero elimination option checked.
Below is the screen shot of compress job which has been executed with the zero elimination option checked