Reporting for our HR application

We are about to create a new reporting platform for our HR application. We
are considering different solutions and I would like to get some advice.
We have different kind of tables, eg. Base Tables, Transaction Tables, Setup
Tables. We need to be able to print out both traditional ERP like
transactional reports eg a list of Employee Loans and aggregated reports
showing salary information.
I also need to provide a model for end users, so they easily can create
their own reports.
We are using Reporting Services as our reporting solution.
1) Create OLAP cubes with all my tables as fact tables and dimensions
surrounding them.
2) Create a reporting services "Report Model".
3) Create all reports on the existing data model.
4) Create a Data Warehouse and create all reports on the new data model.
Thanks
Henrik.Hello Henrik,
Thank you for posting here!
I notice that you have posted the same question in our reporting services
newsgroup, to which I have already responded. Please check my answer there,
and if you need any further assistance on this particular issue please
reply to me in that thread so I can follow up with you. In the future,
please don't cross-post the same question in multiple newsgroups. This
will help our engineers work on your question more efficiently. Your
understanding and cooperation is appreciated.
For your convenience, I have included my reply as follows:
Hello Henrik,
SQL Reporting Services 2005 will suitable for your solution.
You could design a report to access your SQL database and generate the
transactional report.
Also, you could design a report to access the SQL Analysis Server.
From your description, my understanding is that you want to use the Report
Model to make end user could design the report.
Yes, you could build a report model based on a Analysis Cube. For more
detailed information about how to build a model, please refer the BOL
article:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/70f75784-6895-498e-8d15-
8732ef95621a.htm
Also, here are some BOL article for your reference:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/4d6ad529-7c80-4aed-a208-
339f12b27659.htm
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/395a4f26-6401-4ee1-8658-b
e8b43cc70a8.htm
We would also like to introduce you to the CUSTOMER SERVICE AND SUPPORT
(CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Sincerely,
Wei Lu
Microsoft Online Community Support
Thank you and have a nice day!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)