External Dissemination Ideas Portal

Additional fields to report All indicators

  • Guest
  • Jan 31 2018
  • Shipped
  • Attach files
  • Guest commented
    31 Jan 16:20

    As data curation is now integrated in XMS, all indicator queries are available in Kappa.

    Please add the list of queries for each indicator in the report All indicators

    We now have a request to provide this information to STD soon.

    Thanks

    Maggie

  • Guest commented
    31 Jan 16:52

    Report details:

    column heading 

    measureCode subjectCode query #

      # is  <dataPortalSeries> number if several exist.

     

    details, in bold, taken from:  <dataPortalSeries measureCode="AGRWTH" subjectCode="DOMESTIC">  <query>/MEI_PRICES_PPI/PIEAMP02..GY./OECD?</query>

     

    one column for each  <dataPortalSeries/> 

    If not clear, let me know!

  • Guest commented
    01 Feb 08:54

    Hi Claudia,

    Can we change the order of subject and measure, so we would see:

    subjectCode="DOMESTICmeasureCode="AGRWTH" <query>/MEI_PRICES_PPI/PIEAMP02..GY./OECD?</query>

    as this is how it is defined in XMS.

  • Ludivine Baudouin commented
    01 Feb 08:59

    a couple comments:

    - could we have the subject before the measure since this is the way we defined indicators?

    so the order would be "subjectCode measureCode query #"

    - please be aware that there can be more than 1 query within the same dataPortalSeries

    For instance MEDICALDOC indicator:

    <dataPortalSeries commonUnitCode="1000HAB" measureCode="1000HAB" powerCode="0" referencePeriod="" subjectCode="TOT">
    <availableTimeFrequency frequency="A" />
    <curationRule applyPowerCode="0" checkThreshold="5" doNotCompareDatasets="false" omit="false">
    <sourceDataset sourceLocationDimensionCode="COU" sourceTimeDimensionCode="YEA">
    <query>/HEALTH_REAC/PHYSMEDE.DENSPPNB.AUS+AUT+BEL+CZE+DNK+EST+DEU+FIN+HUN+IRL+ISL+ISR+ITA+JPN+KOR+LUX+MEX+NZL+NOR+POL+SVN+ESP+SWE+CHE+GBR+USA+BRA+CHN+COL+IND+IDN+LVA+LTU+RUS+ZAF/OECD?</query>
    <query>/HEALTH_REAC/PHYSPAPS.DENSPPNB.CAN+FRA+NLD+SVK+TUR/OECD?</query>
    </sourceDataset>
    </curationRule>
    </dataPortalSeries>

     

    thank you very much!

  • Admin
    Claudia Tromboni commented
    01 Feb 13:40

    would you want 1 line per combination of subject measure query (so each indicator would be repeated for as many lines as there are combinations ?

    Either

    indicator metadata subject measure query
    indicator 1 subject1 measure1 query1
    indicator 1 subject2 measure2 query2
    indicator 1 subject3 measure3 query3


    or

    indicator metadata subject measure query
    indicator 1 subject1|subject2|subject3 measure1|measure2|measure3 query1|query2|query3
  • Eileen Capponi commented
    01 Feb 13:58

    My tuppence worth is the following: I think the first option works best. It will be difficult to use information about queries when it is concatenated with other information in a single cell.

    Any thoughts on this?

    Eileen

  • Ludivine Baudouin commented
    01 Feb 14:33

    Hi Claudia,

     

    we discussed it and we all agree to go for:

    indicator metadata subject measure query
    indicator 1 subject1 measure1 query1
    indicator 1 subject2 measure2 query2
    indicator 1 subject3 measure3 query3

     

    The other option doesn't work anyway!

     

    many thanks

  • Ludivine Baudouin commented
    01 Feb 14:37

    what should we do to address cases with more than 1 query?

     

    indicator metadata subject measure query
    indicator 1 subject1 measure1

    query1a

    query1b

    indicator 1 subject2 measure2 query2

    or

    indicator metadata subject measure query
    indicator 1 subject1 measure1 query1a
    indicator 1 subject1 measure1 query1b
    indicator 1 subject2 measure2 query2
  • Admin
    Claudia Tromboni commented
    02 Feb 08:28

    could you give me an example of this last case so I can see how it looks in the xml and advise ? thanks

  • Ludivine Baudouin commented
    02 Feb 09:36

    For instance MEDICALDOC indicator:

    <dataPortalSeries commonUnitCode="1000HAB" measureCode="1000HAB" powerCode="0" referencePeriod="" subjectCode="TOT">
    <availableTimeFrequency frequency="A" />
    <curationRule applyPowerCode="0" checkThreshold="5" doNotCompareDatasets="false" omit="false">
    <sourceDataset sourceLocationDimensionCode="COU" sourceTimeDimensionCode="YEA">
    <query>/HEALTH_REAC/PHYSMEDE.DENSPPNB.AUS+AUT+BEL+CZE+DNK+EST+DEU+FIN+HUN+IRL+ISL+ISR+ITA+JPN+KOR+LUX+MEX+NZL+NOR+POL+SVN+ESP+SWE+CHE+GBR+USA+BRA+CHN+COL+IND+IDN+LVA+LTU+RUS+ZAF/OECD?</query>
    <query>/HEALTH_REAC/PHYSPAPS.DENSPPNB.CAN+FRA+NLD+SVK+TUR/OECD?</query>
    </sourceDataset>
    </curationRule>
    </dataPortalSeries>

  • Damien G commented
    02 Feb 09:40

    Hello,
    Preference is for one row per query (as per example 2 by Ludivine).

    Here is another example (in addition to the one already given by Ludivine):

    Indicator http://kappa.oecd.org/v3/metadata/edc3ff4f
    XML http://kappa.oecd.org/v3-old/Expression/XmlContent/920b3be9

    /GIDDB2014/ALL..AIC.RC_2_2/OECD?

    /GOV_2015/.EMPW_PARL/OECD?startTime=2000&endTime=2013
    /GOV_2015/.EMPW_PARL/OECD?startTime=2015&endTime=2016

    Hope that helps,
    Damian

  • Admin
    Claudia Tromboni commented
    02 Feb 11:13

    yes it is my pfreference as well, I will create the issue and insert it in the board. A developer will take it as soon as there is availability.

    please monitor the status of the idea to see when it is shipped, I will let you know when it is available on nightly for testing

    We cannot give a timing for the shipment, please stay tuned

  • Ludivine Baudouin commented
    09 Feb 10:59

    Hi Claudia,

    can you tell us when this will be shipped? as you can read from Maggie's first comment "We now have a request to provide this information to STD soon" this is quite urgent. 

    thanks,

    Ludivine, on behalf of Eileen

  • Admin
    Claudia Tromboni commented
    09 Feb 12:28

    Hi Ludivine, the development has just been finished, please test it in Nightly

    The next release will take place very soon (next week)

    for reference : https://pacps01.oecd.org/redmine/issues/14389

  • Guest commented
    09 Feb 16:02

    Hi Claudia,

    This looks good. So I suppose we can use this list generated in Nightly to respond to our request from STD. Can you confirm?

    Thanks

    Maggie

  • Admin
    Claudia Tromboni commented
    12 Feb 10:08

    Hi Maggie,

    sorry for the late response. As per this morning you can now use the production environment to generate the report. It's in prodution

    Claudia