Data Warehouse [SSAS] Questions: Notes: What is Conditional Formatting? Conditional Formatting is done via Calculated Members. They allow us to add custom formatting to our measures based upon certain conditions. For example, we can format a Net Sales measure to be green if it is positive (income) or red if it is negative […]
Data Warehouse [SSAS] Questions: Notes: How can you optimize reading from a Cube? In order to optimize reading from a cube, you physical normalize the dimensions via attribute hierarchies. It is also a good idea to create Partitions in the data storage files of the cube. By creating partitions the server can perform parallel processing […]
Data Warehouse [SSAS] Questions: Notes: What is SSAS? SSAS stands for SQL Server Analysis Services. It allows us to take data from our data warehouse and analyze it for Business Intelligence. What are Attribute Hierarchies? In relational tables, there are columns. In Cube Dimensions, columns are known as Attribute Hierarchies. What are Members of Attribute […]
I hope everyone had a wonderful July 4th. l want to end this week with one nice piece of information on the naming conventions used in SSIS. There are different conventions used by different organizations but the ones below seems to be standard across lot of organizations. Using a standard naming convention in your work […]