Dynamic Partition Management SSAS - 1 Part

Working on a data warehouse at a high volume can cause us performance problems to process or query the SSAS Cube.

To fix this kind of problem, you will have to partition the cube, but not just any way, you have to have a well-defined dynamic SSAS partitioning plan.

Let's see how we can design this plan in a BI project ☻

Before starting the implementation of this partitioning plan we will talk in this 1ère part of this article on the advantages and disadvantages of SSAS partitioning.

Read More Dynamic Partition Management SSAS - 1 Part

Create a Time Dimension with SSAS (DimTime) - 2 Part

After creating our DimTime table in the 1ages part of this article, we will now make some improvements on our dimension.

From experience, I would recommend using a key PKDate int type in format yyyymmdd.

This type of key will allow you to get better performance.

This coding in the format yyyymmdd should be generalized at all levels of our axis time: year, semester, quarter, month, week ... So I suggest that each level (year, semester, quarter, month, week, day) be composed of three distinct attributes:

  • Code
  • Date
  • Name

Read More Create a Time Dimension with SSAS (DimTime) - 2 Part

Create a Time Dimension with SSAS (DimTime) - 1 Part

The dimension Time (DimTime) plays a very important role in a decision-making system, its presence is obligatory in the tables of facts which characterizes a decision-making system compared to a transactional system.

In the rest of this article, we will create the table DimTime using an SSAS project wizard.

Read More Create a Time Dimension with SSAS (DimTime) - 1 Part

Feedback (MCSE BI)

Last week, I passed my final exam to acquire the MCSE BI, I want to share with you this feedback especially on my preparation for all exams, it is not a strict guideline of course, but it just what was best for me.

The MCSE certification consists of passing 5 separate exams: the first 3 give you the MCSA SQL Server certification:

Read More Feedback (MCSE BI)

ADOMD.NET?

In this article we will see how to use ADOMD to interact with an Analysis Services cube.

ADOMD.NET is an extension of ADO.NET. It is a data provider Microsoft .NET Framework that is designed to communicate with Microsoft SQL Server Analysis Services.

Using this extension, we can read the multidimensional schema, query cubes, and retrieve results.

Read More ADOMD.NET?