In the dimension filter only display members with data
As Sylvie, Statistician in ECO
When using the .Stat DLM Excel add-in
I would like to see in the filter panel only the members with data as done in the DE
So that I'm not lost in the selection step and the selection step becomes more efficient.
For instance the "Eurostat - non-financial transaction" in ECO PP collect only contains quarterly data but propose all 7 members of the frequency code-list:
Technical note
The DE currently uses the API parameter detail=referencepartial
to limit the retrieved dimension values to the ones that are allowed. In addition, the actual content constraint (which is retrieved through the API parameter references=all
) is used to remove dimension values without any data.
Ticket #49 (closed) also deals with changing the config to take these parameters into account.