BSO Is Dead. Long Live ASO (Converting BSO to ASO) • 173
e code used to complete the fourth Saturday task to reaggregate the cubes using the
default aggregation is:
execute aggregate process on database ${APP_NAME}.${DB_NAME};
5.5.2.2.2 e Sunday Morning Process Updating the dimensions cannot occur until
Sunday morning because that is when the data warehouse updates occur. ere is noth-
ing special about building the dimensions. e cube1 process would be considered a
normal dimension build process. e cube2 process might be considered abnormal by
some because it has aggregations in place already. e code used to complete the rst
Sunday morning task to build dimensions is:
import database ${APP_NAME}.${DB_NAME} dimensions
connect as ${USER}identified ...