One of the most powerful tools in the BI stack is the SSAS cube. The cube is a collection of related dimensions and measures that, once completed, can provide an enormous about of data that can be sliced just about any way you want it... Oh, and it'll do it just as fast as you can click your mouse. Now like I said, within a cube there are dimensions. These are a lot like the ones you'll see in your data warehouse. A lot of times, within dimension, you'll find hierarchies. Hierarchies are logical...
Read More
Recently, I was working on a reporting project that had a certain display requirement regarding percentages. The desired presentation was that a negative percentage (for example, a percentage decrease in sales relative to a prior period) be displayed within parentheses instead of with "-". This might seem simple and straight forward because the same formatting change can be made for a Number or Currency value with a quick modification to the "Text Box Properties...". However, it is not as straig...