BI Developer Network Community articles

Most Recent Articles

• • Email
  
  Monitoring Reporting Services Subscriptions
  In this article Devin shows a method for monitoring Reporting Services subscriptions by designing a set of reports. The first report displays subscription executions while the second will rerun subscriptions on demand.
  tags : SSRS
  DevinKnight   -  10/20/2010   -  Comments: 11  -  Views: 4041
• • Email
  
  Getting Started With DAX in PowerPivot
  In this article you will get a quick introduction the DAX, the formula language used in PowerPivot. With this tutorial you will get a start on modifying PowerPivot data.
  tags : PowerPivot, DAX
  DevinKnight   -  10/20/2010   -  Comments: 2  -  Views: 3429
• • Email
  
  User Preferences and Styling
  In this article, Brian will show you how to create themes and use them withing SQL Server Reporting Services. These examples were created in SSRS 2005, but could easily be used in 2008 and R2 as well.
  tags : SSRS, Themes
  briankmcdonald   -  10/6/2010   -  Comments: 10  -  Views: 2038
• • Email
  
  Writing Parametrized MDX for Reporting Services
  In this article, you will learn how to write your own MDX inside of Reporting Services and actually add parameters to the your query. No longer will you be forced to use the Query Designer!
  tags : SSRS, MDX
  DevinKnight   -  9/30/2010   -  Comments: 7  -  Views: 2717
• • Email
  
  Reporting on an SSAS Cube with SSRS 2008
  In this article, Dustin gives you an introduction on building a report on a cube using the MDX Query Designer.
  tags : SSRS 2008, MDX query, MDX query designer, SSRS cube report
  DustinRyan   -  9/30/2010   -  Comments: 7  -  Views: 7337
• • Email
  
  Remove Duplicates from Tablix by Grouping
  In this article, Brian will show you one way that you can get a distinct listing of values in a Tablix. Although it is rare to have to use this method, I have had to resort to this to solve a unique problem.
  tags : SSRS, Remove Duplicates, Groups
  briankmcdonald   -  9/29/2010   -  Comments: 7  -  Views: 3878
• • Email
  
  Creating 1000 Per member Per month Calculation in SSAS
  Learn how to create the 1000pmpm calculation in SSAS. Learn how to easily create this popular calculation called “Per Member Per Month Per 1000” calculation or the “Per Customer Per Month Per 1000” calculation.
  tags : SSAS, 1000pmpm, Calculation, MDX
  MikeDavis   -  9/3/2010   -  Comments: 1  -  Views: 8351
• • Email
  
  SSIS - Using the Merge Join Transform
  Learn how to use the Merge Join transform in SSIS. Learn what the join options are and what the results will look like.
  tags : SSIS, Merge Join
  MikeDavis   -  8/30/2010   -  Comments: 5  -  Views: 3951
• • Email
  Replace Your Aggregate Transform With T-SQL
  This article covers some of the basic T-SQL aggregate functions. It is a great way to replace the Aggregate Transform in SSIS and improve SSIS package performance.
  tags : T-SQL, Aggregate, MAX, MIN, COUNT
  BradSchacht   -  8/26/2010   -  Comments: 0  -  Views: 2086
• • Email
  
  Sorting Varchar as Number with T-SQL and SSIS
  Learn how to sort a Varchar or any string column as numeric even when there are multiple separators between the varchar numbers. Learn how to do this in T-SQL as well as SSIS.
  tags : Sorting, Varchar, Number, T-SQL, SSIS
  MikeDavis   -  8/16/2010   -  Comments: 7  -  Views: 2491
• • Email
  SQL Server Parallel Data Warehouse (Madison) Introduction
  This article covers the basics of the PDW (Parallel Data Warehouse Architecture) and dives into why it is a good fit for some organizations. Adam also jumps in and discusses creating some new object types in this new type of environment.
  tags : PDW, SQL Server Data Warehousing, Parallel Data Warehouse, Madison
  AdamJorgensen   -  8/11/2010   -  Comments: 0  -  Views: 2487
• • Email
  
  MDX Time Calculations Done the Right Way
  In this article Devin shows you a unique way of writing time calculations. These calculations are dynamic so no matter what measure is used it will show it YTD, Previous Period, etc...
  tags : SSAS, MDX
  DevinKnight   -  8/11/2010   -  Comments: 45  -  Views: 4621
• • Email
  
  Creating your first Data Mining Structure and Model
  Learn how to built a Data Mining Structure and Model. Understand how a view is set up to support the Data Mining.
  tags : SSAS, Data Mining, Mining Structure, Mining Model
  MikeDavis   -  8/10/2010   -  Comments: 2  -  Views: 2611
