BIA vs Compression
we have different cubes that are automatically compressed after loading. During this compression we use the flag for elimination of zero rows, thus avoiding meaningless records.
Now we have added these cubes in the BIA, but there we can't compress the requests at all ( = I didn't find an option till now to do it). Ok, performance wise this is not needed, BIA takes care of performance, but how can I eliminate the zero rows from the BIA ?
The only way I see this far is to do a compress of the cube and consequently reload the cube into the BIA. Is there another solution ?
thanks in advance