Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
Here's a mind bender: How can you determine what the top drink product is for each quarter in 1997? (Hint: Use a variation of the tip of the month, below.) We'll answer this question in an upcoming issue. Until then, if you have ideas or questions...
Do you know how to write an MDX query that returns non-numeric results? Here is an example of how useful this capability can be. If you list your company's top 10 products based on unit sales, wouldn't you like to see a mark next to the products...
As a Relational Database Management System (RDBMS), SQL Server uses the referential integrity constraint to ensure that data in one table points to data in another table—and doesn’t point to data that doesn’t exist. SQL Server uses constrain...
How would you ask for the top 10 yellow products based on Store Sales? That's the question we posed in the previous MDX Puzzle (Mastering OLAP, July 1999). You can look at this question in a couple of ways. The Product dimension of the Sales cube...