Reporting dashboard/landing page
Hi, I have a cube built with SSAS. I want add reporting functionality. I need a web portal with a landing page. The landing page must contain an overview that can be drilled down to view more granular detail. What sort of technology do you guys suggest
to accomplish this? Thanks
May 25th, 2011 4:19am
Hi,
You could create reports using SSRS and deploy the reports in sharepoint. Additionally you could use Perfomance Point Server 2010 or excel.
HTH,
RamRam
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 7:50am
Thank you,
Could you please explain to me what the functionality of Performance Point Server is?
May 25th, 2011 8:18am
You could follow this link
http://www.microsoft.com/business/performancepoint/productinfo/whatispps.aspx
HTH,
RamRam
Free Windows Admin Tool Kit Click here and download it now
May 25th, 2011 8:59am
You could follow this link
http://www.microsoft.com/business/performancepoint/productinfo/whatispps.aspx
HTH,
RamRam
May 25th, 2011 8:59am
Hi Terramorphus,
Just like Ram's advise you can make use of SQL Server Reporting Services as front page, as SQL Server Reporting Services could also retrieve the datasource from SSAS's cube. In SQL Server Reporting Services, there are many features like drill-down
or drill through function you can use.
Before this, I would recommend you read this white paper about
Analysis and Reporting Services, Design and Implementation: A SQL Server 2008 technical case study.
Thanks,
Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 1:23am