External Dissemination Ideas Portal

Additional fields to report All datasets and new report for All indicators

  1. We are using the All datasets report to check published databases. It would be helpful to include the fields Query ID and Time range to the existing report.
  2. Statistical editors would like a report on All indicators in Kappa. Separate reports for OECD and Norden indicators would be best.

Thanks

  • Guest
  • Jul 26 2017
  • Shipped
  • Attach files
  • Admin
    Claudia Tromboni commented
    July 26, 2017 11:40

    Maggie please could you specify the columns you wish for the indicators report? At the moment we could have IGO in one column and you could filter the XML by IGO. This is until we improve the reports system

  • Guest commented
    July 26, 2017 12:31

    Thanks!

  • Guest commented
    August 1, 2017 13:38

    Hi Claudia,

    Here are the fields that would be interesting in an All Indicators report:

    IGO

    Indicator Code

    Title

    Indicator group

    First release date

    Abstract

    Related publications

    Data source

    Apart from Key words, I am not sure that there are any other options in Kappa. Other info is in the editorial system, but we are currently limited in what we can report from there.

    Thanks

    Maggie

  • Eileen Capponi commented
    August 2, 2017 09:29

    I suggest we also add

    • Indicator group code
    • Availability or status

    And when the XLS has been integrated in XMS, I would also add:

    • Dataset query

     

    Thanks,

    Eileen

  • Admin
    Claudia Tromboni commented
    August 22, 2017 08:19

    Hi Maggie and Eileen,

    you can now take a look in the nighlty  http://kappa-green.oecd.org/KV3NextNightly/report

    for the added reports.

    I have already asked to move the indicator group code next to the indicator group title, do you have any other comment?

    Thank you

    Claudia

  • Admin
    Claudia Tromboni commented
    August 22, 2017 08:22

    actually I have also moved availability, this is the order asked, let me know if it ise ok for you


    IGO
    Indicator Code
    Title
    Indicator group code
    Indicator group title
    First release date
    Availability status
    Abstract
    Related publications
    Data source

  • Guest commented
    August 22, 2017 13:11

    The indicator report looks good. For our use, I would suggest changing the order slightly to the following:

    IGO
    Indicator Code
    Title
    Indicator group code
    Indicator group title

    Data source

    Related publications
    First release date
    Availability status
    Abstract

    Thanks

    Maggie

     
  • Guest commented
    August 22, 2017 13:20

    For the All datasets report, for some datasets, there is a duplicate entry in the Parent titles column.

    For example ECONSH_I, and "Labour Market Statistics (en), Labour Market Statistics (en)". This is the dataset group, but it would be more helpful to show the group and also the database, if possible.

    Another example SHA_HK (http://kappa.oecd.org/v3/metadata/e82a406e)

    Thanks

  • Guest commented
    August 24, 2017 14:15

    If it is possible to show the parent group and the parent database, these should be in separate columns.

    Thanks

  • Eileen Capponi commented
    September 28, 2017 08:27

    Hi Claudia,

    Referring back to the last two comments in the thread, following the last ‘shipment’ I see that the Parent title issue has not been resolved. Maybe it was not planned for this shipment, but I just wanted to make sure that this is still on your radar.

    Example for this dataset from the latest report:

    OECD

    Foreign direct investment: positions by industry (en)

    FDI_POS_IND

    kcdr9p

    10.1787/data-00748-en

    English

    yes

    Dataset updating

    Online

    Published

    Benchmark definition, 4th edition (BMD4) (en), Benchmark definition, 4th edition (BMD4) (en)

    Instead of listing Parent Titles as Benchmark definition, 4th edition (BMD4) (en), Benchmark definition, 4th edition (BMD4) (en)

    Parent group should be: Benchmark definition, 4th edition (BMD4) (en)
    Parent database should be: OECD International Direct Investment Statistics (en)

    Thanks,
    Eileen

  • Guest commented
    January 24, 2018 16:44

    As Eileen suggested in August,

    "And when the XLS has been integrated in XMS, I would also add:

    • Dataset query"

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

    Would it be possible to add the queries to the Indicators report?

    Thanks

    Maggie