Data Warehouse [SSAS] Questions: Notes: What are the Storage Modes for Dimensions? The storage modes for dimensions are MOLAP and ROLAP. Dimensions can’t use HOLAP because dimensions do not perform aggregations. Therefore, dimensions can have their data physically stored in their partition files via MOLAP. Or dimensions can read their data from […]
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 […]
