locked
puling data from sql query RRS feed

  • Question

  • When creating a new data connection in PPP Dashboard designer 2010, is it possible to write a sql query instead of selecting sql table?

    I mean is there anyway we can pull data from a sql query?

    Thanks


    shamen
    Thursday, February 17, 2011 9:51 PM

Answers

  • I mean is there anyway we can pull data from a sql query?

    I believe, best would be to create a view from your query and use that view.

    http://dailyitsolutions.blogspot.com/
    Friday, February 18, 2011 7:58 AM

All replies

  • Also when you do data mapping in KPI,

    Why is it asked to select measure when you try to change the data source? (even though source table is relational)

    Thanks


    shamen
    Thursday, February 17, 2011 10:01 PM
  • I mean is there anyway we can pull data from a sql query?

    I believe, best would be to create a view from your query and use that view.

    http://dailyitsolutions.blogspot.com/
    Friday, February 18, 2011 7:58 AM