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;
}
...
Where do you want to take your career...
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;
}
...
Although the next release of SQL Server (code-named Yukon) is still a future topic, the information that Microsoft has revealed about the upcoming product release is both exciting and troubling. Some of the upcoming changes will require many DBAs...
I'm trying to use T-SQL to return the relative percentage of two summed values when I divide the values into each other, but I always get 0. Here's an example of the type of calculation I'm trying...
How many client connections does SQL Server 2000 support...