Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

My end user gave an Excel spreadsheet with 15 columns and 50K rows out of which 5 columns are calculated and 10 are not.

My data modeler has converted Excel into a single TABLE on Microsoft SQL Server platform.

Now I am being asked to create a report that let my end users view calculated columns/numbers/FACTS by Department, By Employee working for those departments, By Geography, By Service Lines, etc.

How do I create such a report in SQL Server Reporting Services using a single FLAT table?

Should I ask the modeler to create a Star-schema model?

How can he convert Excel into Star-schema model?

Is there a need to create such Star-schema model or I can handle it with complex but maintainable SQL code? If so, how?

share|improve this question
Are the Department, By Employee working for those departments, By Geography, By Service Lines, etc in the flat table? – WindRaven Mar 12 '14 at 17:46
Look up the dimensions to your current model then insert the Measures into the Fact table... I'm not sure I follow. – Zane Mar 12 '14 at 17:51
Yes, I just have one TABLE covering Dimensions, FACTS whatever you call that my modeler has created and I am suppose to run my report against it. My question is should I ask him to create a Star-schema model out of single TABLE or just single TABLE should work fine to view calculated columns by DEpartment, By Employee, By Service Line, By Geography, etc – Samuel Mar 12 '14 at 22:09
If you provide the definition of the table you are working with it will help. – Shawn Melton Sep 23 '14 at 19:59

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.