Archive

Archive for the ‘MSBI’ Category

CUBE


Cube: Collection of dimension table and Fact table with their relation(At least one relation should be there).

Or
Cube is a entity where we can measure the business.

 

http://www.youtube.com/watch?v=NqjouppFzQQ

Advertisements
Categories: MSBI Tags:

what is schema in data warehouse?


what is schema in data warehouse

Schema: How the dimension and fact tables having the relation in the database.

Type of Schema:
Star: If the fact table is directly related with all dimension tables, then it will be Star Schema.
Snow flake: If your schema is not a star, then it will be Snow flake schema

Stat Schema will give good performance.

Most of the projecta will have Snow flake schema.

what is dimension and fact tables in data warehousing?

SSAS Data Source View

Categories: MSBI Tags: ,

Why we need to create Named Query in SSAS instead of using Normal View

Difference between View and Named Query in SQL

SSAS

Categories: MSBI Tags: