Page 55 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes Self Assessment

Fill in the blanks:
10. A metadata block is a named group of ................................... in a specific format.
11. A metadata piece is a ...................................... that describes characteristics like author, name,
and rating.
12. The simplest .................................. is an expression to get a query reader/writer for an exact
metadata block.
13. In the query language, all indexes start at ....................................
14. The query dialect is not case sensitive and treats all individual features as ........................

4.5 Spread Sheet Formulas

In OLAP we have about 5 kinds of calculations:
1. Aggregations
2. Matrix Calculations

3. Cross Dimensional Calculations
4. OLAP Aware functions
5. Procedural Calculations

Aggregations are simply addition. Adding days into weeks, weeks into months, and so on or
individual customers into customer groups, families etc.
Matrix calculations are like what you would do in a spreadsheet, with arbitrarily complex
relationships (+,-,*,/, sum, count, and more) both across the row and down the columns.
Calculations like variance, variance %, total, count, inventory balances, etc. for example.

Cross dimensional calculations are like what you would do in linked spreadsheets, or in a
multidimensional spreadsheet. In these, computed results can refer to numbers in another sheet
in the cube, over distinction dimensions or different hierarchies, not just on the same spreadsheet
you are on. Calculation examples include product share, market share, etc.
OLAP Aware Functions are like spreadsheet functions that have been extended to understand
OLAP. These encompass statistics, forecasting purposes, economic purposes, time calculations.
Just like a spreadsheet, most OLAP servers have some hundred OLAP aware formulas provided.

Example: A single OLAP aware function we could assess a benchmark deviation, a
variance, an interest fee, etc. across all dimensions.
Beyond what a spreadsheet does these purposes work across dimensions and realise OLAP
notions like parents, young kids, ancestors, time intelligence, etc.
Procedural calculations are the one in which specific calculation rules are defined and executed
in a specific order. For example, a per cent of revenue contribution is procedural calculation.
Profitability analysis is also an example of procedural calculation. It requires procedural logic
to model and execute rules that reflect the business.

50 LOVELY PROFESSIONAL UNIVERSITY