Category Archives: MSBI

ROLAP, MOLAP and HOLAP

I always see a lot of confusion among most of my students with regards to these three terminologies. Let’s have a quick talk on them. When we create Cube in SSAS, it consist of two things – Dimensions data and partitions. Partitions hold measure group data. By default for every measure group one partition will

Read More

Tabs in the SSAS cube designer

What We will learn? While creating cube using SQL server data tools or Business intelligence development studio we came across many tabs in the designer window. Let’s understand each one of the tab in short. 1. Cube structure a. Shows the current structure of the cube. Shows the available dimensions, Facts and relationships between them

Read More

%d bloggers like this: