Dynamic management of SSAS partitions - part 1

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

To remedy this kind of problem, you will have to partition the cube, but not just any old way, you really need 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 management of SSAS partitions - part 1

 

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

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 codification in yyyymmdd format should be generalized to all levels of our time axis: year, semester, quarter, month, week ... I therefore suggest that each level (year, semester, quarter, month, week, day) be made up of three distinct attributes:

  • Code
  • Date
  • Name

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

 

Create a Time dimension with SSAS (DimTime) - 1st 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) - 1st part

 

Feedback (MCSE BI)

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

The MCSE certification consists of taking 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's 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?