BI Developer Network Community articles

Most Recent Articles

• • 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: 7735
• • 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: 3122
• • 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: 1490
• • 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: 6  -  Views: 1875
• • 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: 1760
• • 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: 39  -  Views: 3316
• • 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: 1921
• • 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: 15  -  Views: 4048
• • 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: 1669
• • 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: 1870
• • 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: 2181
• • 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: 2090
• • 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: 1056
• • 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: 1708
• • 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: 1372
• • 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: 615
• • 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: 1412
• • 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: 1716
• • 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: 8  -  Views: 2450
• • Email
  
  Analysis Services Dynamic Security
  This article explains one method that can be used for dynamically configuring security in Analysis Services. All security information is stored in relational tables making it easier to manage.
  tags : SSAS
  DevinKnight   -  6/17/2010   -  Comments: 16  -  Views: 3812
• • Email
  
  Reporting Services Parameters Not Updating
  In this article, Brian will show you how to map report parameters after modifying stored procedures that didn't have any (or after adding) parameters.
  tags : Reporting Services, Parameters Not Mapping
  briankmcdonald   -  6/13/2010   -  Comments: 0  -  Views: 1821
• • Email
  The Income Statement (3) the sales events.
  Learn what sales events are, to better implement your datawarehouse.
  tags : business excel P&L income statement
  Stray__Cat   -  6/8/2010   -  Comments: 0  -  Views: 563
• • Email
  
  Parent-Child Dimension in Analysis Services
  This article discusses use a Parent-Child dimension in your data warehouse and how you can configure Analysis Services to use a table structured this way. You will also read about an alternative to using a Parent-Child dimension because they can be harmfu...
  tags : SSAS
  DevinKnight   -  6/7/2010   -  Comments: 8  -  Views: 4142
• • Email
  
  Incremental Loads with Change Data Capture - Part 3: Creating the SSIS Package
  In the final article of this series, I will outline the steps required to build a SQL Server Integration Package that uses the change data to build a Slowly Changing Dimension (SCD).
  tags : SQL Server, CDC, SSIS, SCD
  PatrickLeBlanc   -  6/4/2010   -  Comments: 0  -  Views: 1876
• • Email
  
  Report Services 2008 R2 - Data Bar
  In this article, you will learn how use the new data bar control in SQL Server Reporting Services 2008 R2 just released a few short weeks ago.
  tags : Reporting Services 2008 R2, SSRS, Data Bar
  briankmcdonald   -  5/26/2010   -  Comments: 2  -  Views: 3121