Abstract: A disclosed data platform may be configured to access a custom policy developed by a particular client entity that uses the data platform. The custom policy may invoke a query that targets a target dataset ingested from a cloud environment and stored in a data store. The data platform may determine that the custom policy is likely to be of value to one or more other client entities, besides the particular client entity, that also use the data platform. In response to the determining that the custom policy is likely to be of value to the one or more other client entities, the data platform may generate a community policy based on the custom policy. The community policy may be available for use by the one or more other client entities. Corresponding methods, systems, and products are also disclosed.

Abstract: Systems, methods and articles of manufacture are disclosed for generating a relational database query from an online analytical processing (OLAP) query against a cube. The cube may have dimensions, each dimension having a hierarchy of members. A level of the hierarchy of a dimension of the cube may be identified from which the OLAP query accesses a number of members exceeding a predefined threshold count of members. A relational database query may be generated that includes a predicate for at least one member from at least one level above the identified level in the hierarchy, instead of a plurality of predicates for members from the identified level. The relational database query may be generated from the OLAP query, from a definition for the hierarchy, and from the accessed members from the identified level. As a result, the relational database query may include fewer predicates and may be executed more efficiently.