BI Developer Network Community articles

Most Recent Articles

• 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....
  SSIS, checkpoints
  11 hours, 39 minutes ago    ShawnHarrison- Comments: 0
• 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.
  MDX, SCOPE statement, MDX Scripting
  3/15/2010 9:57:26 AM    DustinRyan- Comments: 1
• 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.
  SSIS
  3/1/2010 12:52:25 AM    kylewalker- Comments: 3
• 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 ...
  SSIS, Calculated Measure, Security
  2/21/2010 6:05:32 PM    AdamJorgensen- Comments: 0
• 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 ...
  SQL, SSIS
  2/17/2010 11:50:27 AM    BradSchacht- Comments: 0
• SSIS Master or Parent Package Handling Child Errors
  Learn how to call child packages and handle errors between them.
  SSIS, Master, Parent, Package, Handling, Child, Errors
  2/17/2010 10:56:29 AM    MikeDavis- Comments: 0
• 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.
  Calculated Members, Calculated Measures, SSAS, Analysis Services
  2/16/2010 9:53:29 PM    tinocash- Comments: 1
• 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.
  SSAS, Partitions, SSIS
  2/2/2010 6:01:42 PM    DevinKnight- Comments: 4
• Setting up Many to Many in SSAS 2008 Cube
  Learn how to set up a many to many relationship in SSAS 2008.
  SSAS Cube Many-to-Many Many to Many Relationship Fact Dimension
  1/26/2010 2:23:44 PM    MikeDavis- Comments: 9
• Developing an End to End Data Mining Report
  In this article you will learn how to develop an End to End Reporting Services report using a Data Mining dataset. The article assumes you already have a data mining model created but if you do not a sample is provided.
  SSRS, Data Mining, SSAS
  1/24/2010 5:25:59 PM    DevinKnight- Comments: 1