protected function finalizeRequest4Total(AbstractQueryRequest $request, AbstractQueryRequest $request4Total, array $columnNames4Total) {
        $totalExpressions = $request4Total->getOption(self::OPTION__TOTAL_FORMULA_EXPRESSION);

        // preparing returned columns
        $columnIndex = 0;
        // ... TODO existing dimensions (to support non-additive measures)
        /*
        if (isset($request->dimensions)) {
            foreach ($request->dimensions as $dimension) {
                if (isset($dimension->columns)) {
                    foreach ($dimension->columns as $column) {
                        $request4Total->addDimensionColumn($columnIndex++, $dimension->name, $column->name);
                    }
                }
                else {
                    $formula = $request->getFormula($dimension->name);
                    if (isset($formula)) {
                    // checking if the formula contains reference to TOTAL function
                        if (isset($totalExpressions[$formula->name])) {
                            // excluding the formula
                            continue;
                        }
                    }

                    $request4Total->addDimension($columnIndex++, $dimension->name);
                }
            }
        } */
        // ... measures to calculate total
        foreach ($columnNames4Total as $measureName) {
            $formula = $request4Total->getFormula($measureName);

            // TODO checking if the formula expression contains any aggregation functions (eliminate when non-additive measures are supported)
            $handler = FormulaExpressionLanguageFactory::getInstance()->getHandler($formula->expressionLanguage);
            $lexemes = $handler->lex($formula->source);
            $syntaxTree = $handler->parse($lexemes);
            $isMeasure = $handler->isMeasure($syntaxTree);
            if (!isset($isMeasure) || !$isMeasure) {
                // updating expression to summarize data for the expression
                $formula->source = 'SUM(' . $formula->source . ')';
            }

            $formula->isMeasure = TRUE;

            $request4Total->addMeasure($columnIndex++, $measureName);
        }

        // preparing data querying
        $dimensionQueries = $request->findDimensionQueries();
        if (isset($dimensionQueries)) {
            foreach ($dimensionQueries as $query) {
                foreach ($query->columns as $queryColumn) {
                    $request4Total->addDimensionColumnQueryValues($query->name, $queryColumn->name, $queryColumn->values);
                }
            }
        }

        $factsDatasetColumnQueries = $request->findFactsDatasetColumnQueries();
        if (isset($factsDatasetColumnQueries)) {
            foreach ($factsDatasetColumnQueries as $query) {
                $request4Total->addFactsDatasetColumnQueryValues($query->name, $query->values);
            }
        }

        $measureQueries = $request->findMeasureQueries();
        if (isset($measureQueries)) {
            foreach ($measureQueries as $query) {
                $formula = $request->getFormula($query->name);
                if (isset($formula)) {
                    // checking if the formula contains reference to TOTAL function
                    if (isset($totalExpressions[$formula->name])) {
                        // excluding the condition
                        continue;
                    }
                }

                $request4Total->addMeasureQueryValues($query->name, $query->values);
            }
        }
    }
    protected function finalizeRequest4Total(AbstractQueryRequest $request, AbstractQueryRequest $request4Total, array $columnNames4Total) {
        $totalExpressions = $request4Total->getOption(self::OPTION__TOTAL_FORMULA_EXPRESSION);

        // preparing returned columns
        $columnIndex = 0;
        foreach ($columnNames4Total as $columnName) {
            $formula = $request4Total->getFormula($columnName);
            // updating expression to summarize data for the expression
            $formula->source = 'SUM(' . $formula->source . ')';
            $formula->isMeasure = TRUE;

            $request4Total->addMeasure($columnIndex++, $columnName);
        }

        // preparing data querying
        if (isset($request->queries)) {
            if (count($request->queries) > 1) {
                throw new UnsupportedOperationException('Composite requests are not supported');
            }

            foreach ($request->queries as $index => $queries) {
                foreach ($queries as $name => $values) {
                    $formula = $request->getFormula($name);
                    if (isset($formula)) {
                        // checking if the formula contains reference to TOTAL function
                        if (isset($totalExpressions[$formula->name])) {
                            // excluding the condition
                            continue;
                        }
                    }
                    $request4Total->addFactsDatasetColumnQueryValues($name, $values);
                }
            }
        }
    }