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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

 
discard

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

Browse other questions tagged or ask your own question.