Patent ID: 7480663

Claim:
A computer-implemented method of optimization of a multidimensional model in a model based performance advisor, the multidimensional model comprising a cube comprising a plurality of groups, each group of said plurality of groups having one or more levels, a first group of said plurality of groups having a first plurality of levels, and a second group of said plurality of groups having a second plurality of levels, comprising: receiving a focus region request specifying a focus region, said focus region being specified by a user, said focus region being associated with said multidimensional model, said focus region request specifying a first query type associated with said focus region, said focus region request specifying said cube, said focus region being associated with said cube, said focus region request specifying a first particular level for said first group of said plurality of groups of said focus region, said focus region request specifying an any level for said second group of said plurality of groups of said focus region; storing said focus region associated with said first query type and said cube; receiving, from a user, a recommendation request specifying said cube, wherein said recommendation request is different from said focus region request; in response to said recommendation request: retrieving said focus region and said first query type based on said cube specified in said recommendation request; evaluating, by said model based performance advisor, a plurality of candidate slices based on said focus region and said first query type that are retrieved based on said cube specified in said recommendation request, wherein said each candidate slice of said plurality of candidate slices comprises said first particular level of said first group and one level of said second plurality of levels of said second group, wherein said each candidate slice comprises one level of said each group of said plurality of groups, wherein said each candidate slice comprises a different combination of levels from other candidate slices of said plurality of candidate slices; selecting a recommended slice from said plurality of candidate slices based on said evaluating, wherein said recommended slice comprises said first particular level of said first group of said focus region; and generating a query to create said recommended slice.