Data Warehouse [SSAS] Questions: Notes: What is the Trend Expression? The Trend expression is used to compare the current Status value with the value of Status at a previous point in time. As with status, you can assign a graphic to illustrate whether the trend is positive, negative, or neutral. What if KPIs become complicated […]
Data Warehouse [SSAS] Questions: Notes: OLAP is a structure for analytical data. The OLAP is there to analyze business processes. What is ERP? ERP is known as Enterprise Resource Planning. Enterprise resource planning (ERP) systems integrate internal and external management information across an entire organization, embracing finance/accounting, manufacturing, sales and service, customer relationship management, […]
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 […]