BI Developer Network Community articles

Most Recent Articles

• • Email
  Slicing and dicing the income statement (2), Sales
  When you design your sales data mart, the first requirement is to be aligned with business sales organization
  tags : P&L Sales Slice Dice
  Stray__Cat   -  5/24/2010   -  Comments: 0  -  Views: 545
• • Email
  
  Replacing a Cursor with SSIS
  Learn how to set up a For Loop in SSIS to replicate the same work performed by a cursor in SQL. The SSIS package will perform much faster than the cursor because the cursor is row by row and the SSIS package performs the data flow in batch.
  tags : SSIS, Cursor, For Loop
  MikeDavis   -  5/20/2010   -  Comments: 10  -  Views: 3860
• • Email
  
  SSRS Parameters and Their Labels
  In this article, I will quickly show you an example of how to use the Label property of the Parameters collection.
  tags : Reporting Services, SSRS, Parameters, Parameter Labels
  briankmcdonald   -  5/17/2010   -  Comments: 5  -  Views: 1725
• • Email
  
  Local SQL Server Logins
  In this article, I explain how to troubleshoot permissioning issues when you create SQL Server Logins and are unable to log into the SQL Server instance.
  tags : SQL Server Logins, Security
  briankmcdonald   -  5/4/2010   -  Comments: 0  -  Views: 560
• • Email
  Slicing and dicing the income statement (1), organization
  The managerial P&L at company total, it is hardly enough for management. Albeit slicing requires "just another dimension" for techies, let's see what the business meaning is.
  tags : P&L units lines business
  Stray__Cat   -  4/30/2010   -  Comments: 0  -  Views: 637
• • Email
  
  Parallel Loads in SSIS
  In this article, Brian shows you how to create a parallel load in SSIS. After this article, you'll be able to create a workload table to parallelize a data flow on multiple servers or on a single server with multiple cores.
  tags : ssis parallel loads, ssis, performance tuning
  BrianKnight   -  4/26/2010   -  Comments: 9  -  Views: 3977
• • Email
  
  Using SSIS to Convert EBCDIC to ASCII
  Learn how to convert EBCDIC data to ASCII without using any script components.
  tags : SSIS, EBCDIC, ASCII, Packed Decimal, Comp-3, Zoned
  MikeDavis   -  4/23/2010   -  Comments: 9  -  Views: 4119
• • Email
  SSRS – Passing Dataset to Sub-report
  In this article I will provide the steps required to pass a dataset from a master data set to a sub-report.
  tags : SSRS, Subreports, Data Set
  PatrickLeBlanc   -  4/16/2010   -  Comments: 2  -  Views: 3494
• • Email
  
  Using SQL Checksum in SSIS
  Learn how to use the checksum transform in SQL and in SSIS.
  tags : SSIS, SQL, Checksum, Update, Insert, Data, Warehouse
  MikeDavis   -  4/16/2010   -  Comments: 12  -  Views: 4572
• • Email
  How managers use the Income Statement that you have created for them.
  Managers looks to your reports with a different look than yours. Let's see what they say and you do not when watching the same income statement.
  tags : Income Statement datamart current previous year budget
  Stray__Cat   -  4/12/2010   -  Comments: 2  -  Views: 1143
• • Email
  Income: What Companies Live and Die for, or the Income Statement.
  Some of your customers still think that selling is the point. It is not, or, at least it is only a part of the point. What you should teach your customers to keep an eye on is named Income.
  tags : income statement
  Stray__Cat   -  4/5/2010   -  Comments: 0  -  Views: 1651
• • Email
  Putting the business back in BI
  We've been talking too much about technologies, myself included. We often see ourselves as very specialized technicians, but the best way to serve our customers is to have a firm grasp on their business. This is the introductory article of a group dedicat...
  tags : business analysis project management
  Stray__Cat   -  4/1/2010   -  Comments: 0  -  Views: 661
• • Email
  SSIS Solution Framework - Configurations
  The second article in the SSIS Solution Framework series - this article covers package configurations
  tags : SSIS Vertical Design Pattern Framework Project Solution Package Configuration
  MarkGStacey   -  3/28/2010   -  Comments: 4  -  Views: 1313
