<div>
How are you defining KPIs?<br />
<br />
can it be done via a select statement?<br />
<br />
YOu can create a cube and define the KPI then use SSRS to report on the cube.
</div>


How are you defining KPIs?

can it be done via a select statement?

YOu can create a cube and define the KPI then use SSRS to report on the cube.

<div>
hi emes, cant we define KPI's without using SSAS cubes as the data source in SSRS ? I am using relational database table in SQL Server...
</div>


hi emes, cant we define KPI's without using SSAS cubes as the data source in SSRS ? I am using relational database table in SQL Server...

<div>
then can we define KPI's in Excel 2007 ?
</div>


<div>
You could do that... I'm not an expert on Excel but I think it is possible
</div>


You could do that... I'm not an expert on Excel but I think it is possible

<div>
<div class="content wysiwyg-content">
hi is it possible to create KPI's in SSRS 2005..if so how ? My source is from a sql query...
</div>
</div>


hi is it possible to create KPI's in SSRS 2005..if so how ? My source is from a sql query...

SSRS 2005

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL Server Analysis Services (SSAS) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.