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
  • Last name

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

Conditioning the visibility of SSRS columns

In this article, I'm going to show you a real-life example of using the visibility property (Visibility) of the column in SSRS.

Visibility property of the column is used to show or hide the column in the report. Now, in this article, we can use this property to allow users to select the columns they want to display in a report instead of all the columns.

Read More Conditioning the visibility of SSRS columns

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?