<div>
<div class="content wysiwyg-content">
How do you join an aggregate fact to base fact in a data warehouse? &nbsp;How do you go from summary to detail? Should you create an aggregate dimension or an aggregate fact?
</div>
</div>


How do you join an aggregate fact to base fact in a data warehouse?  How do you go from summary to detail? Should you create an aggregate dimension or an aggregate fact?

Aggregate/Summary Tables in a Data Warehouse

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.