Panorama Software Inc. Patent applications |
Patent application number | Title | Published |
20140250053 | MULTIDIMENSIONAL DATASET QUERY PROCESSING - A method of processing a query. The method comprises providing at least one multidimensional dataset having at least three dimensions formed according to a plurality of data tables associating between a plurality of persons and a plurality of roles and comprising a plurality of cells, receiving a query defining at least one factual value coordinated by at least one of the plurality of cells, the at least one factual value representing a measure defined in at least one of the plurality of data tables, deriving at least one person from the plurality of persons, the at least one person being associated with the with multidimensional dataset with the at least one cell, and outputting an indication of the at least one person in response to the query. | 09-04-2014 |
20130018840 | Enhanced usage of business intelligence systemsAANM Averbuch; JakobAACI NetanyaAACO ILAAGP Averbuch; Jakob Netanya IL - A collaborative Business Intelligence (BI) system comprising pages based on said BI system data, comprising a collaboration platform having means for selecting most relevant users and most relevant pages and means for enabling collaboration between users, | 01-17-2013 |
20120131036 | One-click exceptions - A method and system for automatically defining and applying an exception rule to reports created from at least one multi-dimensional database, comprising: defining global exception parameters, displaying at least one report created from a multi-dimensional database, receiving a user command to detect exceptional cells in the displayed report, locating the most relevant time dimension in the semantics of the source database of the report, detecting exceptional cells in the displayed report according to the exception parameters and the most relevant time dimension, calculating an exception quality for each detected exceptional cell, and indicating on the displayed report the exceptional cells, the indication comprising differentiating between different exception qualities, wherein the exception rule is independent of data granularity in the time dimension in the report. | 05-24-2012 |
20120095793 | Business intelligence exception analysis by cause and effect - A computerized Cause and Effect exception analysis mechanism for multi-dimensional data, comprising: displaying a business report comprising data cells, each data cell pertaining to coordinates of one row and one column representing dimensions of the report, marking one or more of the displayed cells as exceptions according to an exception rule, receiving a selection of one or more of the marked cells, defining the coordinates of the selected cells as fixed coordinates, displaying a list of dimensions, receiving a selection of one or more dimensions from the displayed list, receiving a number N of reports to be displayed, compiling a list of combinations of the selected dimensions, slicing each combination in the list by the fixed coordinates, applying the exception rule to the sliced combinations, prioritizing the sliced combinations, selecting the N highest priority combinations, creating reports for the N selected combinations, and displaying the N created reports, each displayed report comprising at least one cell marked as exception. | 04-19-2012 |
20090210430 | Creating pivot tables from tabular data - System and method of simultaneously creating and managing a plurality of OLAP cubes in real time, each from a different tabular data source, comprising, for each cube, defining the table columns as either dimensions or measures of the cube using at least one of predefined semantics and data formats, generating the cube using said defined dimensions and measures, updating the cube when the respective data source is modified and deleting the cube according to predefined criteria. | 08-20-2009 |
20090043788 | Proactive business intelligence - A method of retrieving data items residing in a multidimensional database, comprising the steps of: storing previously created views from said multidimensional database in a storage connected with said database; searching said stored views for all views comprising a queried metadata search string; displaying said search results; selecting a view from said displayed views; selecting one or more items from said selected view; and transferring said selected one or more item to a receiving module, whereby said transferred one or more items retain their reference to said selected view for updating purposes. | 02-12-2009 |