BIML – Script Naming Convention

Hi, Many times in the past working on the BIML on large projects, I have came across this issue of mixing up the scripts during execution time and scratching my head for hours on not obtaining the required output. As at times in BIML you have to multi-select the various scripts which all tie in Read More …

BIML – An Introduction

Hi, In this post I would like to introduce an up-coming star in the BI world termed as “BIML” !!! BIML – Business Intelligence Markup Language and for more information please navigate BIML Wiki Now to my discovery of the language so far has definitely suggested me some great potential with BIML in the BI Read More …

Date From and To Calculations – SQL

Hi, This is another quick post on some of my past challenges faced with “From” and “To” date queries. Many times in the business BI modelling there are instances where computed measures are on daily basis, but the storage of the entity in the questions is on a From-To basis. (Even consider Slowly Changing Dimension Read More …

Dates Dimension Data Generation – MS SQL

Hi, In this post I would like to put out some SQL to get my Dates table ready for some SSAS date dimensions. Most of the times SSAS in itself is capable to achieve the same on its own via fancy UI’s during creation of similar dimensions, but the below SQL statements would come in Read More …