Closed davelandry closed 5 years ago
Trying to do the following query in logiclayer, and it seems that having sparse=true causes no data to return when using jsonrecords: https://calcite-api.datausa.io/cubes/acs_ygv_veterans_5/aggregate.jsonrecords?drilldown%5B%5D=%5BPeriod+of+Service%5D.%5BPeriod+of+Service%5D&drilldown%5B%5D=%5BYear%5D.%5BYear%5D&drilldown%5B%5D=%5BGeography%5D.%5BPUMA%5D.%5BPUMA%5D&cut%5B%5D=%7B%5BYear%5D.%5BYear%5D.%5BYear%5D.%26%5B2017%5D%7D&cut%5B%5D=%7B%5BGeography%5D.%5BPUMA%5D.%5BPUMA%5D.%26%5B79500US2504000%5D%7D&measures%5B%5D=Veterans&measures%5B%5D=Veterans+Moe&nonempty=true&distinct=false&parents=false&debug=false&sparse=true
sparse=true
Should I be setting sparse to false? I'm not manually setting it right now.
Trying to do the following query in logiclayer, and it seems that having
sparse=truecauses no data to return when using jsonrecords: https://calcite-api.datausa.io/cubes/acs_ygv_veterans_5/aggregate.jsonrecords?drilldown%5B%5D=%5BPeriod+of+Service%5D.%5BPeriod+of+Service%5D&drilldown%5B%5D=%5BYear%5D.%5BYear%5D&drilldown%5B%5D=%5BGeography%5D.%5BPUMA%5D.%5BPUMA%5D&cut%5B%5D=%7B%5BYear%5D.%5BYear%5D.%5BYear%5D.%26%5B2017%5D%7D&cut%5B%5D=%7B%5BGeography%5D.%5BPUMA%5D.%5BPUMA%5D.%26%5B79500US2504000%5D%7D&measures%5B%5D=Veterans&measures%5B%5D=Veterans+Moe&nonempty=true&distinct=false&parents=false&debug=false&sparse=trueShould I be setting sparse to false? I'm not manually setting it right now.