Advertisement
Guest User

Untitled

a guest
Jul 29th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 58.09 KB | None | 0 0
  1.  
  2. {"editability_request":{"edited":[],"visible":[{"metric":"Sls_TY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Sls_LY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Sls_varTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Sls_PTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Sls_TY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Sls_LY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Sls_PTYtoLY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"ARP_TY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"ARP_LY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"ARP_PTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Cost_TY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Cost_LY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"Cost_PTYtoLY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"GIG_PTY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}},{"metric":"GIG_PLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default"},{"dimension":"Location","level":"Location","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType"}]}}]}}
  3. {"query_request":[{"report_name":"generatedReport11939.27","key":[{"qualified_level":{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},"attribute":"id"}],"measure":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Product","level":"Family","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"DICE","dice":{"expr":{"kind":"DICE","dice":{"expr":{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"comparison":[{"op":"EQUALS","expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}}]}},"comparison":[{"op":"EQUALS","expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MAX"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}]}}}],"is_disjunction":false}}],"is_disjunction":true}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"comparison":[{"op":"EQUALS","expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}}]}},"comparison":[{"op":"EQUALS","expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}]}}}],"is_disjunction":false}}],"is_disjunction":true}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Product","level":"Family","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Product","level":"Family","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"DICE","dice":{"expr":{"kind":"DICE","dice":{"expr":{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"comparison":[{"op":"EQUALS","expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}}]}},"comparison":[{"op":"EQUALS","expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MAX"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}]}}}],"is_disjunction":false}}],"is_disjunction":true}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"comparison":[{"op":"EQUALS","expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}}]}},"comparison":[{"op":"EQUALS","expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}]}}}],"is_disjunction":false}}],"is_disjunction":true}}],"is_disjunction":false}}],"return_row_numbers":true},{"report_name":"generatedReport11939.51","key":[{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},"attribute":"id"}],"measure":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}}],"return_row_numbers":true},{"report_name":"generatedReport11939.62","key":[{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},"attribute":"id"}],"measure":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}}],"return_row_numbers":true},{"report_name":"generatedReport11939.735","key":[],"measure":[{"kind":"OVERRIDE","override":{"expr":[{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}}]}},"comparison":[{"op":"EQUALS","expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MAX"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}]}},{"kind":"OVERRIDE","override":{"expr":[{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"FILTER","filter":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}}]}},"comparison":[{"op":"EQUALS","expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"MIN"},"expr":{"kind":"DICE","dice":{"expr":{"kind":"OVERRIDE","override":{"expr":[{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"label"}},{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}}]}},"dicer":[{"kind":"DICE","dice":{"expr":{"kind":"ATTRIBUTE","attribute":{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default"},"attribute":"id"}},"dicer":[{"kind":"METRIC","metric":{"name":"Grid_Filter_TY_B_RPSPITSTWW_PM"}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}}],"is_disjunction":false}}],"is_disjunction":true}},"inter":{"qualified_level":[]}}}]}}],"return_row_numbers":true},{"report_name":"generatedReport11939.79","key":[{"qualified_level":{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},"attribute":"id"},{"qualified_level":{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},"attribute":"id"},{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},"attribute":"id"},{"qualified_level":{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"},"attribute":"id"}],"measure":[{"kind":"DICE","dice":{"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_R_RPSPITSTWW_PM"}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"METRIC","metric":{"name":"Sls_LY_R_RPSPITSTWW_PM"}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"METRIC","metric":{"name":"Sls_varTYtoLY_R_RPSPITSTWW_PM"}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Sls_PTYtoLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_U_RPSPITSTWW_PM"}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"METRIC","metric":{"name":"Sls_LY_U_RPSPITSTWW_PM"}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Sls_PTYtoLY_U_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_TY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_LY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_PTYtoLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_TY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_LY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_PTYtoLY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"GIG_PTY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"GIG_PLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Item","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Location","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},{"dimension":"Type","level":"SalesType","hierarchy":"SalesType","label":"Type"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}}],"return_row_numbers":true}],"relation":[{"param":{"name":"relation_neg1233690922","signature":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"relation":{"intersection":{"qualified_level":[{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]},"column":[{"string_column":{"value":["__LOADING__"]}}]}}]}
  4. {"editability_request":{"edited":[],"visible":[{"metric":"Sls_TY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_LY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_varTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_PTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_TY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_LY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_PTYtoLY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"ARP_TY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"ARP_LY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"ARP_PTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Cost_TY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Cost_LY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Cost_PTYtoLY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"GIG_PTY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"GIG_PLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_TY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_LY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_varTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_PTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_TY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_LY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Sls_PTYtoLY_U_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"ARP_TY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"ARP_LY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"ARP_PTYtoLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Cost_TY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Cost_LY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"Cost_PTYtoLY_C_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"GIG_PTY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}},{"metric":"GIG_PLY_R_RPSPITSTWW_PM","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default"},{"dimension":"Location","level":"Region","hierarchy":"Default"},{"dimension":"Time","level":"Week","hierarchy":"Default"}]}}]}}
  5. {"query_request":[{"report_name":"generatedReport12589.03","key":[{"qualified_level":{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},"attribute":"id"},{"qualified_level":{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"},"attribute":"id"}],"measure":[{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_R_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"METRIC","metric":{"name":"Sls_LY_R_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"METRIC","metric":{"name":"Sls_varTYtoLY_R_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Sls_PTYtoLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_U_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"METRIC","metric":{"name":"Sls_LY_U_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Sls_PTYtoLY_U_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_TY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_LY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_PTYtoLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_TY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_LY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_PTYtoLY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"GIG_PTY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"GIG_PLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}}],"return_row_numbers":true},{"report_name":"generatedReport12589.275000000001","key":[{"qualified_level":{"dimension":"Product","level":"Family","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"}],"measure":[{"kind":"DICE","dice":{"expr":{"kind":"AGGREGATION","aggregation":{"method":{"primitive":"TOTAL"},"expr":{"kind":"METRIC","metric":{"name":"Sls_TY_R_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","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":"METRIC","metric":{"name":"Sls_LY_R_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","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":"METRIC","metric":{"name":"Sls_varTYtoLY_R_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Sls_PTYtoLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","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":"METRIC","metric":{"name":"Sls_TY_U_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","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":"METRIC","metric":{"name":"Sls_LY_U_RPSPITSTWW_PM"}},"inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Sls_PTYtoLY_U_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_TY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_LY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"ARP_PTYtoLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_TY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_LY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"Cost_PTYtoLY_C_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"GIG_PTY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}},{"kind":"DICE","dice":{"expr":{"kind":"APPLICATION","application":{"abstraction":{"kind":"METRIC","metric":{"name":"GIG_PLY_R_RPSPITSTWW_PM"}},"inter_arg":[{"name":"inter","inter":{"qualified_level":[{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}],"expr_arg":[]}},"dicer":[{"kind":"PARAM","param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}}}],"is_disjunction":false}}],"return_row_numbers":true}],"relation":[{"param":{"name":"relation_1971733910","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]}}},"relation":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]},"column":[{"string_column":{"value":["10","10","10","10","10","10","10","10","10","10","10","4","4","4","4","4","4","4","4","4","4","4"]}},{"string_column":{"value":["20150802","20150809","20150816","20150823","20150830","20160626","20160731","20160807","20160814","20160821","20160828","20150802","20150809","20150816","20150823","20150830","20160626","20160731","20160807","20160814","20160821","20160828"]}}]}},{"param":{"name":"relation_neg1329475517","signature":{"intersection":{"qualified_level":[{"dimension":"Location","level":"Region","hierarchy":"Default","label":"Location"},{"dimension":"Product","level":"Family","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":"Product","level":"Family","hierarchy":"Default","label":"Product"},{"dimension":"Time","level":"Week","hierarchy":"Default","label":"Time"}]},"column":[{"string_column":{"value":["4","4","4"]}},{"string_column":{"value":["EN10003","EN10018","EN19999"]}},{"string_column":{"value":["20160828","20160828","20160828"]}}]}}]}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement