Import data from Excel file into Business-Intelligence module

Discussion in 'Business-Intelligence' started by Baracskai Attila, Jun 1, 2015.

  1. Baracskai Attila

    Baracskai Attila Administrator

    Add new ODBC variable:

    upload_2015-6-1_15-19-46.png
    Baracskai Attila, Jun 1, 2015
    #1
  2. Baracskai Attila

    Baracskai Attila Administrator

    Excel file: m:\EmissionFactors.xls

    upload_2015-6-1_15-21-7.png
    Baracskai Attila, Jun 1, 2015
    #2
  3. Baracskai Attila

    Baracskai Attila Administrator

    Create connection to XLS file:

    upload_2015-6-1_15-35-14.png

    Get LPG kWh factor:

    upload_2015-6-1_15-25-2.png
    Last edited: Jun 1, 2015
    Baracskai Attila, Jun 1, 2015
    #3
  4. Baracskai Attila

    Baracskai Attila Administrator

    Add expression & report file:

    upload_2015-6-1_15-26-45.png
    Baracskai Attila, Jun 1, 2015
    #4
  5. Baracskai Attila

    Baracskai Attila Administrator

    Start Query:

    upload_2015-6-1_15-32-2.png
    Baracskai Attila, Jun 1, 2015
    #5
  6. Baracskai Attila

    Baracskai Attila Administrator

    Download BI example:

    Attached Files:

    Baracskai Attila, Jun 1, 2015
    #6

Share This Page