Browse by Tags

All Tags » C# (RSS)
15 March 2012 13:05

SSAS: Utility to check you have the correct data types and sizes in your cube definition

This blog describes a tool I developed which allows you to compare the data types and data sizes found in the cube’s data source view with the data types/sizes of the corresponding dimensional attribute. Why is this important? Well when creating named...
Posted by DrJohn | with no comments
Filed under: ,
24 February 2012 14:19

SSAS: Utility to export SQL code from your cube's Data Source View (DSV)

When you are working on a cube, particularly in a multi-person team, it is sometimes necessary to review what changes that have been done to the SQL queries in the cube's data source view (DSV). This can be a problem as the SQL editor in the DSV is...
Posted by DrJohn | with no comments
Filed under: ,
07 February 2011 18:07

SSIS: Deploying OLAP cubes using C# script tasks and AMO

As part of the continuing series on Building dynamic OLAP data marts on-the-fly , this blog entry will focus on how to automate the deployment of OLAP cubes using SQL Server Integration Services (SSIS) and Analysis Services Management Objects (AMO). OLAP...
Posted by DrJohn | 1 comment(s)
Filed under: , , , ,
23 April 2008 14:17

SSAS Stored Procedures - connecting to the transactional data source

There are often circumstances where an SSAS stored procedure needs to connect to the transactional database to perform a query. This is certainly the case in a near-real-time OLAP solution where the cube sits directly on top of the application database...
Posted by DrJohn | 1 comment(s)
Filed under: ,
02 November 2007 08:53

Converting C# to VB.NET for use in SSIS

If you much prefer C# over VB.NET but are forced to use VB.NET as that is the only language supported by SSIS, you will love the tool I discovered. Some cool guys over at DeveloperFusion have created an on-line C# to VB.NET convertor which makes the transition...
Posted by DrJohn | 2 comment(s)
Filed under: ,