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.

Hi,

Nice to see that you have a HR system.

We are using WhereScape RED as the RAD tool for Datawarehousing and
Panorama Novaview / ReportPortal as frontend for OLAP and SQL reports
for HR systems. You may use also Cizer Reporting if you like.

More info + free downloads:
www.gmsbv.nl
www.wherescape.com
www.cizer.com
www.reportportal.com
www.panorama.com


Regards,
Marco

Henrik Skak Pedersen schreef:

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/subscripti...ult.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/subscripti...t/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)