Dynamic Partition Management SSAS - 2 Part

Here we are in the 2th part of this article where there is less blah blah but more practice (putting our hands in the leg !!)

In this part, I will explain the steps to follow step by step to create the cube partitions in a dynamic way.

  • Step 1 :

First, prepare the test data, for that, we will work with the database and the cube AdventureWorksDW, you can download the sources as well as the deployment scripts from the links below:

Read More Dynamic Partition Management SSAS - 2 Part

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

Set up a lookup

Using a parameterized query in a lookup can lighten the cached data, especially in the case of iterative processing, and you do not have to load all the data into the cache.

Even though the lookup component does not offer the ability to use variables but it does have the property SqlCommand which allows to specify the query of the lookup and that can be parameterized.

Read More Set up a lookup

Clustered Vs Non-Clustered Index

The difference between the index clustered et Non-clustered in a database is one of the most popular questions in SQL.

Indexes are a very important concept, it makes the execution of your queries fast and if you compare a query SELECT which uses a column indexed to the one that does not, you will see a big difference in performance.

Read More Clustered Vs Non-Clustered Index

MDX functions based on time

A bit of MDX to start the week, it feels good?

As you have already seen in the title, the purpose of this article is to share with you some time-based MDX functions that are very useful.

Time is an essential component for business analysis. Analysts interpret the state of the business now, often compared to what it was in the past, in order to understand what it might be in the future.

To support this, Analysis Services provides a number of time-based MDX functions, here are some of them:

Read More MDX functions based on time