A machine readable medium comprising computer readable instructions, which when loaded and run in a computer and/or computer network system, causes the computer system and/or the computer network system to perform operations according to a method, the method comprising: receiving a query in a first format; parsing the query to determine a filter condition in the query; analyzing the filter condition to determine a semantic context of one or more member sets of the filter condition, comprising: identifying a dimension of one or more predicates in the filter condition; grouping the one or more predicates of a same dimension into a member set; and if the filter condition has a measure, determining a hierarchy level in the dimension of the one or more member sets for which the measure is aggregated; converting the filter condition into a disjunctive normal form based on the semantic context by placing disjunctions between member sets, comprising: converting the filter condition to a conjunctive normal form to identify the one or more member sets that belong to different dimensions; grouping one or more predicates of a same dimension into one of the one or more member sets of the same dimension; and converting the filter condition to the disjunctive normal form by representing the one or more member sets as a union of intersections of the one or more member sets; and creating a normalized filter condition by replacing logical operators between the one or more member sets with normalized operators. receiving a query in a first format; parsing the query to determine a filter condition in the query; analyzing the filter condition to determine a semantic context of one or more member sets of the filter condition, comprising: identifying a dimension of one or more predicates in the filter condition; grouping the one or more predicates of a same dimension into a member set; and if the filter condition has a measure, determining a hierarchy level in the dimension of the one or more member sets for which the measure is aggregated; identifying a dimension of one or more predicates in the filter condition; grouping the one or more predicates of a same dimension into a member set; and if the filter condition has a measure, determining a hierarchy level in the dimension of the one or more member sets for which the measure is aggregated; converting the filter condition into a disjunctive normal form based on the semantic context by placing disjunctions between member sets, comprising: converting the filter condition to a conjunctive normal form to identify the one or more member sets that belong to different dimensions; grouping one or more predicates of a same dimension into one of the one or more member sets of the same dimension; and converting the filter condition to the disjunctive normal form by representing the one or more member sets as a union of intersections of the one or more member sets; and converting the filter condition to a conjunctive normal form to identify the one or more member sets that belong to different dimensions; grouping one or more predicates of a same dimension into one of the one or more member sets of the same dimension; and converting the filter condition to the disjunctive normal form by representing the one or more member sets as a union of intersections of the one or more member sets; and creating a normalized filter condition by replacing logical operators between the one or more member sets with normalized operators.