Previously, many aggregation levels of a date column were required in the data to be loaded for SAP Data Warehouse Cloud, e.g. for a separate “Quarter” or “Year” column when multiple levels of time aggregation were required in the story. Some of us are used to SAP BW, where the single date field can be used not only for the corresponding date field in the target object but also for other date fields such as quarter and year. This automation is now also possible in the SAP Data Warehouse Cloud. With only one date field, you can also filter to other date levels in the story when making use of the new time dimension. It automatically redirects the “day” information to the year, quarter and month, and also offers predefined levels of time hierarchies that can be selected in story mode.