I would like to clear zeros in the ASO cube. (Is there anyway to know how many zeros there are in the first place?). I've found knowledge articles (https://support.oracle.com/cloud/faces/DocumentDisplay?_afrLoop=302242818107242&_afrWindowMode=0&id=2370683.1&_adf.ctrl-state=1bzfgkso0h_274#FIX) recommending merge incremental slides and clearing zeros using database properties in the calculation article. What is the difference between merging all into main slice to merge all data slices into main data slice and merge all into a single incremental slice to consolidate all data slices? How do you make this decision? What are the pros/cons?
Thanks!