blogs.conchango.com

Browse by Tags

• AMO
• ascmd
• Business Intelligence
• cloud computing
• Master Data Management
• MDM
• Microsoft
• Scripting
• SDS
• SQL Data Services
• SQL Server
• SQL Server 2005
• SQL Server Data Services
• SQL Server Integration Services
• ssas
• SSDS
• SSIS
• Teradata
• Writer
• XMLA

• SSIS: Create Analysis Services partitions from a SSIS package

  I have recently been working on a project implementation that incorporated SQL Server Analysis Services (SSAS) and there was a requirement to be able to create partitions on-the-fly from our ETL process running on SQL Server Integration Services (SSIS). Read More... Posted 15 September 2008 14:06 by jamie.thomson | 9 Comments Filed under: SQL Server Integration Services, SQL Server Analysis Services, SSIS, Scripting, ssas, Writer, XMLA, AMO

• SSDS: Will we get a cloud-based aggregation engine?

  I have been keeping a close eye on machinations in the SQL Server Data Services (SSDS) arena and whilst the product hasn't reached the masses yet (I'm still waiting for my beta invite - hint hint) there is a still a lot of activity going on. There is Read More... Posted 05 June 2008 11:05 by jamie.thomson | 2 Comments Filed under: SQL Server, SQL Server Analysis Services, ssas, SSDS, SQL Server Data Services, cloud computing, SDS, SQL Data Services

• Some Analysis Services stuff!

  Its a while since I spoke about Analysis Services on here but today I was getting back into the SSAS groove in a couple of ways. Firstly, I received an email from Microsoft Connect in reply to one of my old suggestions which I opened back in June 2006. Read More... Posted 30 January 2008 04:15 by jamie.thomson | 9 Comments Filed under: SQL Server Analysis Services, Microsoft, MDM, Master Data Management, ssas

• Microsoft vs Teradata

  There's a very good objective article on el reg today that compares the Microsoft and Teradata schools of thinking for providing BI. Read it here: http://www.regdeveloper.co.uk/2007/05/07/microsoft_vs_teradata/ The author doesn't really make any Read More... Posted 07 May 2007 18:14 by jamie.thomson | 5 Comments Filed under: SQL Server Analysis Services, Business Intelligence, Microsoft, Teradata, ssas

• SSAS: Unexplained partition processing events

  As I continue working on an Analysis Services implementation I am learning more and more about the product, some of which is well worth sharing. Today I was attempting to optimise the processing of my cube. I issue processing commands from a parameterized Read More... Posted 26 July 2006 09:52 by jamie.thomson | 1 Comments Filed under: SQL Server Analysis Services, ssas, ascmd, XMLA

• SSIS/SSAS: Process SSAS dimensions and measure groups individually

  On my current project I am implementing SQL Server Analysis Services (SSAS) and recently I was having a problem doing a full process of my cube. I've got many many measure groups in the cube each containing twelve partitions and the cube process was hanging Read More... Posted 18 July 2006 12:56 by jamie.thomson | 17 Comments Filed under: SQL Server Integration Services, SQL Server Analysis Services, SSIS, ssas, XMLA Attachment(s): ProcessAllDimensionsAndMeasureGroups.zip

• SSAS: Thumbs up for the DSV!!!

  A very quick post on Analysis Services Data Source views! Data Source Views (DSV) have been introduced in SQL Server Analysis Services (SSAS) 2005. A DSV is a metadata layer between the cube and the underlying data source that allows us to build our cubes Read More... Posted 11 July 2006 13:08 by jamie.thomson | 1 Comments Filed under: SQL Server Analysis Services, ssas

• SSAS: Clearing the Analysis Services cache

  A long time ago I posted a blog entry explaining how to do an effective restart of SQL Server. I have no idea whether its proved useful to anyone else but it has been invaluable to me because I'm forever needing to know how to do this and I can never Read More... Posted 07 July 2006 14:44 by jamie.thomson | 1 Comments Filed under: SQL Server Analysis Services, ssas, XMLA

• SSAS: Discover the Server Properties

  I've just found an excellent document that has come out of the SSAS team. It details all properties of the Analysis Server (SSAS2005). There's a real multitude of them them so this is an invaluable document. The paper is here: http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/SSASProperties.doc#_Toc136412586 Read More... Posted 27 June 2006 16:08 by jamie.thomson | 0 Comments Filed under: SQL Server Analysis Services, ssas

• SSAS: Bug when changing data directory

  At the back end of last week I found what I thought was a bug in Analysis Services and it has been confirmed as such by Edward Melomed , Program Manager from the SSAS team in Redmond. Its not a biggie, and it is easily fixed, but I thought better to make Read More... Posted 26 June 2006 08:54 by jamie.thomson | 0 Comments Filed under: SQL Server Analysis Services, ssas

• SSAS: Processing follow-up

  Darren Gosbell has read my recent Experiences of processing in Analysis Services 2005 post and come up with a workaround to the problem I mentioned regarding generating the Process command - use Analysis Management Objects (AMO) to do the job for you. Read More... Posted 21 June 2006 14:15 by jamie.thomson | 1 Comments Filed under: SQL Server Analysis Services, ssas

• SSAS: Faulty readme for ascmd.exe

  I've said before that I'm really impressed with ascmd.exe however I've just come across a problem in the documentation that has held me up for a while. ascmd allows you to parameterize xmla scripts from the command-line using the -v option. This is really Read More... Posted 21 June 2006 10:05 by jamie.thomson | 4 Comments Filed under: SQL Server Analysis Services, ssas, ascmd, XMLA

• SSAS: Experiences of processing in Analysis Services 2005

  In the last few days I've been doing alot of work on processing SQL Server Analysis Services (SSAS) 2005 cubes, measure groups and partitions and I thought I'd share some of my experiences here. 1. First up - I'm a huge fan of XMLA . The ease with which Read More... Posted 20 June 2006 19:59 by jamie.thomson | 11 Comments Filed under: SQL Server Analysis Services, ssas, ascmd, XMLA

• SSAS: Aggregation designer in SSAS2005

  I have recently begun a new project where I am working on a SQL Server Analysis Services (SSAS) implementation. I was trying to use the aggregation designer to...well...design some aggregations but I was getting an error: Errors in the metadata manager. Read More... Posted 08 June 2006 09:00 by jamie.thomson | 1 Comments Filed under: SQL Server Analysis Services, ssas

• SSAS: System.Data.OleDb.OleDbException

  A .Net developer colleague of mine was recently trying to connect to SQL Server Analysis Services (SSAS) ona remote server from an ASP.Net app that he was running on his development workstation. Upon doing this he was getting the error that you can see Read More... Posted 27 April 2006 09:29 by jamie.thomson | 1 Comments Filed under: SQL Server Analysis Services, ssas