Enhanced user interface and data handling in business intelligence software

A system comprising:

• a processing device;
• and
• a memory device communicatively coupled to the processing device, the processing device being configured to execute instructions stored in the memory device to cause the processing device to:
• provide a databook interface to a user,
• identify a security control policy associated with the user,
• query an operational data set based on a databook definition parameter and return data results from the operational data set in response to the query, the data results from the operational data set including data from separate source systems using different data formats,
• determine, prior to a display of the returned data results, that the security control policy prohibits the user from accessing a first subset of the returned data results and that the security control policy allows the user to access a second subset of the returned data results, the second subset of returned data results including data from the separate source systems, and
• update the databook interface to display results of the query, wherein updating the databook interface comprises:
• hiding the first subset of the returned data results so that the first subset of the returned data results are prevented from being displayed via the databook interface, and
• adding interface objects to the databook interface that provide a common format for displaying the second subset of the returned data results, and
• providing the updated databook interface to the user,
• determine that rows of data will span multiple pages and dividing the rows for display on the multiple pages,
• render a row browsing interface in response to a user command, wherein the row browsing interface comprises:
• a visually-compressed view of the fields of at least one column for at least some of the rows that would otherwise be displayed on the multiple pages, and a magnified view area that is configured to respond to a selection by causing an increase in a size of a first portion of the visually-compressed view while the size of a second portion of the visually-compressed view remains unchanged and still visible, and
• update, in response to a user input provided after a selection of a portion of the visually-compressed view, a data display area of the databook interface to select the page containing the rows in the selected magnified view area.