Abstract: According to an aspect of some embodiments of the present invention there is provided a computer implemented method for detecting at least one anomaly in a dataset, comprising: managing a dataset including a plurality of data entities each including at least one value; receiving a semantic model that defines associations between two or more data entities; forming a plurality of multi dimensional data instances, each multi dimensional data instance formed from at least one of a permutation and a combination of a set of data entities from the plurality of data entities according to the semantic model; analyzing the multi dimensional data instances to detect at least one anomalous value, the anomalous value representing a statistically significant deviation according to a deviation requirement, of one or more values from a set of values of the multi dimensional data instances; and providing the detected at least one anomalous value.

Abstract: A method of enabling collaboration between users of a collaborative Business Intelligence (BI) system comprising pages based on said BI system data, comprising: displaying a page comprising a view of at least one online analytical processing (OLAP) cube to one of a plurality of users of a BI system; deducing from semantics of said at least one OLAP cube a relevancy of each of at least some of said plurality of users for a collaboration session with said user; selecting the most relevant users from said plurality of users for said displayed page according to said deduced relevancy; and initiating a collaboration session with at least one of said most relevant users.

Abstract: 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.

Abstract: 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.

Abstract: 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.

Abstract: 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,

Abstract: 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.

Abstract: 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

Abstract: 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.

Abstract: 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.

Abstract: 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.