KPI’s are quantifiable measures that represent critical success factors, and analysts use them to measure company performance over time, against a predefined goal. For example, sales profit, Revenue Growth, and Growth in Customer base are good KPI Candidates. KPIs are typically used as part of a strategic performance measurement framework, commonly known as a business […]
These are notes l’m sharing for any one interested in SSAS 1. Attribute Hierarchy (All level and key level) 2. User Defined Hierarchy (Multiple Levels) By default SSAS will create a hierarchy called – attribute hierarchy (All level and key level) Natural hierarchies – If the parent level and child level in the hierarchy has […]
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 […]