• • Email
  MDX Scripting with SCOPE Statement
  In this article, Dustin gives you an introduction on using a SCOPE statement to apply custom calculations to specific subcubes within the Adventure Works cube.
  tags : MDX, SCOPE statement, MDX Scripting
  DustinRyan   -  8/4/2010   -  Comments: 21  -  Views: 5237
• • Email
  Loading Parameter Values – Hard Way vs Easy Way
  In this article, Brian is going to show you how you can either choose the hard way and manually load a parameter list with many options or just write a script that loops through and creates the results for you.
  tags : Loading Parameter Values, SSRS
  briankmcdonald   -  7/29/2010   -  Comments: 5  -  Views: 2194
• • Email
  
  Edit/Select Top N Rows in SQL Server Management Studio
  In this article, Brian will show you how to quickly modify the default settings of SQL Server Management Studio (SSMS) to enable editing of more than top 200 rows. He will also show you how you can set the results to return more than the default 1000 rows...
  tags : SQL Server Management Studio, Edit top , Select Top
  briankmcdonald   -  7/29/2010   -  Comments: 0  -  Views: 2520
• • Email
  
  Creating a Hierarchy Using SSAS 2008
  In this article, Brian is going to walk you through the steps to create a date hierarchy in SQL Server Analysis Services 2008.
  tags : Hierarchies using SSAS 2008
  briankmcdonald   -  7/22/2010   -  Comments: 0  -  Views: 2855
• • Email
  
  Dimensional Data Model -- General Concepts
  This article covers the general concepts of data modelling in simple terms. A very brief overview of dimensions and measures is provided.
  tags : Dimensional data, concepts, BI basics
  indupriya   -  7/20/2010   -  Comments: 0  -  Views: 2803
• • Email
  
  Excel Data Load Truncation Error
  This article gives an explanation of and a solution to a truncation failure that can occur when loading from an excel data source. The engine that brings in the data will be examined and solutions will be laid out. There is a demonstration section that ca...
  tags : Excel Source, Truncation Error, Data Load, Registry Keys, TypeGuessRows
  DanMatisis   -  7/18/2010   -  Comments: 1  -  Views: 1675
• • Email
  
  Creating a New System Role in SSRS
  In this article, Brian will show you how to create a new system role that can be used to give permissions to see the report builder button when using the Report Manager application.
  tags : SSRS, System Roles, Report Builder Access
  briankmcdonald   -  7/16/2010   -  Comments: 0  -  Views: 2347
• • Email
  
  Import and Export Wizard in SSMS -- Step by Step
  In this article I will show you how to use the import export wizard in SSMS. This article has two parts – 1. Importing data from an external source(Excel) into the sql server database 2. Exporting data from sql server database into an external source (Exc...
  tags : Import and Export wizard, SSMS
  indupriya   -  7/14/2010   -  Comments: 0  -  Views: 2020
• • Email
  Slicing and dicing the income statement (4), costs
  Let's see why costs in a P&L are arranged in a specific way.
  tags : Management, costs P&L, income statement, datamart
  Stray__Cat   -  7/12/2010   -  Comments: 0  -  Views: 856
• • Email
  Creating dimensions in SSAS 2005 and 2008 -- differences
  This article discusses the procedure to create dimensions in SAS 2005 and 2008. In both SSAS 2005 and 2008 we can create dimensions using wizards. The biggest difference is in 2005 the wizard asks lot more questions than in 2008. In 2008 the wizard is a l...
  tags : SSAS 2005, SSAS 2008
  indupriya   -  7/6/2010   -  Comments: 0  -  Views: 1979
• • Email
  
  Introduction to LOB data types in SSIS: Part 1
  The first in a two part article series introducing how SSIS works with Large Object data types. It will provide a glimpse at how SSIS handles LOBs and provide instructions for monitoring associated SSIS resource usage.
  tags : perfmon, Performance monitor, BLOB, LOB, collector sets, Buffers, counters, Large Object
  DanMatisis   -  7/3/2010   -  Comments: 1  -  Views: 2443
• • Email
  
  Using SSIS and WinRAR to Zip Files in a Folder
  In this article, Brian will walk you through step by step instructions on how to create a package that will utilize the SSIS Execute Process Task to run WinRAR in order to zip up the files in a folder.
  tags : SSIS, Execute Process Task, WinRAR, Zip Files
  briankmcdonald   -  6/17/2010   -  Comments: 11  -  Views: 3601