SQL Archives - Turning data into powerful insights

12 August 2016Ousama EL HOR No Comments

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

After creating our DimTime table in the 1^st 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:

--
Reserve
Name

January 28 2016Ousama EL HOR No Comments

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.

1 December 2015Ousama EL HOR 2 Comments

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.