Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Architecting a Reporting Services project
Posted on 2015-01-07
I have built reports in SSRS before but I have not taken on a full Enterprise Reporting system before. I was thinking about building a Data Warehouse and data marts for departments and build reports off of that. I was thinking in Report manager to have folders for each department(with roles within their departments) and have a folder for Static reports that users can just run and download the data, etc....Second have reports folder/section where users can build their own reports off of a Report Model maybe? The idea would be for them to be able to build their own report(s), etc. I could have their departmental cubes as their data sources and so on...
I was also thinking to have dashboards for Upper management users so they can logon and have it set up their own way with what they want to see. I have never done a dashboard before? Would that be buil tin BI? Where would I be able to set them up with their own dashboards?
Am I on the right track here?
I was also thinking to have dashboards for Upper management users so they can logon and have it set up their own way with what they want to see. I have never done a dashboard before? Would that be buil tin BI? Where would I be able to set them up with their own dashboards?
Am I on the right track here?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
5 Comments
Active 6 days ago
You're surely on the right track, except for the part about Report Models. As of SQL Server 2012 Report Models are deprecated (ref Deprecated Features in SQL Server Reporting Services in SQL Server 2014). But don't worry, that's not a problem. If your DWH/data marts are nicely modeled with clear dimensions and facts then users should be able to just connect to those (or to SSAS cubes if you're going to build those) and build ad-hoc reports off of them.
There are several ways to create dashboards. The easiest one is to build them just using SSRS. You've already got the technology so it's just a matter of using other controls than you're used to for regular table-design reports. You'd be using the Sparkline and Data Bar, the Indicator, some Charts. Basically a dashboard is just a regular report with a different design. To get an idea have a look at what Jason Thomas has produced here: A Sample SSRS Dashboard and some Tips & Tricks
If you've got SharePoint then you could consider using PerformancePoint Dashboards but I'm not a big fan of those. I'd prefer to build exactly the same just by using SSRS.
Other technology to consider if you've got SharePoint is called Power View. This allows you to create nice interactive dashboards.
There are several ways to create dashboards. The easiest one is to build them just using SSRS. You've already got the technology so it's just a matter of using other controls than you're used to for regular table-design reports. You'd be using the Sparkline and Data Bar, the Indicator, some Charts. Basically a dashboard is just a regular report with a different design. To get an idea have a look at what Jason Thomas has produced here: A Sample SSRS Dashboard and some Tips & Tricks
If you've got SharePoint then you could consider using PerformancePoint Dashboards but I'm not a big fan of those. I'd prefer to build exactly the same just by using SSRS.
Other technology to consider if you've got SharePoint is called Power View. This allows you to create nice interactive dashboards.
Active 1 day ago
That brings up a good point. The company I am going to has Sharepoint but they dont have it integrated with SSRS. Is this something I should do? Ive never done it before. Is there an advantage to using Sharepoint with SSRS. Is it just used as a reporsitory for the reports? Id like to know your opinion
I have looked at that link recently, its funny that you sent me the same page that I was using.
Thanks for your help...
I have looked at that link recently, its funny that you sent me the same page that I was using.
Thanks for your help...
Active 6 days ago
Using SharePoint you get document versioning (your reports are considered documents) out of the box. You also use Sharepoint security to control who has access to what. And users stay in the same (SharePoint) environment while doing their job while on a native SSRS server they'd access reports through Report Manager or Server. It would also give you the opportunity to try out the newer technologies such as Power View.
Make sure you check the requirements of the components you'd like to use because I believe things like Power View require SharePoint Enterprise edition.
On the other hand, if the above advantages are not that important you could keep it simple and go for native SSRS...
This could be interesting to read through: Reporting Services Report Server (SharePoint Mode)
Make sure you check the requirements of the components you'd like to use because I believe things like Power View require SharePoint Enterprise edition.
On the other hand, if the above advantages are not that important you could keep it simple and go for native SSRS...
This could be interesting to read through: Reporting Services Report Server (SharePoint Mode)
Featured Post
![[Webinar] How Hackers Steal Your Credentials](https://filedb.experts-exchange.com/files/public/2017/5/20/3315d9d8-8110-4d52-be94-a5aacdd83e4b.png)
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
- Windows OS
- Windows XP
- Windows 7
- Mac OS X
- Windows 10
- Windows 8, Software-Other, System Utilities, Vulnerabilities, Web Browsers
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month5 days, 6 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
635 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.