In the soft drink example, the aggregate table contains data for Coke and Pepsi sales at the city level.

Its data fragmentation expression should be similar to the following:

SoftDrinks.Products.Product IN ('Coke', 'Pepsi')

This expression tells the Oracle Analytics query engine that the source table has data at the city and product level for two of the products.

Because this source is a fragment of the data at this level, you must select the Combine with other fragmented sources field to indicate that the source combines with other sources at the same level.