microdata preview says there is no data for HCLs parent item selection
When I try to select a parent code for data visualization from a simple hierarchy code list and click observation values to drill down to the microdata preview, all children items of that parent codes are displayed on microdata preview.
Aid activities targeting gender equality and womens empowerment-with simple hierarcy - https://de-demo-oecd.siscc.org/vis?lc=en&df[ds]=OECD-staging&df[id]=DSD_GNDR%40DF_GENDER&df[ag]=OECD.DCD.FSD&df[vs]=1.0&av=true&lo=2&lom=LASTNPERIODS&dq=DAC_EC..1000..2.1%2B2%2B10.C.Q._T..&ly[rw]=RECIPIENT&ly[cl]=SCORE&to[TIME_PERIOD]=false&vw=tb&mdc[RECIPIENT]=AFG&mdc[SCORE]=10&mdc[DONOR]=DAC_EC&mdc[SECTOR]=1000&mdc[ALLOCABLE]=2&mdc[FLOW_TYPE]=C&mdc[PRICE_BASE]=Q
However same structure and same data with properly defined HCL does not return any result for the microdata preview.
Aid activities targeting gender equality and womens empowerment with HCL - https://de-demo-oecd.siscc.org/vis?lc=en&df[ds]=OECD-design&df[id]=DSD_GNDR%40DF_GENDER&df[ag]=OECD.DCD.FSD&df[vs]=1.0&av=true&lo=2&lom=LASTNPERIODS&dq=DAC_EC..1000..2.1%2B2%2B10.C.Q._T..&ly[rw]=RECIPIENT&ly[cl]=SCORE&to[TIME_PERIOD]=false&vw=tb&mdc[RECIPIENT]=AFG&mdc[SCORE]=10&mdc[DONOR]=DAC_EC&mdc[SECTOR]=1000&mdc[ALLOCABLE]=2&mdc[FLOW_TYPE]=C&mdc[PRICE_BASE]=Q
Reproducible in QA, it seems the query misses the children when it's a HCL: https://de-qa.siscc.org/vis?lc=en&df[ds]=qa%3Astable&df[id]=DSD_GNDR%40DF_GENDER&df[ag]=OECD.DCD.FSD&df[vs]=1.0&av=true&dq=DAC_EC..1000..2.1%2B2%2B10.C.Q._T..&lom=LASTNPERIODS&lo=2&ly[rw]=RECIPIENT&ly[cl]=SCORE&to[TIME_PERIOD]=false&vw=md&mdc[RECIPIENT]=AFG&mdc[SCORE]=10&mdc[DONOR]=DAC_EC&mdc[SECTOR]=1000&mdc[ALLOCABLE]=2&mdc[FLOW_TYPE]=C&mdc[PRICE_BASE]=Q
To reproduce the issue in oecd-prod please see the attached video :