SSAS architecture

 
SSAS Architecture

SSAS architecture:

SSAS can have different types of database. The Data Base has a mining objects as well as OLAP (Online analytic processes). The application connects to the particular Data type and Analysis service.
Analysis Services is name as "<Server Name> or <Instance Name>".

Parts of SSAS architecture:

  1. Server objects
  2. Database object
  3. Dimension object
  4. Cube objects
  5. Security Role
  6. Server objects
The Server object represents the server. It represents the examples of MS SQL Server Analysis Services.

Server object provides the below specification:

You can get all database at one connection.
The assemblies of collections, roles of collections.
Traces of collection.
It tells the product name.
It tells the product version and edition.

Database Object:

The Database Object is a container. It stores all data objects for Business intelligence project. It has a Data mining structure, dimensions, OLAP cubes.

Database objects work extend to the objects and attributes below criteria's:

You can access total cubes of a collection.
Access all the dimensions of collections.
We can estimate the size of a database.
The total data source views and data sources, as two collections.
All database permissions and roles as two collections.
SSAS can have different types of database. The Data Base has a mining objects as well as OLAP (Online analytic processes). The application connects to the particular Data type and Analysis service.
Analysis Services is name as "<Server Name> or <Instance Name>".

Parts of SSAS architecture:

  1. Server objects
  2. Database object
  3. Dimension object
  4. Cube objects
  5. Security Role
  6. Server objects
The Server object represents the server. It represents the examples of MS SQL Server Analysis Services.
Server object provides the below specification:
You can get all database at one connection.
The assemblies of collections, roles of collections.
Traces of collection.
It tells the product name.
Product version and edition.

Database Object:

The Database Object is a container. It stores all data objects for Business intelligence project. It has a Data mining structure, dimensions, OLAP cubes.

Database objects work extend to the objects and attributes below criteria's:

You can access total cubes of a collection.
Access all the dimensions of collections.
We can estimate the size of a database.
The total data source views and data sources, as two collections.
All database permissions and roles as two collections.

Dimension Object:

A Dimension object is build of basic attributes and hierarchies. The basic information having a type of the dimension and data source, storage mode. It Attributes are describing the actual Data in the dimension.

Cube Object:

Cube object is build of basic attributes and hierarchies, basic information. The basic information has a type of the dimension and data source and storage mode. Attributes describe the actual Data in the dimension. The cube object Measure groups are sets of measures in the cube. It measure group is a collection of measures, that have a common data source view and a common set of dimensions. Cube object measure group is the unit of a process for measures. It Measure groups can process single and then browsed.

Security Role:

SSAS is a security control by using permissions and roles. Roles is also called as a group of users. Users can call members can be removed or add from roles.
The Dimensions object is build of basic attributes and hierarchies. It has basic information. The basic information having a type of the dimension and data source, storage mode. Attributes describe the actual Data in the dimension.

Cube Object:

Cube object is build of basic attributes and hierarchies, basic information. The basic information has a type of the dimension and data source and storage mode. Attributes describe the actual Data in the dimension. The cube object Measure groups are sets of measures in the cube. It measure group is a collection of measures, that have a common data source view and a common set of dimensions. Cube object measure group is the unit of a process for measures. It Measure groups can process single and then browsed.

Security Role:

SSAS is a security control by using permissions and roles. The Roles are nothing but a group of users. Users can call members can be removed or add from roles.

Previous
Next Post »