Abstract: Tools for defining and using custom analysis modules are presented. A generic graphical user interface (GUI) custom analysis tool is presented to a user. The generic GUI custom analysis tool is adapted to receive selections and inputs from the user that define many-to-many relationships in a data store and that include user-defined measures. The inputs are used to generate an instance of a custom analysis module that is capable of being processed against the data store. The instance of the custom analysis module may be stored, recalled, executed, and/or modified from the generic GUI custom analysis tool.

Abstract: Techniques for Product Affinity Analysis are presented. A user interacts with a tool to supply user-defined criteria. The criteria are used to automatically generate code that processes against a data store to collect results that conform to conditions defined by the criteria. The results are used to automatically populate a Product Affinity Analysis chart or grid for the user to view and in some cases dynamically interact with.

Abstract: Techniques for applying segment conditions to measure results are presented. Row and column segment data is acquired from a database according to row and column definitions. A measure calculation is applied against the intersecting row and column segment data. Next, one or more combinations or conditions derived from the row and column definitions are used as a filter to produce filtered results.

Abstract: Techniques for searching and presenting search results to a user are provided. A search is decomposed into sub search combinations. Logical operator ordering is maintained within each sub search combination and each sub search combination is processed to acquire a waterfall count for the resulting answer set associated with processing that sub search combination. The sub search combinations and their waterfall counts are then presented to the user for visual inspection and analysis.

Abstract: Techniques for applying segment conditions to measure results are presented. Row and column segment data is acquired from a database according to row and column definitions. A measure calculation is applied against the intersecting row and column segment data. Next, one or more combinations or conditions derived from the row and column definitions are used as a filter to produce filtered results.

Abstract: Tools for defining and using custom analysis modules are presented. A generic graphical user interface (GUI) custom analysis tool is presented to a user. The generic GUI custom analysis tool is adapted to receive selections and inputs from the user that define many-to-many relationships in a data store and that include user-defined measures. The inputs are used to generate an instance of a custom analysis module that is capable of being processed against the data store. The instance of the custom analysis module may be stored, recalled, executed, and/or modified from the generic GUI custom analysis tool.

Abstract: Techniques are presented for reusable data query language statements. User-defined parameter variables with parameter types are interspersed in data query language statements to form a rule. The rule may execute as a standalone application or as part of another application or service. When the rule is executed, parameter values for the parameter variables are dynamically acquired and populated into the data query language statements.