Connect a PowerView report to a SSAS Multidimensional (Cube) Source : Quick Tip
Connect a PowerView report to a SSAS Multidimensional (Cube) Source : Quick Tip
Data Warehouse and Business Intelligence Concepts – Simplified
10 Page Guide – Free PDF Download. Download our free PDF Guide to Data Warehousing and Business Intelligence Concepts. The Guide covers Basic concepts of Data Warehousing including: Facts, Dimensions, Star Schemas and Data Warehouse Design. Definitions – Business Intelligence vs Data Warehouse vs Data Mining etc. Extract Transform and Load (ETL). OLAP and Cubes….
Deployment | quick tip | SSIS | Visual Studio
Configuring SSIS Projects for Deployment : Quick Tip
When you build an SSIS Project, you can optionally also generate an SSIS deployment Utility. The Deployment Utility can be used to Deploy the SSIS Packages and Configuration Files on a Server. Below is an example SSIS Project configuration, which will trigger the generation of a Deployment Utility. In the image you can see that…
Deployment | quick tip | SSIS | Visual Studio
Understanding Visual Studio Solution Configuration Manager : Quick Tip
Understanding the Visual Studio Solution Configuration Manager Dialog. Below is an example screenshot of a Visual Studio Solution Configuration. This example shows a solution configuration called DEV. Within the project are two projects called Data_Integration and Data_Integration_Database. Associated with the DEV Solution configuration is the DEV Project Configuration of the Data_Integration and Data_Integration_Database projects. The…
Data Driven Design with Agile for Data Warehousing
An introduction to using Data Driven Design and the Agile Project Methodology to quickly deliver a Data Warehouse.
Getting Started with EzAPI
ezAPI is an API written by the Microsoft SSIS Team which makes it easy to generate SSIS packages programmatically. ezAPI is the API that Dimodelo Data Warehouse Studio uses to generate SSIS packages. This post describes getting started with ezAPI.
Generating SSIS Packages using ezAPI – Hello World
Introduction This is the first in a series of posts describing how to use EzAPI to generate SSIS Packages. This is the classic ‘Hello World’ example describing the very basic getting started usage of ezAPI. The article first describes the simple ‘Hello World’ example then describes a ‘Hello World’ example incorporating Dimodelo Data Warehouse Studio design…
Range Lookups in the SSIS Lookup Transformation
Let’s say, in an SSIS Data Flow which is processing invoices, you wanted to match an invoice to an event based on the date of the invoice falling between the start and end date of the event. To achieve this in a SSIS Lookup Transformation, you need to use advanced configuration. The configuration steps required follow: On…
The Dimodelo Data Warehouse Studio code generation process
This post discusses in detail how Dimodelo Data Warehouse Studio generates code to create and manage a Data Warehouse, including creating and managing Data Warehouse Databases, Tables and ETL procedures. While Dimodelo Data Warehouse Studio has a set of predefined Generation Templates and Generation Providers , it is also extensible, allowing end users to create their own Generation Templates and Generation Providers.
Override SSIS package configurations through an SQL Server 2008 R2 Job
If you thought you could override an SSIS package’s configurations when running it through an SQL Server 2008 R2 Job… think again. In the SQL Server Job Step Properties dialog, there is a Configuration tab that allows you to specify configuration files. The logical assumption is that this will override existing configurations with the same…