In my current project, there are list of kpi's that needs to be displayed on a dashboard with red/green/amber etc and the Trend. This can be done in the following two ways 1) Creating KPI's in SSAS 2008 and display them using SSRS. The report will then
be embedded on a sharepoint portal web page. 2) Creating KPI's using SSAS/Sharepoint Portal. The second option is obviously expensive since I cannot use sharepoint foundation. Could you please advise as what would be the best approach.
View Complete Post