An example method of displaying a data visualization includes displaying a graphical user interface that includes three distinct regions, and receiving user actions to associate two different fields with two different shelves. The method also includes generating, in accordance with the received user actions, data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from a multidimensional database, where (i) each data mark has an x-position defined according to data for a first field in the respective tuple and (ii) each data mark has a y-position defined according to data for a second field in the respective tuple. The method also includes displaying a data visualization that includes the generated data marks.

A method of displaying data visualizations includes retrieving a dataset from a multidimensional database, where the dataset includes a plurality of fields, including first and second fields, and the first field is a data hierarchy that includes multiple subfields. The method further includes displaying a GUI with a first region displaying the plurality of fields (with the first field in a collapsed state), a second region with a plurality of shelves, and a third region. In response to receiving a user action to display the first field in an expanded state, the method displays the first field and the multiple subfields in a hierarchical structure. The method receives additional user actions to: (i) associate a first subfield of the plurality with a first shelf, and (ii) associate the second field with a second shelf, and then displays, in accordance with the user actions, a data visualization in the third region.

A method is performed at a computer. The computer retrieves a dataset having a plurality of fields, including a first field and a second field. The computer displays a graphical user interface, including a first region displaying the plurality of fields from the dataset, a second region having a plurality of shelves determined according to a user-selected data visualization type, and a third region for displaying one or more data visualizations. The computer receives user actions to drop the first field on a first shelf and to drop the second field on a second shelf. The first and second shelves define positional attributes of data marks. The computer displays a data visualization in the third region. Each data mark has a position in the data visualization determined according to the first shelf, a data value for the first field, the second shelf, and a data value for the second field.

An exemplary method of displaying a data visualization includes displaying a graphical user interface that includes three distinct regions, and receiving user actions to associate three different fields with three different shelves, including a shelf that defines colors of data marks. The method also includes generating, in accordance with the received user actions, data marks to be displayed in a data visualization, each data mark corresponding to a respective retrieved tuple of data from a multidimensional database, where (i) each data mark has an x-position defined according to data for a first field in the respective tuple, (ii) each data mark has a y-position defined according to data for a second field in the respective tuple, and (iii) each data mark has a color assigned according to data for a third field in the respective tuple. The method also includes displaying a data visualization that includes the generated data marks.

An exemplary method of displaying a data visualization includes retrieving a dataset that includes a plurality of fields and displaying a graphical user interface with a plurality of shelves. The method further includes receiving user actions to: (i) associate a first field with a first shelf, and (ii) associate a second field with a second shelf; displaying, in accordance with the received user actions, a data visualization, where each data mark has a first size defined according to a default position of a displayed slidable affordance; and receiving an additional user action that moves the slidable affordance from the default position to a user-defined position. In response to receiving the additional user action, the method further includes updating the data visualization, where each data mark included in the updated data visualization has a second size, different from the first size, defined according to the user-defined position of the slidable affordance.

An exemplary method of generating a chart matrix comprises outputting a user interface (UI) comprising a row header UI section, a column header UI section, and a grid header UI section in a headers UI section, outputting a chart matrix defined by associating a first data dimension corresponding to a data dimension placed in a first position in the row header with a row edge of the chart matrix, and a second data dimension corresponding to a data dimension placed in a first position in the column header with a column edge of the chart matrix, outputting two or more charts nested within each of two or more cells of the chart matrix, providing a user option to perform a drill operation on a selected member displayed in the chart matrix, and outputting, in response to the user input to perform the drill operation, a modified chart matrix.

An exemplary method of generating a plurality of data visualizations comprises displaying a graphical user interface that includes a schema information region and a data visualization region. The method further includes receiving user actions to associate first, second, and third fields included in the schema information region with a plurality of shelves of the data visualization region. The method further includes generating a plurality of data visualizations in the data visualization region in accordance with the received user actions, each data visualization includes a plurality of data marks corresponding to a respective retrieved tuple of data having the first, second, and third fields. Moreover, each of the data marks has an x-position and y-position defined according to data for the first and second fields, respectively. In addition, each of the data visualizations corresponds to a respective unique value of the third field, and is displayed in a respective pane.

Access control methods provide multilevel and mandatory access control for a database management system. The access control techniques provide access control at the row level in a relational database table. The database table contains a security label column within which is recorded a security label that is defined within a hierarchical security scheme. A user's security label is encoded with security information concerning the user. When a user requests access to a row, a security mechanism compares the user's security information with the security information in the row. If the user's security dominates the row's security, the user is given access to the row.

An exemplary method of generating a chart matrix comprises outputting a user interface (UI) comprising a row header UI section, a column header UI section, and a grid header UI section in a headers UI section, outputting a chart matrix defined by associating a first data dimension corresponding to a data dimension placed in a first position in the row header with a row edge of the chart matrix, and a second data dimension corresponding to a data dimension placed in a first position in the column header with a column edge of the chart matrix, outputting two or more charts nested within each of two or more cells of the chart matrix, providing a user option to perform a drill operation on a selected member displayed in the chart matrix, and outputting, in response to the user input to perform the drill operation, a modified chart matrix.

An exemplary method of generating a plurality of data visualizations comprises displaying a graphical user interface that includes a schema information region and a data visualization region. The method further includes receiving user actions to associate first, second, and third fields included in the schema information region with a plurality of shelves of the data visualization region. The method further includes generating a plurality of data visualizations in the data visualization region in accordance with the received user actions, each data visualization includes a plurality of data marks corresponding to a respective retrieved tuple of data having the first, second, and third fields. Moreover, each of the data marks has an x-position and y-position defined according to data for the first and second fields, respectively. In addition, each of the data visualizations corresponds to a respective unique value of the third field, and is displayed in a respective pane.