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 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? –  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
    
If you provide the definition of the table you are working with it will help. –  Shawn Melton Sep 23 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.