Category Archives: BI

Date continued

When you have the DateID as an int that represents a real date it can be good to be able to use SSIS to convert datetime to int in an easy way. In this blog post by Mike Davis shows … Continue reading

Posted in BI, SSIS | Tagged , , , , , | Leave a comment

Page numbers in SSRS when exporting to word

Recently I had some problems when developing a report in SSRS that needed to be exported to word. In the page header I wanted to display the page number in the following format: page x(y) Should be simple enough =”Sida … Continue reading

Posted in BI, IT, SSRS | Tagged , , , , , , , | Leave a comment

Creating and populating a date dimension with Swedish or Norwegian weeks

Quite often when you work with analyzing data you need to be able to see your KPI’s per day, week or some other time-frame. Both Sweden and Norway has a fairly unusual way to handle week numbers which might make … Continue reading

Posted in BI, IT | Tagged , , , , , , , | Leave a comment