{"query_request":[{"report_name":"generatedReport235841.96000000002","key":[{"qualified_level":{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},"attribute":"id"},{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},"attribute":"id"},{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},"attribute":"id"},{"qualified_level":{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},"attribute":"id"}],"measure":[{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_R_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1640961282","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_LY_R_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1640961282","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_varTYtoLY_R_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1640961282","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_U_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1640961282","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_LY_U_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1640961282","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}}],"return_row_numbers":true},{"report_name":"generatedReport235842.08000000002","key":[{"qualified_level":{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},"attribute":"id"},{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},"attribute":"id"},{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},"attribute":"id"},{"qualified_level":{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},"attribute":"id"}],"measure":[{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_R_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_2067548973","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_LY_R_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_2067548973","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_varTYtoLY_R_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_2067548973","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_U_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_2067548973","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"SPLIT","split":{"expr":{"kind":"METRIC","metric":{"name":"Sls_LY_U_RPSPITSTWW_PM"}},"map":[{"source":"Location","target":"Location2"}]}},"inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_2067548973","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}}],"return_row_numbers":true}],"relation":[{"param":{"name":"relation_neg1640961282","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"relation":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Metro","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]},"column":[{"string_column":{"value":["4","4","4","4","4","4"]}},{"string_column":{"value":["17","18","19","32","35","5"]}},{"string_column":{"value":["1601888052","1601888052","1601888052","1601888052","1601888052","1601888052"]}},{"string_column":{"value":["20150830","20150830","20150830","20150830","20150830","20150830"]}}]}},{"param":{"name":"relation_2067548973","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"relation":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location2"},{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]},"column":[{"string_column":{"value":["4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4","4"]}},{"string_column":{"value":["10017","10018","10029","10040","10055","10068","10076","10079","10080","10081","10107","10116","10119","10120","10129","10164","10167","10170","10171","10203","10244","10252","10276","10292","10315","10330","10345","10364","10369","10378","10404","10419","10460","10465","10481","10482","10490","10495","10567","10568","10569","10570","10571","10572","10573","10585"]}},{"string_column":{"value":["1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052","1601888052"]}},{"string_column":{"value":["20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830","20150830"]}}]}}]}