Data Warehouse [SSAS] Questions: Notes: What is the Unprocess mode? Drops the data in the object specified and any lower-level constituent objects. After the data is dropped, it is not reloaded. This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions. What is the Process Structure mode? […]
Data Warehouse [SSAS] Questions: Notes: What is the Process Full mode? Processes an Analysis Services object and all the objects that it contains. When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. This kind of processing is […]
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 […]