locked
Data sources not showing in Reports when data source is imported from Excel 2007 workbook RRS feed

  • Question

  • Hi,
    I created a data source in Dashboard Designer that imports the data from Excel 2007 workbook. I created the Kpi's and scorecards but when I want to add some graphic to it, the data source can not be found. Are there any additional steps to be made when datasource is of type Excel 2007?

    cheers,
    Gosi
    Tuesday, November 4, 2008 1:06 PM

Answers

  • Hello,

     

    What kind of report are you trying to use?  Are you trying the Analytic reports?  These reports can only be used with a SSAS Cube as the data source.

     

    Thanks,


    Aseem Nayar - MSFT

     

    • Marked as answer by AseemN Monday, December 15, 2008 5:55 PM
    Tuesday, November 4, 2008 3:41 PM

All replies

  • Hello,

     

    What kind of report are you trying to use?  Are you trying the Analytic reports?  These reports can only be used with a SSAS Cube as the data source.

     

    Thanks,


    Aseem Nayar - MSFT

     

    • Marked as answer by AseemN Monday, December 15, 2008 5:55 PM
    Tuesday, November 4, 2008 3:41 PM
  • Hi,

    I was trying to create an analytical report yes. What kind of reports can I then create with the Excel 2007 datascource?

     

    Regards,

    Gosi

    Wednesday, November 5, 2008 11:27 AM
  • You can try the Pivot's or the Spreadsheets.  To get the true experience of PPS Monitoring though you should be building a cube.  The Product was built to work with cubes.

     

    Aseem Nayar - MSFT

     

    Thursday, November 6, 2008 8:29 PM