BI Developer Network Community

Most Recent Articles

• 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    kylewalker- Comments: 2
• 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    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    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    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    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    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    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    DevinKnight- Comments: 1
• SSRS: Information about reports ran
  This article provides information about reports ran. In this article I show how can you know how often a reports is requested, it's duration, exporting format, users who ran the reports among other useful information.
  ssrs, reports ran, ExecutionLog, reportserver, slowest reports
  1/23/2010    marcoadf- Comments: 0
• MetaData Driven ETL (MDDE) System
  Interesting approach to tedious ETL development for systems with large amounts of source data - only accessible via ODBC
  MDDE ETL MERGE
  1/16/2010    howarddiesel- Comments: 2