Automated default dimension selection within a multidimensional enterprise software system

摘要

Techniques are described for automatically selecting default dimensions of multidimensional data for publication. A computer-implemented system, for example, includes a data store having multidimensional data. The multidimensional data includes one or more data cubes having dimensions. The system further includes a publish module for accessing the data store and publishing the multidimensional data associated with the data cubes. The publish module selects a default dimension for publication for each of the data cubes based on attributes of the dimensions.

主权项

1. A computer-implemented system comprising:
a processor; a data store storing multidimensional data associated with one or more data cubes having dimensions; and a publish module executing on the processor to access the data store and publish the multidimensional data associated with the data cubes, wherein the publish module selects a default dimension for publication for each of the data cubes based on attributes of the dimensions, wherein the publish module selects the default dimension by identifying those of the dimensions that have attributes specifying formatting information for the multidimensional data and automatically selects the default dimension for the respective data cube from the identified dimensions, and wherein, for each of the data cubes, the publish module ranks the identified dimensions having formatting information in accordance with calculation priorities assigned to the dimensions, and selects the dimension having the lowest calculation priority as the default dimension for publication for the respective data cube.