Data Warehouse [SSAS] Questions: Notes: What is Data Explosion? Data Explosions are when too many aggregations are made on hierarchies that aren’t used. These aggregations increase exponentially until they become too big and slow down your cube. What is Proactive Caching? The data that Analysis Services needs to respond to a query can exist […]
Data Warehouse [SSAS] Questions: Notes: What is an Action Target? An Action Target is the portion of the cube to which the action relates and is the object that the user clicks to launch the action. What is an Action Expression? The action expression is a Multidimensional Expression that evaluates as a string relevant to […]
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, […]