Specify Which Table Determines Grain

By default the table with the lowest grain determines a dataset's grain, but you can change which dataset table determines grain.

Any table in the dataset can contain a measure. However, this can cause the measure on one side of a one-to-many or many-to-many relationship to be duplicated and produce unexpected query result. In cases like this you can set the table on one side of the cardinality to Preserve Grain to keep its level of detail.

For an example of why you'd change a table's grain, see What is Preserve Grain?

When you set a table to Preserve Grain, a green bar is displayed at the top of table in the Join Diagram. This green bar indicates which table's grain the dataset uses.

On the Home page, click Navigator and then click Data.
Click the Datasets tab.
Locate the dataset that you want to open, click Actions, and then click Open.
In the Join Diagram locate the table, right-click, and select Preserve Grain.

Description of the illustration data_set_editor_preserve_grain.jpg

In the join diagram, the table displays a Preserve Grain icon .
Click Save Dataset.