Too often, people consider extraction, transformation, and loading (ETL) only in their data-warehousing environments. They completely overlook that the same ETL concepts and practices used with data warehousing also apply to data migration from...
Preserve your database's records without sacrificing performance...
When creating a financial report such as an income statement, you need to display the subtotals (which are parent members of a dimension) at the bottom of the statement—after the details (which are children). You can use the MDX Hierarchize() fun...
I knew nothing about business intelligence (BI) until I sat through a session about a new feature tentatively called the d-cube (for data cube) during the developer's conference several years ago for the beta version of SQL Server 7.0 (code-named...
table.downloadBox {
width: 100%;
border: solid 1px #666;
border-collapse: collapse;
}
table.downloadBox th {
background: #276C9F;
padding: 3px;
color: #fff;
font-size: 14px;
text-align: center;
}
...