[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 596
  • Last Modified:

SSRS 2005

hi is it possible to create KPI's in SSRS 2005..if so how ? My source is from a sql query...
0
gvamsimba
Asked:
gvamsimba
  • 2
  • 2
1 Solution
 
EmesCommented:
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.
0
 
gvamsimbaAuthor Commented:
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...
0
 
jorge_torizCommented:
Well, I would think that is not possible.

For KPI's you must refer to the previous member, in a relational fashion you can't do that
0
 
gvamsimbaAuthor Commented:
then can we define KPI's in Excel 2007 ?
0
 
jorge_torizCommented:
You could do that... I'm not an expert on Excel but I think it is possible
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now