• • Email
  SSIS Solution Framework
  The introductory article to a 5 part series on a SSIS Solution Framework that allows for code reuse and eases maintenance
  tags : SSIS Vertical Design Pattern Framework Project Solution
  MarkGStacey   -  3/28/2010   -  Comments: 3  -  Views: 1748
• • Email
  SSRS – Creating a Master/Detail Report
  In this article I will outline the steps needed to create a Master/Detail report using SSRS 2008.
  tags : SSRS
  PatrickLeBlanc   -  3/23/2010   -  Comments: 2  -  Views: 2943
• • Email
  Incremental Loads with Change Data Capture – Part 2: Detecting Changes
  In this article I will provide you with a detailed explanation of how to identify changed data using the CDC tables and functions.
  tags : Warehousing, CDC, SSIS
  PatrickLeBlanc   -  3/19/2010   -  Comments: 2  -  Views: 1827
• • Email
  
  SSIS 2008 lookup Altering the SQL statement
  Learn how to alter the SQL statement in a Lookup transform.
  tags : SSIS 2008 Lookup SQL Statement Partial Cache
  MikeDavis   -  3/17/2010   -  Comments: 10  -  Views: 2648
• • Email
  Using Checkpoints in SSIS
  When executing SSIS packages, there is always the chance that something could go wrong and cause the package to fail. This can be extremely frustrating if you have a package that affects multiple tables and takes a considerably long amount of time to run....
  tags : SSIS, checkpoints
  ShawnHarrison   -  3/15/2010   -  Comments: 0  -  Views: 1869
• • Email
  Everything you need to know to develop your first SSIS package
  This arcticle covers all of the basics that one should know before developing an SSIS package.
  tags : SSIS
  kylewalker   -  3/1/2010   -  Comments: 4  -  Views: 1546
• • Email
  Applying Security to Calculated Measures
  Tired of not being able to secure your Calculate Measures through SSAS? One of the biggest issues facing Analysis Services Developers these days is applying security to calculated measures through roles. The problem is with the default behavior exhibited ...
  tags : SSIS, Calculated Measure, Security
  AdamJorgensen   -  2/21/2010   -  Comments: 1  -  Views: 1797
• • Email
  Use SQL from the Command Line
  In this article Brad will describe how to use SQLCMD for using SQL from the command line. He will also show you how to implement this into your SSIS package to create an output file of a stored SQL Query. Also covered are some of the common commands used ...
  tags : SQL, SSIS
  BradSchacht   -  2/17/2010   -  Comments: 2  -  Views: 1072
• • Email
  SSIS Master or Parent Package Handling Child Errors
  Learn how to call child packages and handle errors between them.
  tags : SSIS, Master, Parent, Package, Handling, Child, Errors
  MikeDavis   -  2/17/2010   -  Comments: 0  -  Views: 1903
• • Email
  This Year - Last Year SSAS Calculated Member
  In this quick demo I’m going to add a calculated member to the AdventureWorks cube that allows an end user to do a This Year/ Last Year comparison for a given measure.
  tags : Calculated Members, Calculated Measures, SSAS, Analysis Services
  tinocash   -  2/16/2010   -  Comments: 1  -  Views: 2283
• • Email
  Using SSIS to Automate the Creation of Cube Partitions
  This article will show you a method for using SSIS to create SSAS partitions in and automated process. No longer will you have to create partition in the designer. Create an SSIS package to do all the work for you the schedule it to run when needed.
  tags : SSAS, Partitions, SSIS
  DevinKnight   -  2/2/2010   -  Comments: 14  -  Views: 2617
• • Email
  Setting up Many to Many in SSAS 2008 Cube
  Learn how to set up a many to many relationship in SSAS 2008.
  tags : SSAS Cube Many-to-Many Many to Many Relationship Fact Dimension
  MikeDavis   -  1/26/2010   -  Comments: 20  -  Views: 3588