Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

26 September
2016
Author: Anil
Anil
26 September
2016
Author: Anil
Anil
15 May
2015
Author: DustinRyan
DustinRyan

Generate a Date Table via Common Table Expression (CTE)

Occasionally I find myself needing to generate a small table with a list of dates for various queries I may be running. To do this, I usually leverage the Date dimension since I do most of my work in BI environments with a traditional data warehouse. But if you don’t have access to a Date...
21 March
2015
Author: TyroneBrown

Depreciation Pattern for SSAS Tabular and Power Pivot Data Models

This post is to describe a pattern to measure the depreciation of an expense using DAX in a SSAS Tabular or Power Pivot data model. The pattern accounts for a variable length of depreciation, called here a Depreciation Schedule. The pattern will account for a depreciation expense for an equal...
31 March
2014
Author: MikeDavis
MikeDavis

SSIS Web Service Task

The Web Service task in SSIS can be used to call a web service command to perform a needed operation in your package. The results of most web services will be in XML Format. You can save these results into a variable or into a file. Either way, you can then parse the XML to find the node values...
24 March
2014
Author: MikeDavis
MikeDavis

Using Variables and Parameters SSIS

When creating an SSIS package it is always a best practice to use variables, and parameters in 2012,  to avoid hard coding values into any part of your package. But there are some best practices involved with creating those variables/parameters also. The rest of this article will refer to...
17 March
2014
Author: MikeDavis
MikeDavis

Using Configuration Files in SSIS

Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I still see a lot of my clients using them even on 2012 due to several reasons, but mostly because of the work to convert over. SSIS packages are great ETL tools and can do just about anything...
10 February
2014
Author: MikeDavis
MikeDavis

SSRS – Creating Drill Through reports with MDX

If you are reporting from a Cube in SSRS and you want to drill through to another report you can set up actions just like any other drill through except one small change. The parameter you pass to the drill through report must be changed to Unique Name instead of value. Go to the detailed...
27 January
2014
Author: TyroneBrown

Filter Dropdown SSRS Parameters with a Comma-Delimited List Search Box

I recently encountered an interesting problem when working with a client.  I made an SSRS report that used a multi-select drop down box parameter that used a textbox to search and filter the items in the dropdown parameter.  The query for the drop down list was pretty...
11 August
2013
Author: Roger Wolter

MDS Source Updates

        I ran into an interesting requirement on a recent MDS engagement.  The customer wanted to give a large number of users read-only access to the MDS data.  While they didn’t want most of the users to be able to update the Master Data, they...