What are types of storage modes in OLAP?

OLAP storage modes
There are three standard storage modes in OLAP they are
1.MOLAP — the data and aggregations are stored in a multidimensional format
2.ROLAP — data and aggregations are kept in the relational database instead of on the OLAP server
3.HOLAP — HOLAP is a combination of MOLAP and ROLAP HOLAP stores the detail data in the relational database but stores the aggregations in multidimensional format

What are types of storage modes in OLAP? was last modified: October 1st, 2017 by Justin Antony

DAX Aggregate and count Function

DAX Aggregate count Function

= Sum(Sales[Amt])

Four functions in count are
COUNT — Numeric Column
COUNTA — Count Any Column of any datatype
COUNTBLANK — Count empty cells
COUNTROWS — No of rows in a table

The Aggregate function ending with x calculate an expression (Second Parameter)
SUMX, AVERAGEX, COUNTX, COUNTAX, MINX, MAXX, DISTINCTCOUNT

cost:= SUMX(sales, sales[qty]* RELATED(Product[StdCost]))
— calculate Sum of sold quantity * standard cost from the product table for each row of sales (parameter 1)
Other words each parameter value 1 row the corresponding parameter 2 value will be calculated and return the aggregated result.

DAX Aggregate and count Function was last modified: October 1st, 2017 by Justin Antony

What is an SQL ?

SQL

SQL is a standard language for accessing databases. use SQL to access and manipulate data in: MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.

What is an SQL ? was last modified: October 1st, 2017 by Justin Antony