We just recently had a ConfigMgr guy turned BI guy present at our HASMUG
meeting last week. He was showing how he presents System Center tabular data
(including ConfigMgr) via SharePoint 2013 Power View dashboards. It was really
slick! It's a pretty intuitive process to create the dashboards and very
intuitive for the end-user to filter and use "slicers" to query the data they
are looking for, without the burden of us having to create new SSRS reports.
You can also use Power View in Excel 2013. It does have its limits. It's not
designed to show tabular data. I should have the slide deck of the presentation
available soon if anyone is interested.
-Stephen
From: [email protected]
To: [email protected]
Subject: [mssms] Feedback Request: Developing ConfigMgr 2012 Reports
Date: Thu, 31 Oct 2013 08:48:06 -0500
Hey folks, I was just hoping to gather some general feedback about how people
are developing and publishing ConfigMgr 2012 reports. Now that we no longer
have classic ASP reports, how are you writing reports? Are you using SQL Server
Management Studio (SSMS), Report Builder, or Business Intelligence Development
Studio (BIDS)? What tools have you found easy (or hard) to use, and what is
your workflow for creating reports, and publishing them out to business
end-users? Do you create Active Directory security groups to restrict business
users to specific SQL Server Reporting Services (SSRS) folders? How do you
organize your folders? Any additional feedback you can provide would be
helpful, including screenshots. Cheers,Trevor Sullivan
