Zeros– Zeros are data values, so if they are loaded to the cube, they will potentially aggregate and make the cube unnecessarily larger. Therefore, it is generally recommended to not load them or, if they exist, to remove them periodically using a business rule to change ...
Now let us see the first code to get some cube stats. First, we get all the cubes from all the apps and for each cube we get its properties (which is an array in a Key and a Value format). This information is added to the prepare Statement and executed (inserted) into the DB. ...