Abstract: Embodiments of the present invention relate to systems, methods and computer storage media for providing an advertisement to a consumer in an online environment for utilization in an offline environment. The offline utilization of the coupon by the consumer allows for an amount owed to an advertisement-service provider by a merchant to be reduced. The advertisement-service provider provides, for a fee, advertising services for the merchant, which includes presenting a coupon to the consumer in an online environment. The consumer is presented with the coupon by the advertisement-service provider on behalf of the merchant. In one embodiment, the consumer stores the coupon for later redemption in an offline environment. The consumer purchases goods or service in an offline environment utilizing the coupon. The advertisement-service provider reduces an amount the merchant owes as a result of the consumer's offline redemption of the coupon.

Abstract: Systems and methods for storing and retrieving data items in multidimensional databases are provided. Data partition templates are generated for grouping data partitions that are similar to one another, that is, that contain information specified according to particular common characteristics (for instance, time, product, geography, etc.). The data partition template includes one or more rules concerning how the data stored in partitions associated with the data partition template should be processed. A template object having the rule(s) associated therewith is generated for the data partition template. Once a data partition template is generated, a plurality of partitions are generated in accordance therewith. Each of the plurality of partitions utilizes the template object associated with the data partition template. In this way, the overhead associated with managing the partitions is significantly decreased.