What languages are used in SSAS ?

=>  Structured Query Language (SQL) ?    Multidimensional Expressions (MDX) – an industry standard query language orientated towards analysis ?    Data Mining Extensions (DMX) – an industry standard query language oriented toward data mining. ?    Analysis Services Scripting Language (ASSL) – used to manage Analysis Services...
Read More »

What is UDM? Its significance in SSAS?

The role of a Unified Dimensional Model (UDM) is to provide a bridge between the user and the data sources. A UDM is constructed over one or more physical data sources, and then the end user issues queries against the UDM using one of a...
Read More »

What are the roles of an Analysis Services Information Worker?

The role of an Analysis Services information worker is the traditional “domain expert” role in business intelligence (BI) someone who understands the data employed by a solution and is able to translate the data into business information. The role of an Analysis Services information worker...
Read More »

How does Error-Handling work in SSIS?

When a data flow component applies a transformation to column data, extracts data from sources, or loads data into destinations, errors can occur. Errors frequently occur because of unexpected data values. Type of typical Errors in SSIS: –Data Connection Errors, which occur in case the...
Read More »

What is a partition?

A partition in Analysis Services is the physical location of stored cube data. Every cube has at least one partition by default. Each time we create a measure group, another partition is created. Queries run faster against a partitioned cube because Analysis Services only needs...
Read More »

What is environment variable in SSIS?

An environment variable configuration sets a package property equal to the value in an environment variable. Environmental configurations are useful for configuring properties that are dependent on the computer that is executing the package.
Read More »

What is OLAP?

OLAP – On-Line Analytical Processing. Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.
Read More »