Take the 2-minute tour ×
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 MSSQLServer 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.

Therefore the question is how do I create such report in MSSSRS using single FLAT table? Should I ask 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? How using SQL then HOW?

share|improve this question
Are the Department, By Employee working for those departments, By Geography, By Service Lines, etc in the flat table? –  Wind Raven Mar 12 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 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 at 22:09
add comment

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.