Oracle Analytics Cloud and Server

Products Banner

Feature Friday: Using the Preserve Grain Setting in Oracle Analytics Datasets


This important Oracle Analytics Cloud feature enables the user to keep a table’s level of detail while preventing the duplication of a measure across a one-to-many or many-to-many relationship. When used with the explain or auto-insights augmented analytics features in Oracle Analytics Cloud, enabling preserve the grain renders the best insights from your multi-table datasets. With Preserve the Grain selected, Oracle Analytics Cloud will automatically consider the entire data model to provide insights about your data. The Preserve the Grain setting enhances the augmented analytics features and provides more business value by delivering auto-insights from your entire dataset.

Watch the attached video to learn more about Using the Preserve Grain Setting in Oracle Analytics Datasets.