Patent ID: 8856649

Claim:
A non-transitory computer readable medium comprising computer readable instructions, which, when executed by a computer, causes the computer to perform a method, comprising: receiving a first user action identifying at least one cell of a crosstab, wherein the crosstab comprises hierarchical multidimensional data; determining at least one other cell from the crosstab, wherein the at least one other cell is within a set of cells compatible by aggregation level and measure with the at least one user identified cell; modifying a user interface to display hints on the set of cells compatible by aggregation level and measure; receiving a second user action selecting a portion of the crosstab, wherein the selected portion includes at least one cell of the set of cells compatible by aggregation level and measure associated with the hints and cells outside the set of cells compatible by aggregation level and measure associated with the hints; in response to receiving the second user action selecting the portion of the crosstab, removing cells from the selected portion that are outside the set of cells compatible by aggregation level and measure associated with the hints, wherein the cells removed from the selected portion are associated with a different measure than the measure used for the cells compatible by aggregation level and measure; and displaying a list of commands on the user interface for execution with respect to the cells of the changed selected portion associated with the hints.